±±´óÇàÄñ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¼¼ÊõÈËÔ±ÇóÖ°ÃæÊÔÌ⼯½õ£¬´ð°¸½ö¹©²Î¿¼……
¡¡¡¡1. ½âÊÍÀ䱸·ÝºÍÈȱ¸·ÝµÄ²»Í¬µãÒÔ¼°¸÷×ÔµÄÓŵã
¡¡¡¡½â´ð£ºÈȱ¸·ÝÕë¶Ô¹éµµÄ£Ê½µÄÊý¾Ý¿â£¬ÔÚÊý¾Ý¿âÈԾɴ¦ÓÚ¹¤×÷״̬ʱ½øÐб¸·Ý¡£¶øÀ䱸·ÝÖ¸ÔÚÊý¾Ý¿â¹Ø±Õºó£¬½øÐб¸·Ý£¬ÊÊÓÃÓÚËùÓÐģʽµÄÊý¾Ý¿â¡£Èȱ¸·ÝµÄÓŵãÔÚÓÚµ±±¸·Ýʱ£¬Êý¾Ý¿âÈԾɿÉÒÔ±»Ê¹Óò¢ÇÒ¿ ......
ÎÒÊǸöÐÂÊÖ,ËùÒÔÓÐЩ˵µÄ¿ÉÄܻ᲻ºÃ,Ï£ÍûÔĶÁÕâÎÄÕµÄÈ˼ûÁ°¡.
Ò»°ã¹ØÓÚID×ÔÔöµÄÍøÉ϶¼ÓÐÁ˺ܶàÁË,ºÇºÇ^ÄÇÎҾͼòµ¥µÄ˵һÏÂ: ÏÈ´´½¨±í£¬ÔÙ´´½¨ÐòÁÐ:
create sequence ÐòÁÐÃû
&nb ......
ÒòÎªÇ¿ÖÆ¹Ø»ú£¬¿ª»úµÄʱºò½øÈëÊý¾Ý¿â±¨´í£º
ora_01034:oracle not available
ora_27101:shared memory realm does not exit
½â¾ö·½·¨£º
1.´ò¿ªCMD
2.ÊäÈë sqlplus "/as sysdba"
3.»Ø³µ
4.ÊäÈë startup
5.½áÊø ......