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

¹ØÓÚoracleµÄ×Ô¶¨ÒåtypeµÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ʹÓÃÁË×Ô¶¨Òåtype
ÈçÏÂ
create or replace type customtype as object(
ele1 char(7),
ele2 char(3)
);

Ö®ºóÔÚpackageÀïÃæÏëʹÓÃ
ÓÚÊÇд
l_ele1_c customtype.ele1%type;

µ«ÊDz»ÐУ¬pls00206µÄ´íÎó
ÆäʵÎÒ¾ÍÊÇÏëÔÚ×Ô¶¨ÒåtypeÄDZ߶¨ÒåºÃÁË£¬packageÄDZßÒÔºó¾Í²»»á±äÁË£¬Ö»ÒªÊ¹ÓÃcustomtype.ele1µÄtype¾ÍºÃÁË

ÇëÎÊÓÐûʲô½â¾ö·½°¸£¿

ʵÔÚ²»ÐУ¬¾ÍÖ»Äܶ¨Òål_ele1_c char(7);ÁË¡­¡­
TYPE Table_ele1 IS TABLE OF customtype.ele1%TYPE;
TABele1 Table_ele1;

ÓÃTABele1¾Í¿ÉÒÔÁË(Ãû×ÖËæ±ã)

Â¥É쵀 ËûÃ²ËÆ ÏëÒýÓõÄÊÇ TYPE ÀïÃæµÄÕâ¸ö 

ÄÇÄãΪʲô²»Ö±½Ó¶¨ÒåÊÇ ¾Í  
create or replace type customtype as object(
ele1 char(7)
);
TABele1 Table_ele1;


лл¥ÉÏÁ½Î»£¬Æäʵ¾ÍÊǿͻ§¸øÁ˸ötype¶¨Ò壬˵һ¶¨ÒªÓã¬È»ºóÒªÎÒÀ´Ð´Ò»¸öpackage£¬ÓÖ˵±ØÐëÒªÓÃ%typeµÄÐÎʽ¡£ÎҾ;À½áÁË¡­¡­

Ô­À´¿ÉÒÔÏÈÓñäÁ¿Ê¹ÓÃÕâ¸öÀàÐÍ
È»ºóʹÓñäÁ¿µÄtypeÀ´¶¨Òå¡­¡­

Àý£º
l_type customtype;
l_ele1_c l_type.ele1%type;



Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

[Ô­´´] 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¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......

¸ß·ÖÇó½âOracleÊý¾Ý¿âµÄÁéÒìʼþ - Oracle / ¿ª·¢

½ñÌìÓöµ½Ò»¸öºÜ¹îÒìµÄÎÊÌâ¡£ÎÒÔÚÒ»ÕűíÖÐÐÂÔöÁËÒ»¸ö×ֶΡ£È»ºóÓÃÈçϽű¾¸üÐÂÕâ¸ö×ֶεÄÖµ£º
SQL code:

update ibp_fund_information_tab set yield = 7.4520 where fund_code = '040003' and info_date = ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ