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 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......