Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 9i/10g°²×°°üºÍPATCHÏÂÔØµØÖ·»ã×Ü

oracle 9i/10g°²×°°üºÍPATCHÏÂÔØµØÖ·»ã×Ü
°ÑÏÂÃæµÄµØÖ·¸´ÖƵ½Ñ¶À×Àï¾Í¿ÉÒÔÏÂÔØ.
---------------------------------------------------------------------------------------------------
ORACLE 9i
Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP
http://download.oracle ......

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


»¹ÊǽèÖúoracle sql developerÀ´²Ù×÷oracle£¬sql plus»¹ÊÇÂé·³Ò»µã¡£
¼òµ¥¿´ÁËһϣ¬Óï¾ä»ù±¾É϶¼ºÍÆäËûÊý¾Ý¿âµÄsql²î²»¶à£¬¼Ç¼һϲ»Í¬µÄµØ·½¡£
ÈÕÆÚÀàÐͱ༭
update student set stu_birthday = to_date('2010-03-06 13:14:20','yyyy-MM-dd HH24:mi:ss');
ÐèҪʹÓÃto_date()º¯Êý£¬SQLÖв»Çø·Ö´óСд£¬MMºÍmm± ......

SQLServerºÍOracle³£Óú¯Êý¶Ô±È

SQLServerºÍOracleÊÇ´ó¼Ò¾­³£Óõ½µÄÊý¾Ý¿â£¬ÔÚ´Ë×ܽá³öÕâЩ³£Óú¯ÊýÒÔ¹©
´ó¼Ò²Î¿¼¡£
Êýѧº¯Êý
¡¡¡¡1.¾ø¶ÔÖµ
¡¡¡¡S:select abs(-1) value
¡¡¡¡O:select abs(-1) value from dual
¡¡¡¡2.È¡Õû(´ó)
¡¡¡¡S:select ceiling(-1.001) value
¡¡¡¡O:select ceil(-1.001) value from dual
¡¡¡¡3.È¡Õû£¨Ð¡£©
¡¡¡¡S:s ......

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

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

oracleͬÒå´Ê

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