Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Êý¾Ý¿âÖÐË÷ÒýµÄά»¤

×÷Õߣº  ÈÕÆÚ£º2005-12-8 1:43:32  À´Ô´£ºInternet      µã»÷£º´Î  ÆÀÂÛ
¡¡¡¡±¾ÎÄÖ»ÌÖÂÛOracleÖÐ×î³£¼ûµÄË÷Òý£¬¼´ÊÇB-treeË÷Òý¡£±¾ÎÄÖÐÉæ¼°µÄÊý¾Ý¿â°æ±¾ÊÇOracle8i¡£
¡¡¡¡Ò». ²é¿´ÏµÍ³±íÖеÄÓû§Ë÷Òý
¡¡¡¡ÔÚOracleÖУ¬SYSTEM±íÊÇ°²×°Êý¾Ý¿âʱ×Ô¶¯½¨Á¢µÄ£¬Ëü°üº¬Êý¾Ý¿âµÄÈ«²¿Êý¾ ......

ORACLE¸ÅÒªÎļþ

¼ÇµÃÒÔÇ°ÉÏOCP¿Î³ÌµÄʱºòÄǸöÀÏʦ½ÌÎÒÃÇʹÓÃPROFILEÀ´ÏÞÖÆÓû§µÄһЩ²Ù×÷£¬ÄǸöʱºò¹À¼ÆÊÇÀÏʦ͵ÀÁ°É£¬ËùÓÐʵÑ鶼ÊÇͨ¹ýOEMµÄÐÎʽÀ´²Ù×÷£¬¸ù±¾²»»áÉæ¼°µ½ÃüÁîÐС£
ƽʱÔÚѧϰORACLEµÄ¹ý³ÌÖкÃÏñÒ²ºÜÉÙÅöµ½¹ØÓÚPROFILEµÄÎÊÌ⣬½ñÌì¹äÒ»¸öÅóÓѵÄBLOGµÄʱºò·¢ÏÖÕâƪÎÄÕ£¬¾õµÃͦºÃµÄ£¬ÄÚÈݲ»¶à£¬¼ò½àÃ÷ÁË£¬ºÃ´õÒ²ËãÊǸöÃüÁîÐÐ ......

ORACLE ÓαêºÍÓαê±äÁ¿µÄÇø±ð

ÈçºÎ¶¨ÒåÓαêÀàÐÍ
TYPE ref_type_name IS REF CURSOR [RETURN return_type];
ÉùÃ÷Óαê±äÁ¿
cursor_name ref_type_name;
´Ó¼¼Êõµ×²ã¿´£¬Á½ÕßÊÇÏàͬµÄ¡£ÆÕͨplsql cursorÔÚ¶¨ÒåʱÊÇ“¾²Ì¬”µÄ¡£¶øRef cursors¿ÉÒÔ¶¯Ì¬´ò¿ª¡£
ÀýÈçÏÂÃæÀý×Ó£º
Declare
type rc is ref cursor;
cursor c is select * from dual ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ