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;
Ïà¹ØÎĵµ£º
oracleËøµÄÅŶӻúÖÆ£º
ÇëÇóËø¶¨ÐèÒªÅŶӡ£Èç¹ûij¸ö»á»°ÇëÇóÒ»¸öËø¶¨£¬µ«ÊÇÓÉÓÚÆäËû»á»°ÒÑ¾Ëø¶¨ÁËÖ¸¶¨¼Ç¼»ò¶ÔÏó¶øÎÞ·¨»ñµÃËùÐèµÄËø¶¨£¬ÄÇôÕâ¸ö»á»°½«»áµÈ´ý¡£´Ëʱ£¬¿ÉÄܶà¸ö»á»°¶¼Ôڵȴý·ÃÎÊÏàͬ¼Ç¼»ò¶ÔÏó£¬ÔÚÕâÖÖÇé¿öÏ£¬ORACLE»á¸ú×ÙÕâЩ»á»°ÇëÇóËø¶¨µÄ˳Ðò¡£
Èç¹û ......
²é¿´µ±Ç°Êý¾Ý¿â¹éµµÈÕÖ¾²Ù×÷ģʽ:
select name,log_mode from v$database;
²é¿´¹éµµÈÕ־λÖÃ:
show parameter log_archive_dest; µÚÒ»¸ö¹éµµÎ»ÖÃ
show parameter log_archive_duplex_dest; µÚ¶þ¸ö¹éµµÎ»ÖÃ
ÏȹرÕÊý¾Ý¿â,È»ºó×°ÔØÊý¾Ý¿â:
shutdown immediate;
startup mount;
Ð޸Ĺ鵵ÈÕÖ¾²Ù×÷ģʽ,È»ºó´ò¿ªÊý¾Ý¿â ......
ÿ´Îͨ¹ýÐÞ¸Ätnsnames.oraÅäÖñ¾µØNET·þÎñÃû¶¼³öÏÖ´íÎó“ORA-12154:TNS£¬ÎÞ·¨´¦Àí·þÎñÃû”£¬×ܵÃÓôÃÆ°ëÌì~
Õâ¸ö´íÎó£¬Í¨³£ÊÇÒòΪoracle±¾µØNET·þÎñÃûÅäÖÃtnsnames.oraÎļþÓÐÑϸñµÄ¸ñʽҪÇó¡£
ÀýÈ磺
mstrdw =
(DESCRIPTION =
(ADDRESS_LIST =
......
·ÖÒ³²éѯ¸ñʽ£º
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¿ØÖÆ·ÖÒ³²éѯµÄÿҳµÄ·¶Î§¡£
ÉÏÃæ¸ø³öµÄÕâ¸ö·ÖÒ³²éѯÓï¾ä£¬ÔÚ´ó¶à ......
JobµÄ²ÎÊý£º
Ò»£ºÊ±¼ä¼ä¸ôÖ´ÐУ¨Ã¿·ÖÖÓ£¬Ã¿Ì죬ÿÖÜ£¬:ÿÔ£¬Ã¿¼¾¶È£¬Ã¿°ëÄ꣬ÿÄ꣩
intervalÊÇÖ¸ÉÏÒ»´ÎÖ´ÐнáÊøµ½ÏÂÒ»´Î¿ªÊ¼Ö´ÐеÄʱ¼ä¼ ......