ÏÖÔڵıí½á¹¹Ê½ÕâÑùµÄ
id name superid level
37353 ǧÑôÏØ 1 1
38044 37353 2
39302 ÄÏÕ¯Õò 38044 3
43009 ãÆ¼Ò´å 39302 4
46447 6×é 43009 5
µØÖ·ÊÇ´æ´¢ÔÚÊ÷Ðνṹ±íÖÐ
µØÖ·× ......
create or replace package DB_Oper is
type ref_DataSet IS REF CURSOR;
end DB_Oper;
ÎÒÔÚtoadÖÐÖ´ÐÐÕâ¸ö±¨´í˵ÊÇ ²»ÊÇÓÐЧµÄsqlʲôµÄ.×ÜÖ®¾ÍÊDz»ÄÜÖ´ÐÐÁË.
ÇëÎÊΪʲô,Ôõô½â¾ö?
лл
create or replace package DB_Oper is
type ref_DataSet IS REF CURSOR;
......
×î½üÐèÒªÓÃjavaÉú³ÉcrlÁбí
Ò»°ãµÄjdkÖÐûÓÐÌṩÕâ¸ö·½·¨£¬ÎÒÔÚoracleµÄ½éÉÜÖп´µ½ oracle µÄ crypto package ÌṩÉú³ÉcrlµÄ·½·¨
µ«²»ÖªµÀÕâЩ°üÔÚÄÄÀÔÚoracleÍøÕ¾ÉÏÕÒÁ˰ëÌ죬ֻÊÇ¿´µ½Îĵµ£¬Ã»¿´µ½ÏÂÔØµÄµØ·½£¬ÄÄλǰ±²ÓùýÇë¸æËßÒ»ÏÂ
°ï¶¥ÏÂ
Â¥Ö÷½â¾öºó£¬Ò²ÔÚÌù×Ó˵˵Ôõô½â¾öÕâÎÊÌâ
ÎÒÒ²Óöµ½ÀàËÆ ÎÊÌâ
......
ºÜ¾ÃÒÔǰ²»Ôõô¶®Êý¾Ý¿âʱ£¬²»Ð¡ÐİÑoracleÊý¾Ý¿â°´×°ÔÚÁËCÅÌ£¬ÏÖÔÚCÅÌÒѾ¿ìÂúÁË¡£
ÓôÃÆÖÐÏë°ÑÊý¾Ý¿âÇ¨ÒÆµ½DÅÌÈ¥£¬²»ÖªµÀ¸Ã×öʲô£¬Ôõô×ö£¬Çë½Ì¸÷λ´óϺ£¡Ð»Ð»~
ÔΣ¬Ì«×ż±ÏëÖªµÀ½â¾ö·½°¸£¬·¢¿ìÁË£¬Íü¼Ç¸ø·ÖÁË£¬²»ºÃÒâ˼°¡£¬¸÷λ¡£Ï´ÎÒ»¶¨²¹ÉÏ£¡
......
ÎÒÏÖÔÚÓõÄÊÇSQL ServerÊý¾Ý¿â£¬Ã»ÓÐoracleÊý¾Ý¿â»ù´¡£¬´ó¼Ò¸øÎÒÍÆ¼öÒ»¸öoracleÊý¾Ý¿âÊÓÆµ½Ì³Ì£¬ºÃµÄÊé±¾½Ì²ÄÒ²ÍÆ¼öÒ»ÏÂ
ÈëÃŵÄÖ¸ÄÏÎÒÖ»¿´¹ýÒ»±¾
¾õµÃͦºÃ
oracle database 11g sql¿ª·¢Ö¸ÄÏ jason priceÖø
ʵ¼ùÊÇ×îºÃµÄÀÏʦ
ÓÐÒ»±¾¹È³¤Óµġ¶ORACLE 11gȨÍþÖ¸ÄÏ¡·¿ÉÒÔ¿´¿´£¬µ«ÊÇÀïÃæ»¹ÊÇÓÐЩÎÊÌ⣬
h ......
×î½üϵͳ¸î½Ó..
ÐèÒª½«ÀÏϵͳµÄÊý¾Ýµ¼Èëµ½Öмä±íÀïÈ¥..
»ù±¾Óï¾äΪ..
insert into Öмä±í(×Ö¶Î1,×Ö¶Î2,×Ö¶Î3,×Ö¶Î4)
select /*+parallel (t, 6)+*/ ×Ö¶Î1,×Ö¶Î2,×Ö¶Î3,×Ö¶Î4 from ÀÏϵͳ±í t;
ÔÚÕâÀïÎÒ·¢ÏÖµ¼ÈëµÄËٶȱȽϵÄÂý.
ÎÒ¶ÔÕâ¸ö /*+parallel (t, 6)+*/ Ò²²»ÊǺÜÁ˽â
²é¹ý×ÊÁϺóÒÀÏ¡Ã÷° ......