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

OracleµÄ¼¸¸öÊÔÌâ °ï°ïæ

1£®ÅжÏÕâPL/SQL´úÂë¿é(Ñ¡ÔñÒ»Ïî)
Begin
For i in 1..6  loop
If i==2 or i==3 then
Null;
Else
Insert  into example(one) values(i);
End if;
Rollback;
End loop;
Commit;
End;
ÓжàÉÙÐб»²åÈëµ½±íExampleÖÐ
A  0  B  1  C  2  D  3
2.ÒÔÏÂÊý¾Ý¿âÊÇOracleÓï·¨µÄÊÇ£º£¨£©
A.select sysdate into v_time from dual;
B.select v_time = sysdate;
C.set v_time:=sysdate;(v_timeΪÒѶ¨ÒåµÄʱ¼äÀàÐͱäÁ¿)
D. v_time=sysdate
3£®ÓαêµÄÄĸöÊôÐÔָʾfetchÓï¾äÊÇ·ñ´Ó»î¶¯¼¯Öзµ»ØÐÐ,ÈçδÄÜ·µ»ØÐÐ,Ôò´ËÊôÐÔµÄֵΪfalse?(Ñ¡ÔñÒ»Ïî)
A %FOUND  B %NOTFOUNT  C %ROWCOUNT  D %ISOPEN
4£®ÄÄÒ»¸öÊÇSQL*PLUS ÃüÁî?(Ñ¡ÔñÒ»Ïî)
A UPDATE B PROMPT C SELECT D ALTER TABLE
5£®ÔÚoracleÖÐ,( )º¯Êý½«char»òvarcharÊý¾ÝÀàÐÍת»»ÎªdateÊý¾ÝÀàÐÍ. (Ñ¡ÔñÒ»Ïî)
a) date
b) to_date
c) todate
d) ctodate

6£® ÔÚoracleÖÐ,¹ØÓÚHAVING×Ó¾ä,ÒÔÏÂ˵·¨ÕýÈ·µÄÊÇ( ). (Ñ¡ÔñÒ»Ïî)
a) HAVING×Ó¾äºÍWHERE×Ó¾äÏàͬ
b) HAVING×Ó¾äÓÃÓÚµ¥ÐеÄÌõ¼þ²éѯ
c) HAVING×Ó¾äÓÃÓÚÒÑ·Ö×éµÄÌõ¼þ²éѯ
d) HAVING×Ӿ䱨Ðë½ô¸úÔÚWHERE×Ó¾äºóÃæÊ¹ÓÃ
{{--


Ïà¹ØÎÊ´ð£º

oracleÊý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£

²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿

ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ

ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ