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×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃ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 ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......