Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 10g webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ