±¾ÈËϵͳWIN7
Ìý˵ ¿ÉÒÔ×°Oracle10.2.1 ºÍ11
²»ÄÜ×°Oracle9i
Çó¸öÏÂÔØËÙ¶È¿ìµãµÄOracle10.2.1ºÍ11 µÄÁ´½Ó
ллÁË £¨Ö±½ÓÒªÁ¬½Ó£©
sf ²»Áô ºÇºÇ
ÎÒÓÐ10.2µÄ°²×°³ÌÐò£¬ÒªµÄ»°¸øÄã·¢¹ýÈ¥
ºÜ´óµÄ°É
Õâ¸öÎÒÕÒµ½¹ý ËٶȺÃÏñºÜÂýŶ
9i WIN7×°²»ÁË¡£¡£¡£´óÎÚ¹ê
1.11G£¬Ñ¹ËõǰµÄ
¹ÙÍøÏºÃÁË£¬ËÙ¶È»¹³É
¡£¡£Ñ¹ËõºóÄØ¡£¡£¡£
ÄѵÀÓÃQ´«£¿
ÎÒÔõôÊÇûËÙ¶È~
ѹËõºó1.04g
Âò¸öÅÌ×°°É
°²×°ÎļþÌ«´óÁË
ÎÒÓиö10gµÄ£¬Ñ¹Ëõºó620 MB
¶¥~~~~~~~ÎÒÓÐ10g
ÏÂÔØvista°æµÄ10.2g»òÕß11g
Ïà¹ØÎÊ´ð£º
Ò»¶Ô¶à¹ØÏµ²éѯ
±í:
ea,eb,ga,gb
±í¹ØÏµÈçÏÂ
ea1=eb1
ga1=gb1
eb1=gb31 and eb3 = gb33
ÊÂÀýÊý¾Ý¼°¹ØÏµÈçÏÂ:
SQL code:
SELECT ea1, eb3, gb1, gb3, gb31, gb33
from (S ......
declare
soap_request varchar2(30000);
soap_respond varchar2(30000);
http_req utl_http.req;
http_resp utl_http.resp;
BEGIN
soap_request:= ' ......
¸ßÊÖ¸ø¸ö´æ´¢¹ý³Ì£¬ÄÜÑ»·²åÈë10ÍòÌõ¼Ç¼£»ÔÚÏߵȡ£¡£¡£
Ñ»·²åÈë10ÍòÌõ¼Ç¼£¿ÄܾßÌåµãÂð
ûÃ÷°×
SQL code:
--Á½±íÈç¹ûÒ»ÖÂʱ£º
insert into tableA as select * from tableB;
ÕâÎÊÌâÎʵÄ
ÎÞÃûÀÏ× ......
Ê×ÏÈ˵˵±¾ÈËÏë·¨
±¾ÈËÏëÒÔһֱѧϰoracleÊý¾Ý¿â²¢ÇÒÂýÂýµÄÉîÈëÏÂÈ¥,ËùÒÔ¾ÍÉæ¼°µ½Ê¹ÓõÄÎÊÌâµÄ,ÒòΪʹÓõĻú»áÔ½¶àËùÒÔѧÆðÀ´Ó¦¸ÃÔ½¿ì.
ËùÒÔÎÒÏëÒÔºóÔÚÏîÄ¿Öж¼Ê¹ÓÃ,ÄÇô¾Í»áÉæ¼°µ½ÊÕ·ÑÎÊÌâ,
±ÈÈç˵ÎÒÃǹ«Ë ......
select sname,(2009-10-05)-birth
from student;
birth×Ö¶ÎÖдæµÄÊdzöÉúÄêÔ£¬Ïë²éѯ³öÀ´µÄ½á¹ûÊÇÄêÁ䣬¸ÃÈçºÎ²éѯ£¿
¼ÓÉÏdatediffº¯ÊýÊÔÊÔ
select sname, to_char(sysdate,'YYYY')- to_char( ......