Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ¿Í»§¶ËÈí¼þ 8.1.7 »ò¸ü¸ß°æ±¾"½â¾ö°ì·¨

1.Ñ¡ÔñÄúËù°²×°OrcaleµÄĿ¼£¬ÀýÈ磺C:\Oracle
2.ÓÒ¼üµã»÷£¬µ¯³ö“ÊôÐÔ”¶Ô»°¿ò£¬Ñ¡Ôñ“°²È«”Ñ¡Ï
3.Ìí¼Ó“IUser_»ú×ÓÃû³Æ”Óû§µÄȨÏÞ£¬²ÉÓÃÍêÈ«¿ØÖƵķ½Ê½
4.È·¶¨Ó¦Óúó£¬ÔÚÑ¡Ôñ“°²È«”Ñ¡ÏÖÐÑ¡Ôñ“IUser_»ú×ÓÃû³Æ”Óû§£¬µã»÷¸ß¼¶
5.Ñ¡ÔñÑ¡Ôñ¿ò“ÓÃÔÚ ......

oracleµ÷ÓÃjavaÀà±éÀú´ÅÅÌÎļþ

ÀûÓÃoracle×Ô´øµÄutl_file°ü¿ÉÒÔ·ÃÎÊ´ÅÅÌÎļþ£¬µ«ÓиöÏÞÖÆ--ÎÞ·¨·ÃÎÊÎļþ¼Ð£¿Ê²Ã´Òâ˼ÄØ£¿¾ÍÊÇ˵oracleÖ»ÄÜ·ÃÎÊÖ¸¶¨µÄÎļþ£¬¶ø²»ÄÜ·ÃÎÊÎļþ¼ÐϵÄδ֪Îļþ¡£ËùÒÔ£¬Èç¹ûҪͨ¹ýoracleÈ¥±éÀúijָ¶¨Â·¾¶ÏµÄËùÓÐÎļþ£¬sorry, impossible! µ«ÊÇ£¬ÓÐÒ»ÖÖÌæ´ú·½°¸¿ÉÒÔÖúÄãÒ»±ÛÖ®Á¦£¡
ÖÚËùÖÜÖªjavaÖ®FileÀàÖ¸ÏòµÄ¿ÉÒÔÊÇĿ¼Ҳ¿ÉÒÔÊ ......

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

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

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ÖÐto_char()²ÎÊýÏê½â

 1 -  /  ,  . ; :
"text" ʱ¼ä·Ö¸ô·ûºÅ£¬³ýÁ˱ê×¼µÄ¼¸¸ö£¬»¹ÔÊÐíÓÃÎÄ×Ö×÷Ϊ·Ö¸î·ûºÅ¡£
ÀýÈç to_char(sysdate,'YYYY"Äê"mm"ÔÂ"dd"ÈÕ"')=2008Äê04ÔÂ24ÈÕ
 2 AD
A.D.  ¼´À­¶¡ÎÄAnno DominiµÄ¼òд£¬±íʾ¹«Ôª.»á¸ù¾ÝnlsµÄ²»Í¬×ª»»Îª¹«Ôª»òÕßadµÈ
ÎÞÌØÊâ×¢ÒâÊÂÏî
 3 AM
A.M.  ÉÏ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ