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

oracle¼òµ¥¶ÔÏóÀàÐÍ

ÔÚplsqlÖУ¬ÃæÏò¶ÔÏóµÄ³ÌÐòÉè¼ÆÊÇ»ùÓÚ¶ÔÏóÀàÐÍÀ´Íê³ÉµÄ¡£¶ÔÏóÀàÐÍÊÇÓû§×Ô¶¨ÒåµÄÒ»ÖÖ¸´ºÏÊý¾ÝÀàÐÍ£¬Ëü·â×°ÁËÊý¾Ý½á¹¹ºÍÓÃÓÚ²Ù×ÝÕâЩÊý¾Ý½á¹¹µÄ¹ý³ÌºÍº¯Êý£¬ÔÚ½¨Á¢¸´ÔÓÓ¦ÓóÌÐòʱ£¬Í¨¹ýʹÓöÔÏóÀàÐÍ¿ÉÒÔ½µµÍÓ¦Óÿª·¢ÄѶȣ¬½ø¶øÌá¸ßÓ¦Óÿª·¢µÄЧÂʺÍËÙ¶È¡£
¶ÔÏóÀàÐͰüÀ¨¶ÔÏóÀàÐ͹淶£¨object type specification£©ºÍ¶ÔÏóÀàÐÍÌ壨object type body£©Á½¸ö²¿·Ö¡£ÆäÖжÔÏóÀàÐ͹淶ÊǶÔÏóÓëÓ¦ÓõĽӿڣ¬ËüÓÃÓÚ¶¨Òå¶ÔÏóµÄ¹«ÓÃÊôÐԺͷ½·¨£»¶ø¶ÔÏóÀàÐÍÌåÔòÓÃÓÚʵÏÖ¶ÔÏóÀàÐ͹淶Ëù¶¨ÒåµÄ¹«Ó÷½·¨£¬Èç¹û¶ÔÏóÀàÐ͹淶ÖÐûÓж¨Òå·½·¨£¬Ôò¿ÉÒÔ²»¶¨Òå¶ÔÏóÀàÐÍÌå¡£
¶ÔÏóÀàÐÍÊôÐÔÓÃÓÚÃèÊö¶ÔÏóËù¾ßÓеÄÌØÕ÷£¬Ã¿¸ö¶ÔÏóÀàÐÍÖÁÉÙ°üº¬Ò»¸öÊôÐÔ£¬ÖÁ¶à¿ÉÒÔ°üº¬1000¸öÊôÐÔ¡£¶ÔÏóÀàÐ͵ÄÊôÐÔ²»ÄÜʹÓÃlong¡¢long raw¡¢rowid¡¢urowid¡¢plsqlµÄÌØÓÐÀàÐÍ£¨binary_integer,Boolean,%type,%rowtype,ref cursor,record,pls_integer£©µÈ¡£²¢ÇÒÔÚ¶¨Òå¶ÔÏóÀàÐÍÊôÐÔʱ£¬¼È²»ÄÜÖ¸¶¨¶ÔÏóÊôÐÔµÄĬÈÏÖµ£¬Ò²²»ÄÜÖ¸¶¨notnullÑ¡Ïî¡£
ÐжÔÏóÊÇÖ¸Ö±½Ó»ùÓÚ¶ÔÏóÀàÐÍËù½¨Á¢µÄ±í£¬ÁжÔÏóÊÇÖ¸ÔÚ½¨±íʱָ¶¨Á˶ÔÏóÀàÐÍÁеĶÔÏó±í¡£ÏÂÃæ¸ø³öÁ˲Ù×÷ÐжÔÏóµÄ´úÂ룬ÁжÔÏó²Ù×÷·½Ê½ÀàËÆ¡£
ʾÀý1£ºÐжÔÏóÊý¾Ý²Ù×÷£¨°üº¬ÁжÔÏóÊý¾ÝµÄ²Ù×÷ÀàËÆ£©
--½¨Á¢¶ÔÏóÀàÐÍ
create  or  replace   type person_obj as   object(
name   varchar2(10),
gender  number(1),
birthday  date);
--½¨Á¢ÐжÔÏ󣨻ùÓÚperson_obj£©
create  table person_table of  person_obj;
--ΪÐжÔÏó²åÈëÊý¾Ý
insert  into person_table values(person_obj('jax01',1,sysdate)); --¹¹Ôì·½·¨
insert  into person_table values('jax02',1,sysdate); --ÆÕͨ·½·¨
--¼ìË÷ÐжÔÏóÊý¾Ý
select * from person_table where  name = 'jax01';
--¸üÐÂÐжÔÏóÊý¾Ý
update person_table set birthday =  to_date('2004-05-12','YYYY-MM-DD')
where gender = 0;
 


Ïà¹ØÎĵµ£º

SELECT ... FOR UPDATE£¨WAIT/NOWAIT£©ÃüÁîÓëORACLEËø

oracleËøµÄÅŶӻúÖÆ£º
 
 
 
ÇëÇóËø¶¨ÐèÒªÅŶӡ£Èç¹ûij¸ö»á»°ÇëÇóÒ»¸öËø¶¨£¬µ«ÊÇÓÉÓÚÆäËû»á»°ÒѾ­Ëø¶¨ÁËÖ¸¶¨¼Ç¼»ò¶ÔÏó¶øÎÞ·¨»ñµÃËùÐèµÄËø¶¨£¬ÄÇôÕâ¸ö»á»°½«»áµÈ´ý¡£´Ëʱ£¬¿ÉÄܶà¸ö»á»°¶¼Ôڵȴý·ÃÎÊÏàͬ¼Ç¼»ò¶ÔÏó£¬ÔÚÕâÖÖÇé¿öÏ£¬ORACLE»á¸ú×ÙÕâЩ»á»°ÇëÇóËø¶¨µÄ˳Ðò¡£
 
 
 
Èç¹û ......

Oracle¹éµµÈÕÖ¾¹ÜÀí


²é¿´µ±Ç°Êý¾Ý¿â¹éµµÈÕÖ¾²Ù×÷ģʽ:
select name,log_mode from v$database;
²é¿´¹éµµÈÕ־λÖÃ:
show parameter log_archive_dest; µÚÒ»¸ö¹éµµÎ»ÖÃ
show parameter log_archive_duplex_dest; µÚ¶þ¸ö¹éµµÎ»ÖÃ
ÏȹرÕÊý¾Ý¿â,È»ºó×°ÔØÊý¾Ý¿â:
shutdown immediate;
startup mount;
Ð޸Ĺ鵵ÈÕÖ¾²Ù×÷ģʽ,È»ºó´ò¿ªÊý¾Ý¿â ......

¹ØÓÚOracleÖÐtnsnames.oraµÄÅäÖÃ


ÿ´Îͨ¹ýÐÞ¸Ätnsnames.oraÅäÖñ¾µØNET·þÎñÃû¶¼³öÏÖ´íÎó“ORA-12154:TNS£¬ÎÞ·¨´¦Àí·þÎñÃû”£¬×ܵÃÓôÃÆ°ëÌì~
Õâ¸ö´íÎó£¬Í¨³£ÊÇÒòΪoracle±¾µØNET·þÎñÃûÅäÖÃtnsnames.oraÎļþÓÐÑϸñµÄ¸ñʽҪÇó¡£
ÀýÈ磺
mstrdw =
  (DESCRIPTION =
    (ADDRESS_LIST =
      ......

[轉]oracle ·Ö頁

·ÖÒ³²éѯ¸ñʽ£º
SELECT * from
(
SELECT A.*, ROWNUM RN
from (SELECT * from TABLE_NAME) A
WHERE ROWNUM <= 40
)
WHERE RN >= 21
ÆäÖÐ×îÄÚ²ãµÄ²éѯSELECT * from TABLE_NAME±íʾ²»½øÐз­Ò³µÄԭʼ²éѯÓï¾ä¡£ROWNUM <= 40ºÍRN >= 21¿ØÖÆ·ÖÒ³²éѯµÄÿҳµÄ·¶Î§¡£
ÉÏÃæ¸ø³öµÄÕâ¸ö·ÖÒ³²éѯÓï¾ä£¬ÔÚ´ó¶à ......

ORACLE JOB ÉèÖÃ

                   
    JobµÄ²ÎÊý£º
    Ò»£ºÊ±¼ä¼ä¸ôÖ´ÐУ¨Ã¿·ÖÖÓ£¬Ã¿Ì죬ÿÖÜ£¬:ÿÔ£¬Ã¿¼¾¶È£¬Ã¿°ëÄ꣬ÿÄ꣩
   intervalÊÇÖ¸ÉÏÒ»´ÎÖ´ÐнáÊøµ½ÏÂÒ»´Î¿ªÊ¼Ö´ÐеÄʱ¼ä¼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ