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

±±´óÇàÄñoracleѧϰ±Ê¼Ç12


¹ØϵÐÍÊý¾Ý¿âÀíÂÛÖÐ×Ö¶ÎÖµ±ØÐëÊǵ¥Öµ£¬¶øoracleÖÐÔÊÐíÔÚÒ»¸ö×Ö¶ÎÖд洢һ¸ö±íµÄÄÚÈÝ¡£
È磺Ա¹¤±íÖеÄÍâ¼ü ²¿ÃűàºÅ£¬oracleÖÐÕâ¸ö×ֶοÉÒÔ´æ·Å²¿ÃŵļǼ¶ø²¢²»ÊÇÒ»¸öÍâ¼ü£¬ÕâÑù²éѯʱºòµÄЧÂÊ»áÌá¸ß¡£
¿É±äÊý×飺
´´½¨´øÓпɱäÊý×éµÄ±í
´´½¨¿É±äÊý×é»ùÀàÐÍ
create or replace type »ùÀàÐÍÃû as object(×Ö¶ÎÇåµ¥);
´´½¨¿É±äÊý×éÀàÐÍ
create or replace ¿É±äÊý×éÀàÐÍÃû as varray(×î´óÐÐÊý) of ¿É±äÊý×éµÄ»ùÀàÐÍ;
ʵÀý£º
create or replace type mingxitype as object
(
goodsid varchar(15),
incount int,
providerid varchar(10)
);
create or replace type arrmingxitype as varray(100) of mingxitype;
´´½¨Ò»¸öÖ÷±í
create table instock
(
orderid int primary key,
indate date,
mingxi arrmingxitype
);
ÀûÓù¹Ô캯Êý²åÈëÊý¾Ý
insert into instock values(
'200208070001',
to_date('2002-08-07','yyyy-mm-dd'),
arrmingxitype(
mingxitype('101',10,'S01'),
mingxitype('102',20,'S02')
)
);
²éѯ
select * from instock;ÔòÏÔʾ¶ÔÏó¶ø²¢²»ÊÇÏñ¹ØϵÊý¾Ý¿âÄÇÑùµÄ±íµ¥
select * from table(
select s.mingxi from instock s where orderid = 1001
);
´ËʱÏÔʾµÄÊǿɱäÊý×éÖеÄÐÅÏ¢¶øûÓÐÖ÷±íÖеÄÐÅÏ¢¡£
tableº¯ÊýÒªÇóÄÚ²¿×Ó²éѯ±ØÐëÃ÷È·È·¶¨Ò»Ìõ¼Ç¼£¡
Ð޸ĿɱäÊý×é±È½ÏÂé·³£¬±ØÐëÐÞ¸ÄÕû¸öÊý×éµÄ¼Ç¼¡£ËùÒԿɱäÊý×鳣ʹÓÃÔÚ»ù±¾²»ÐèÒªÐ޸ĵļǼ£¨ÈçÀúÊ·¼Ç¼µÈ£©
update instock set mingxi = arrmingxitype(
mingxitype('101',20,'S01'),
mingxitype('102',30,'S02')
)where orderid = '200208070001';
ɾ³ý¼Ç¼²Ù×÷Óë¹ØϵÐÍÊý¾Ý¿âÒ»Ö£¬É¾³ýÕûÌõÖ÷¼Ç¼¡£
delete from instock where orderid = '1001';


Ïà¹ØÎĵµ£º

oracleÖ´Ðмƻ®

±¾ÎĽéÉÜÁËORACLEÖ´Ðмƻ®µÄһЩ»ù±¾¸ÅÄ¹©Ñ§Ï°Ó¦Óá£
Ò»£®Ïà¹ØµÄ¸ÅÄî
RowidµÄ¸ÅÄrowidÊÇÒ»¸öαÁУ¬¼ÈÈ»ÊÇαÁУ¬ÄÇôÕâ¸öÁоͲ»ÊÇÓû§¶¨Ò壬¶øÊÇϵͳ×Ô¼º¸ø¼ÓÉϵġ£¶Ôÿ¸ö±í¶¼ÓÐÒ»¸örowidµÄαÁУ¬µ«ÊDZíÖв¢²»ÎïÀí´æ´¢ROWIDÁеÄÖµ¡£²»¹ýÄã¿ÉÒÔÏñʹÓÃÆäËüÁÐÄÇÑùʹÓÃËü£¬µ«ÊDz»ÄÜɾ³ý¸ÄÁУ¬Ò²²»ÄܶԸÃÁеÄÖµ½øÐÐÐ޸ġ ......

±±´óÇàÄñoracleѧϰ±Ê¼Ç6

Ëø
²éѯÆäËûÓû§µÄ±í <Óû§Ãû.±íÃû>
Ëø¶¨Ä£Ê½£º
Ðм¶Ëø
Ðб»ÅÅËûÐÔËø¶¨
ÔÚijÐеÄËø±»ÊÍ·Å֮ǰ£¬ÆäËûÓû§²»ÄÜÐ޸ĴËÐÐ
ʹÓÃcommit rollbackÃüÁîÊÍ·ÅËø
»ñÈ¡Ðм¶Ëø
ʹÓÃinsert¡¢updateÓï¾ä£¬×Ô¶¯ÉÏÐм¶Ëø
ʹÓÃselect...for update [of ÁÐÃû] Óï¾ä×Ô¶¯»ñÈ¡Ðм¶Ëø
ÔÚ±íµÄÒ»Ðлò¶àÐзÅÖÃÅÅËûËø£¬ÓÃÓÚ·ÀÖÎÆäË ......

Oracle 11g R1 for Linux(RHEL5)°²×°

1 ¡¢°²×°Ç°µÄ×¼±¸
1.1 ¼ì²éÓ²¼þ
ÎïÀíÄڴ棺 # grep MemTotal /proc/meminfo
½»»»¿Õ¼ä£º # grep SwapTotal /proc/meminfo
½»»»¿Õ¼äµÄ´óСÊǸù¾ÝÎïÀíÄÚ´æµÄ´óСÀ´ÉèÖõģ¬ÎïÀíÄÚ´æÉÙÓÚ 2G µÄÔò½»»»¿Õ¼äÉèΪÎïÀíÄÚ´æµÄÁ½±¶£¬ÎïÀíÄÚ´æ´óÓÚ 2G µÄÔò½»»»¿Õ¼äºÍÎïÀíÄÚ´æ´óСһÑù¡£Èç¹û²»·ûºÏÉÏÊö¹æ¶¨£¬ÄÇô¾ÍÐèÒªÖØÐÂÉèÖý ......

½ñÌìoracle DBA½ç´óʦ¼¶ÈËÎï¸Ç¹úÇ¿ÏÈÉúÀ´ÎÒÃǹ«Ë¾

      2010Äê3ÔÂ5ÈÕ£¬ËäÈ»º®·ç´Ì¹Ç£¬µ«ÒÀÈ»µ²²»×¡¹«Ë¾Í¬ÊºÍÎÒ¹¤×÷µÄÈÈÇé.µÎ´ð¡¢µÎ´ð,ͬÊÂÊÖ»úÏìÁË£¬ÀÏ×ܸøËû´òµç»°£¬Ëµ¹ã¶«ÁªÍ¨ÍøÓÅƽ̨Êý¾Ý¿â³öÏÖÎÊÌ⣬ÓÉÓÚÊý¾ÝÁ¿È·Êµ¹ý´ó£¬Í¬ÊÂÒÔÇ°Ò²´¦Àí¹ýÄDZߵÄÎÊÌ⣬Ö÷ÒªÊÇËùÓÐÊý¾ÝÁ¿´óµÄ±íÿ¸ôÒ»Ì콨Á¢Ò»¸öË÷Òý£¬ÕâÑù²éѯÊý¾ÝËٶȱȽϿ졣µ«ÊǽøÐÐÊý¾Ý»ã× ......

oracleͬÒå´Ê

----------------------------------------------------------------------------
Ïà¹Ø֪ʶ£ºOracle SYNONYM£¨Í¬Òå´Ê£©
----------------------------------------------------------------------------
ÊÇÒ»ÖÖÓ³Éä¹Øϵ£¬¿ÉÒÔÀí½âΪ±íµÄÒ»Ö̶ֹ¨±ðÃû
ͬÒå´ÊµÄºÃ´¦£º½¨Á¢Ò»¸öͬÒå´Ê¿ÉÒÔÅųýÒ»¸ö¶ÔÏóÃû×ÖµÄÏÞÖÆ
Èç¹ûÄãµÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ