Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¡¾ÇóORACLE°æ±¾ÏÂÔØ¡¿

±¾ÈËϵͳWIN7
Ìý˵ ¿ÉÒÔ×°Oracle10.2.1 ºÍ11
²»ÄÜ×°Oracle9i

Çó¸öÏÂÔØËÙ¶È¿ìµãµÄOracle10.2.1ºÍ11 µÄÁ´½Ó

ллÁË £¨Ö±½ÓÒªÁ¬½Ó£©
sf ²»Áô ºÇºÇ



ÎÒÓÐ10.2µÄ°²×°³ÌÐò£¬ÒªµÄ»°¸øÄã·¢¹ýÈ¥

ÒýÓÃ
ÎÒÓÐ10.2µÄ°²×°³ÌÐò£¬ÒªµÄ»°¸øÄã·¢¹ýÈ¥

ºÜ´óµÄ°É

ÒýÓÃ
http://www.oracle.com/technology/global/cn/software/products/database/oracle10g/index.html

Õâ¸öÎÒÕÒµ½¹ý ËٶȺÃÏñºÜÂýŶ


ÒýÓÃ
oracle9iÎÒÓÐ,10gûÓÐ.

9i WIN7×°²»ÁË¡£¡£¡£´óÎÚ¹ê

ÒýÓÃ
ÒýÓà 4 Â¥ tianxiaocui2007 µÄ»Ø¸´:
ÎÒÓÐ10.2µÄ°²×°³ÌÐò£¬ÒªµÄ»°¸øÄã·¢¹ýÈ¥

ºÜ´óµÄ°É


1.11G£¬Ñ¹ËõǰµÄ

¹ÙÍøÏºÃÁË£¬ËÙ¶È»¹³É

ÒýÓÃ
ÒýÓà 5 Â¥ feixianxxx µÄ»Ø¸´:
ÒýÓà 4 Â¥ tianxiaocui2007 µÄ»Ø¸´:
ÎÒÓÐ10.2µÄ°²×°³ÌÐò£¬ÒªµÄ»°¸øÄã·¢¹ýÈ¥

ºÜ´óµÄ°É


1.11G£¬Ñ¹ËõǰµÄ

¡£¡£Ñ¹ËõºóÄØ¡£¡£¡£
ÄѵÀÓÃQ´«£¿

ÒýÓÃ
¹ÙÍøÏºÃÁË£¬ËÙ¶È»¹³É

ÎÒÔõôÊÇûËÙ¶È~

ѹËõºó1.04g

Âò¸öÅÌ×°°É
°²×°ÎļþÌ«´óÁË

ÎÒÓиö10gµÄ£¬Ñ¹Ëõºó620 MB

¶¥~~~~~~~ÎÒÓÐ10g

ÏÂÔØvista°æµÄ10.2g»òÕß11g

ÒýÓÃ


Ïà¹ØÎÊ´ð£º

Oracle 9i Ò»¶Ô¶àµÄ¹ØÏµ²éѯ

Ò»¶Ô¶à¹ØÏµ²éѯ

±í:
ea,eb,ga,gb
±í¹ØÏµÈçÏÂ
ea1=eb1
ga1=gb1
eb1=gb31 and eb3 = gb33


ÊÂÀýÊý¾Ý¼°¹ØÏµÈçÏÂ:
SQL code:

SELECT ea1, eb3, gb1, gb3, gb31, gb33
from (S ......

oracleʹÓÃutl_httpµÄÎÊÌâ

declare
  soap_request varchar2(30000);
  soap_respond varchar2(30000);
  http_req utl_http.req;
  http_resp utl_http.resp;

BEGIN
  soap_request:= ' ......

oracleÀïд¸ö´æ´¢¹ý³ÌÑ­»·²åÈë10ÍòÌõ¼Ç¼

¸ßÊÖ¸ø¸ö´æ´¢¹ý³Ì£¬ÄÜÑ­»·²åÈë10ÍòÌõ¼Ç¼£»ÔÚÏߵȡ£¡£¡£
Ñ­»·²åÈë10ÍòÌõ¼Ç¼£¿ÄܾßÌåµãÂð
ûÃ÷°×

SQL code:

--Á½±íÈç¹ûÒ»ÖÂʱ£º
insert into tableA as select * from tableB;

ÕâÎÊÌâÎʵÄ

ÎÞÃûÀÏ× ......

oracleµÄ·ÑÓÃÎÊÌâ

Ê×ÏÈ˵˵±¾ÈËÏë·¨
±¾ÈËÏëÒÔһֱѧϰoracleÊý¾Ý¿â²¢ÇÒÂýÂýµÄÉîÈëÏÂÈ¥,ËùÒÔ¾ÍÉæ¼°µ½Ê¹ÓõÄÎÊÌâµÄ,ÒòΪʹÓõĻú»áÔ½¶àËùÒÔѧÆðÀ´Ó¦¸ÃÔ½¿ì.
ËùÒÔÎÒÏëÒÔºóÔÚÏîÄ¿Öж¼Ê¹ÓÃ,ÄÇô¾Í»áÉæ¼°µ½ÊÕ·ÑÎÊÌâ,
±ÈÈç˵ÎÒÃǹ«Ë ......

oracleÖÐÓɳöÉúÄêÔ»ñµÃÄêÁä

select sname,(2009-10-05)-birth
from student;

birth×Ö¶ÎÖдæµÄÊdzöÉúÄêÔ£¬Ïë²éѯ³öÀ´µÄ½á¹ûÊÇÄêÁ䣬¸ÃÈçºÎ²éѯ£¿
¼ÓÉÏdatediffº¯ÊýÊÔÊÔ

select sname, to_char(sysdate,'YYYY')- to_char( ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ