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;
È»ºóÓÃÁ½¸öÊý×é·Ö±ð´«µÝ¸ø´æ´¢¹ý³Ì£¬¿ÉÒÔʵÏÖ£¡
²»¹ý¸Ðл´ó¼ÒµÄ»Ø¸´£¬Ð»Ð»£¡
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ
DB2ÖÐÈçºÎʹÓÃÐ ......
abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y
Äã² ......
лл
ÎÒÒ²ÊÇÏëÖªµÀ
me too
ÎÒ Ò² Ïë Öª µÀ Æä Ëû µÄ£¬ÎÒ ÏÖ ÔÚ ¾Í ÔÚ Ñ§ orcale Êý ¾Ý ¿â£¬ÎÒ
Óà µÄ ÊÇ ÕÔ Ôª ½Ü ±à µÄ.......
¸öÈ˾õµÃÔÀíÐԵĶ«Î÷¿´Ò»Ð©¹Ù·½Îĵµ¿ÉÄÜ»áºÃһЩ Èç¹ûûÓÐÀÏʦ½Ì ......
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
......