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

C#µ÷ÓÃoracle´æ´¢¹ý³Ì

oracleÖж¨ÒåÒ»¸öpackage£¬°üÖж¨ÒåÁËÒ»¸öÊý¾ÝÀàÐÍ
type userRow is record(
id t_user.id%type,
name t_user.name%type
);
TYPE emp_type_array IS TABLE OF userRow INDEX BY BINARY_INTEGER;

¶¨ÒåÁËÒ»¸ö´æ´¢¹ý³Ì£º
create or replace procedure aaa£¨aa in °ü.emp_type_array£© as  .......

ÎÒµÄÄ¿µÄÊÇ´«µÝ¸øOracleÒ»¸öÊý×飬Ȼºó´æ´¢¹ý³ÌÖÐÅúÁ¿²åÈëÊý¾Ý¿âµÄ±íÖÐ
ÎÊÌâÊÇ£¬C#ÈçºÎµ÷ÓÃÕâ¸ö´æ´¢¹ý³Ì£¿²ÎÊýµÄÊý¾ÝÀàÐͶ¨Òå³Éʲô£¿¿àÄÕÖУ¬¶¼ÊÔ¹ýÁË£¬¶¼²»ºÏÊÊ£¡
ÄÇλ´óÏÀ½â¾ö¹ý£¿°ïæ½â´ðһϹþ£¡

Èç¹ûÎÒÉÏÃæµÄ˼·´íÁ˵ϰ£¬ÈçºÎʵÏÖÅúÁ¿Ìá½»¸øoracleÊý¾Ý£¬È»ºóÅúÁ¿²åÈëÊý¾Ý¿â£¿
²»¶®

ʹÓà oracleÊý¾Ý¿â²Ù×÷À࣬¿É¿´¿´petshop
²Î¿¼

ûÓдóÏÀÅöµ½¹ýÂ𣿻òÕß˵һÏÂÈçºÎÅúÁ¿Ìá½»¸øoracleÊý¾Ý£¬È»ºó²åÈëÊý¾Ý¿â£¬ÓÐʲô·½°¸Âð£¿



ÎÒ×Ô¼ºµÄ½â¾ö°ì·¨£º
½«ÉÏÃæµÄRecordÀàÐͲð·Ö³É¶à¸öÒ»ÁÐtable£¬È»ºóÓÃÊý×é´«µÝ½øÈ¥µÄ
TYPE emp_userid_array IS TABLE OF t_user.id%type INDEX BY BINARY_INTEGER;

TYPE emp_username_array IS TABLE OF t_user.name%type INDEX BY BINARY_INTEGER;

È»ºóÓÃÁ½¸öÊý×é·Ö±ð´«µÝ¸ø´æ´¢¹ý³Ì£¬¿ÉÒÔʵÏÖ£¡
²»¹ý¸Ðл´ó¼ÒµÄ»Ø¸´£¬Ð»Ð»£¡




Ïà¹ØÎÊ´ð£º

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

´ÓORACLEµ½DB2µÄSQLÓï¾äÎÊÌâ

ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A  
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ 
DB2ÖÐÈçºÎʹÓÃÐ ......

oracleµ¼Èë»Ø¹ö - Oracle / ¿ª·¢

abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
  
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y

Äã² ......

Ë­ÄÜÍÆ¼ö¼¸±¾oracleµÄÊé»òÊÓÆµ - Oracle / ·Ç¼¼ÊõÇø

лл
ÎÒÒ²ÊÇÏëÖªµÀ

me too

ÎÒ Ò² Ïë Öª µÀ Æä Ëû µÄ£¬ÎÒ ÏÖ ÔÚ ¾Í ÔÚ Ñ§ orcale Êý ¾Ý ¿â£¬ÎÒ 
Óà µÄ ÊÇ ÕÔ Ôª ½Ü ±à µÄ.......

¸öÈ˾õµÃÔ­ÀíÐԵĶ«Î÷¿´Ò»Ð©¹Ù·½Îĵµ¿ÉÄÜ»áºÃһЩ Èç¹ûûÓÐÀÏʦ½Ì ......

oracleÊý¾Ý¿âµÄÃû×ÖÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É 

SQL> select name from v$database;
NAME
---------
ORCL ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ