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

Ò»¸ö¼òµ¥µÄsqlÓï¾ä - Oracle / ¿ª·¢

create table user_b.abcd
( a number constraint abc_pk primary key 
using index
(create index abc_index on user_b.abcd(a) tablespace users),
b number
);

------------------
SQL> @h:\code\6.sql
(create index abc_index on user_b.abcd(a) tablespace users),
  *
µÚ 4 ÐгöÏÖ´íÎó:
ORA-00903: ±íÃûÎÞЧ

Óï¾äÓÐʲôÎÊÌ⣿£¿£¿£¿£¿£¿
±í»¹Ã»Óд´½¨³É¹¦¡£Äã¿ÉÒÔÏȽ¨±í£¬ÔÙ½¨Ë÷Òý
create table user_b.abcd
( a number );
alter table TGL_user_b.abcd
add 
constraint abc_pk primary key (a) tablespace users);

ÒýÓÃ
create table user_b.abcd
( a number constraint abc_pk primary key
using index
(create index abc_index on user_b.abcd(a) tablespace users),
b number
);

------------------
SQL> @h:\code\6.s¡­¡­

°Ñuser_b.È«²¿È¥µô

ÒýÓÃ

ÒýÓÃÂ¥Ö÷ liukai_happy µÄ»Ø¸´:
create table user_b.abcd
( a number constraint abc_pk primary key
using index
(create index abc_index on user_b.abcd(a) tablespace users),
b number
);

-------------¡­¡­

ÕâÑù¿ÉÒÔÁ˰ɣ¿
˳±ã˵Ï Ö÷¼üĬÈϾÍÓÐindexµÄ û±ØÒªÐ½¨indexµÄ

ÒýÓÃ
create table user_b.abcd
( a number constraint abc_pk primary key
using index<


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

OracleÈÏÖ¤ - Oracle / ÈÏÖ¤Ó뿼ÊÔ

ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ 
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ