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

oracleÖÐÁ¬½ÓÓë»á»°

oracleÖÐÁ¬½ÓÓë»á»°²»ÊÇÒ»¸ö¸ÅÄî!!!
ÔÚOracleÖУ¬Á¬½ÓÖ»ÊÇ¿Í»§½ø³ÌºÍÊý¾Ý¿âʵÀýÖ®¼äµÄÒ»ÌõÌØÊâÏß·£¬×î³£¼ûµÄ¾ÍÊÇÍøÂçÁ¬½Ó¡£ÕâÌõÁ¬½Ó¿ÉÄÜÁ¬½Óµ½Ò»¸öרÓ÷þÎñÆ÷½ø³Ì£¬Ò²¿ÉÄÜÁ¬½Óµ½µ÷¶ÈÆ÷¡£ÈçÇ°ËùÊö£¬Á¬½ÓÉÏ¿ÉÒÔÓÐ0¸ö»ò¶à¸ö»á»°£¬Õâ˵Ã÷¿ÉÒÔÓÐÁ¬½Ó¶øÎÞÏàÓ¦µÄ»á»°¡£ÁíÍ⣬һ¸ö»á»°¿ÉÒÔÓÐÁ¬½ÓÒ²¿ÉÒÔûÓÐÁ¬½Ó¡£Ê¹Óø߼¶Oracle NetÌØÐÔ£¨ÈçÁ¬½Ó³Ø£©Ê±£¬¿Í»§¿ÉÒÔɾ³ýÒ»ÌõÎïÀíÁ¬½Ó£¬¶ø»á»°ÒÀÈ»±£Áô£¨µ«ÊǻỰ»á¿ÕÏУ©¡£¿Í»§ÔÚÕâ¸ö»á»°ÉÏÖ´ÐÐij¸ö²Ù×÷ʱ£¬Ëü»áÖØн¨Á¢ÎïÀíÁ¬½Ó¡£
ÏÂÃæÊÂÀýÏÔʾһ¸öÁ¬½ÓÓÐÁ½¸ö»á»°µÄÇé¿ö...
1.²éѯv$sessionÒÔÏÔʾ»á»°ÐÅÏ¢
sys@OCP10G> select saddr,sid,serial#,paddr,user#,username,process,server,status from v$session where username=USER;
SADDR           SID    SERIAL# PADDR         USER# USERNAME                       PROCESS      SERVER    STATUS
-------- ---------- ---------- -------- ---------- ------------------------------ ------------ --------- --------
6EDBCCEC        144         33 6ECF1864          0 SYS                            2752:1860    DEDICATED ACTIVE
2.°ÑautotraceÉèÖÃΪon,Ôٴβéѯv$session
sys@OCP10G> set autotrace on
sys@OCP10G> select saddr,sid,serial#,paddr,user#,username,process,server,status from v$session where username=USER;
SADDR           SID    SERIAL# PADDR         USER# USERNAME                       PROCESS 


Ïà¹ØÎĵµ£º

ʹÓÃOracle·¢ËÍÓʼþ

CREATE OR REPLACE PROCEDURE sendemailtest
(mailmsg IN Varchar2)
IS    
   --using mail server to send email.
   mailconn         UTL_SMTP.connection;
   mailhost       & ......

¹ØÓÚORACLE ORA

 ÓÉÓÚϵͳÒÆÖ²£¬Ô­À´µÄÊý¾Ý¿â±àÂëºÍʱÇø¶¼»»ÁË£¬Ô­À´µÄһЩSQLÎÄÒ²³ö´íÁË¡£¡£
¾­³£±À³ö"ORA-01846: not a valid day of the week
"´íÎó¡£
¾­²âÊÔ£¬ÒÔÏÂÕâ¸ö¼òµ¥Óï¾äÒ²»á´í£¡£¡
SQL> select next_day(sysdate,'FRIDAY') from DUAL;
 select next_day(sysdate,'FRIDAY') from DUAL
 ORA-01 ......

¡¾ÊÕ²ØÕûÀí¡¿OracleÊý¾Ý¿âÌåϵ¼Ü¹¹

 Ô­Îļûhttp://blog.csdn.net/kele1121/archive/2009/10/30/4742051.aspxÓëhttp://www.itpub.net/thread-1105403-1-1.html
 Ëùν
Oracle
µÄÌåϵ¼Ü¹¹£¬ÊÇÖ¸
Oracle
Êý¾Ý¿â¹ÜÀíϵͳµÄµÄ×é³É²¿·ÖºÍÕâЩ×é³É²¿·ÖÖ®¼äµÄÏ໥¹Øϵ£¬°üÀ¨
ÄÚ´æ½á¹¹¡¢ºǫ́½ø³Ì¡¢ÎïÀíÓëÂß¼­½á¹¹µÈ¡£
Oracle
Êý¾Ý¿âµÄÌåϵºÜ¸´ÔÓ£¬¸´Ô ......

Oracle INSERT ALLºÍINSERT FIRST

½ñÌìµÚÒ»´ÎÖªµÀORACLEÔ­À´»¹¿ÉÒÔÕâÑùINSERTµÄ……³¤¼ûʶÁË
Ò»¡¢ÎÞÌõ¼þ INSERT ALL
¶þ¡¢Ìõ¼þ INSERT ALL
Èý¡¢Ìõ¼þ INSERT FIRST
Insert…Select
ʹÓÃInsert SelectʵÏÖͬʱÏò¶à¸ö±í²åÈë¼Ç¼
Ò»¡¢ÎÞÌõ¼þ INSERT ALL
----------------------------------------------------------------------- ......

ORACLE Top/Bottom N¡¢First/Last¡¢NTile

Ŀ¼
==================================================================
1.´ø¿ÕÖµµÄÅÅÁÐ
2.Top/Bottom N²éѯ
3.First/LastÅÅÃû²éѯ
4.°´²ã´Î²éѯ
Ò»¡¢´ø¿ÕÖµµÄÅÅÁУº
¼ÙÈç±»ÅÅÁеÄÊý¾ÝÖк¬ÓпÕÖµÄØ£¿
SQL> select region_id, customer_id,
   2         ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ