OracleÓëDB2ÖÐÐòÁд¦Àí
1¡¢ÐòÁж¨Òå
ORACLE:
CREATE SEQUENCE <sequence_name>
INCREMENT BY <integer>
START WITH <integer>
MAXVALUE <integer> / NOMAXVALUE
MINVALUE <integer> / NOMINVALUE
CYCLE / NOCYCLE
CACHE <#> / NOCACHE
ORDER / NOORDER;
DB2:
CREATE SEQUENCE <sequence-name>
AS data-type ĬÈÏ As Integer
START WITH <numeric-constant>
INCREMENT BY <numeric-constant> ĬÈÏ INCREMENT BY 1
MINVALUE <numeric-constant> | NO MINVALUE ĬÈÏ NO MINVALUE
MAXVALUE <numeric-constant> | NO MAXVALUE ĬÈÏ NO MAXVALUE
Ïà¹ØÎĵµ£º
1£® ½âÊÍFUNCTION£¬PROCEDUREºÍPACKAGEÇø±ð
´ð£ºfunction ºÍprocedureÊÇPL/SQL´úÂëµÄ¼¯ºÏ£¬Í¨³£ÎªÁËÍê³ÉÒ»¸öÈÎÎñ¡£procedure ²»ÐèÒª·µ»ØÈκÎÖµ¶øfunction½«·µ»ØÒ»¸öÖµÔÚÁíÒ»·½Ã棬PackageÊÇΪÁËÍê³ÉÒ»¸öÉÌÒµ¹¦ÄܵÄÒ»×éfunctionºÍprocedureµÄ¼¯ºÏ¡£
2£® ȡij¸öÐòÁеĵ±Ç°ÖµµÄPL/SQLÓï ......
À´Ô´£º²»Ïê ×÷ÕߣºØýÃû ʱ¼ä£º2009-9-6 17:14:04 Tags£º Orac ʹÓ÷½·¨
ÐèÇó£ºÒµÎñÂß¼ÔÚ´¦ÀíÊý¾Ýʱ£¬ÐèÒª·µ»ØMessage²¢×èÖ¹³ÌÐòµÄ¼ÌÐøÔËÐС£µ«ÊÇ£¬ÔÚ´æ´¢¹ý³ÌʹÓÃOracleÊý¾Ý¿âµÄRaise¸ù±¾ÎÞ·¨Âú×ãÏÖÔÚµÄÒªÇó¡£
½â¾ö·½·¨£º
ʹÓÃRAISE_APPLICATION_ERROR
RAISE_APPLICATION_ERROR ( erro ......
Ò»£ºsql loader µÄÌØµã
oracle×Ô¼º´øÁ˺ܶàµÄ¹¤¾ß¿ÉÒÔÓÃÀ´½øÐÐÊý¾ÝµÄÇ¨ÒÆ¡¢±¸·ÝºÍ»Ö¸´µÈ¹¤×÷¡£µ«ÊÇÿ¸ö¹¤¾ß¶¼ÓÐ×Ô¼ºµÄÌØµã¡£
±ÈÈç˵expºÍimp¿ÉÒÔ¶ÔÊý¾Ý¿âÖеÄÊý¾Ý½øÐе¼³öºÍµ¼³öµÄ¹¤×÷£¬ÊÇÒ»ÖֺܺõÄÊý¾Ý¿â±¸·ÝºÍ»Ö¸´µÄ¹¤¾ß£¬Òò´ËÖ÷ÒªÓÃÔÚÊý¾Ý¿âµÄÈȱ¸·ÝºÍ»Ö¸´·½Ãæ¡£ÓÐ×ÅËٶȿ죬ʹÓüòµ¥£¬¿ì½ÝµÄÓŵ㣻ͬʱҲÓÐһР......
´ó¼ÒºÃ£¬ÎÒÔÚhttp://download.csdn.net/source/836323ÉÏ·¢µÄÌû×Ó£¬È·ÊµÖ»ÊǸödemo£¬ÆäÌâ¿âÄÚÈݼûÏÂÎÄ£¬´ËΪ×îÐÂÌâ¿âµÄÒ»²¿·Ö£¬Õýʽ°æÌâ¿âÊÇ175Ìâ¡£ÐèÒªÕýʽ°æ±¾µÄÅóÓÑ£¬¿ÉÒÔÖ±½ÓÁªÏµÎÒ»òÕßµ½www.certinside.cn/1z0-051 ÉÏÃæ¿´¿´£¬ÎÒÃǺÍtestinsideÊÇÒ»¼ÒµÄ£¬ÐèÒªµÄ»°ÎÒ¿ÉÒÔ¸øÄã´ò¸öÕÛ£¬¼Û¸ñÔÙÒé¡£ÎÒµÄQQ£º390970748¡¡ ......
ÔÌû: http://blog.chinaunix.net/u2/66903/showart_2082884.html
OracleʹÓôóÁ¿²»Í¬µÄÉ󼯷½·¨À´¼à¿ØÊ¹ÓúÎÖÖȨÏÞ£¬ÒÔ¼°·ÃÎÊÄÄЩ¶ÔÏó¡£É󼯲»»á·ÀֹʹÓÃÕâЩȨÏÞ£¬µ«¿ÉÒÔÌṩÓÐÓõÄÐÅÏ¢£¬ÓÃÓÚ½ÒʾȨÏÞµÄÀÄÓúÍÎóÓá£
ϱíÖÐ×ܽáÁËOracleÊý¾Ý¿âÖв»Í¬ÀàÐ͵ÄÉ󼯡£
Éó ¼Æ Àà ÐÍ
˵ Ã÷
Óï¾äÉó¼Æ ......