ÈÝÒ׺öÊÓµÄoracleº¯ÊýÎÊÌâ Êý¾ÝÀàÐÍ
×î½üʼÖÕ±»Êý¾Ý¿âÎÊÌâÀ§ÈÅ£¬³öÓÚÏîÄ¿Ó¦ÓÃÔÒò£¬¶¨ÒåÁËһЩoracle×Ô¶¨Ò庯Êý(User Defined function),ÓÃÓÚÔÚʵ¼Ê²éѯSQLÓï¾äÖе÷Óã¬Ä¿µÄÊÇΪÁ˼ò»¯SQLÓï¾äµÄ¸´ÔӶȡ£Êµ¼ÊʹÓÃÖз¢ÏÖ£¬ÕâЩº¯Êý»á³öÏÖÒ»¸öĪÃûÆæÃîµÄÎÊÌ⣬ÏÈÉÏʵÀý:
CREATE OR REPLACE FUNCTION "GETSINGLEUSER" --·µ»ØµÚÒ»¸ö×Ö·û´®
(sStr in nvarchar2)
return nvarchar2
as
sReturn nvarchar2(50);
begin
if instr(sStr,',') > 0 then
sReturn := SUBSTR(sStr,1,instr(sStr,',') - 1);
else
sReturn := sStr;
end if;
return sReturn;
exception
when others then
return 'error';
end;
ÕâÊÇÆäÖÐÒ»¸öº¯Êý£¬¹¦Äܼܺòµ¥¾ÍÊÇÈ¡,·Ö¸ôµÄ¶à¸ö´®¼¯ÖеĵÚÒ»¸öÔªËØ·µ»Ø£¬µ«ÊÇÔÚʵ¼ÊSQLÓï¾äÖÐʹÓÃÖз¢ÏÖ£¬Èç¹û²éѯ·µ»ØÐÐÊý³¬¹ý100ÐУ¬100ÐкóµÄ¼Ç¼Öк¯ÊýûÓÐÖ´Ðнá¹û£¨¿ÉÅųý´«Èë²ÎÊýÎÊÌ⣩¡£¼ûͼ
Ó¦Óú¯ÊýGETSINGLEUSER ½øÐвéѯij±íijÁÐÊý¾Ýʱ£¬100ÐкóµÄ¼Ç¼Ã÷Ã÷ÊÇÓÐÖµµÄ£¬¶øÇÒÔÚº¯ÊýÌåÖÐÈç¹û³öÏÖÒì³£Ò²»áÓзµ»ØÖµerror,µ«ÊÇʵ¼ÊЧ¹û¾ÍÏñ100ÐеļǼûÓÐÖ´ÐйýÒ»Ñù¡£ÎªÊ²Ã´ÄØ£¿ÆäʵÕâ¸öÎÊÌâµ½ÏÖÔÚÎÒҲûÓÐÍêÈ«¸ãÃ÷°×¡£Ö»ÊÇ×Ô¼º·´¸´²âÊÔʵÑéºó£¬¸Ð¾õÓëÊý¾ÝÀàÐÍÓÐÒ»¶¨¹Øϵ£¬Îҵĺ¯ÊýÈë¿Ú²ÎÊýÉùÃ÷ÀàÐÍΪ:nvarchar2,¶øʵ¼Ê²éѯÖÐÒýÓÃÁеĶ¨ÒåÈçÏÂͼ£¬ÊÇcharÀàÐÍ£º
ËùÒÔÔÚº¯Êýµ÷Óô¦¾Í²ÉÈ¡Á˽«²ÎÊýÇ¿ÖÆת»»ÎªÈë¿ÚÀàÐÍ£º
½á¹ûÎÊÌâÏûʧ£¬±¾ÎÄÖ»ÄÜ˵Ã÷¸ÃÎÊÌâµÄ½â¾ö·½·¨£¬µ«È´²»ÄÜÍêȫ˵Ã÷³ÉÒò£¬ÒÔ¼°ÀàËÆΪʲôÊÇ100ÐÐÄصÈÎÊÌâ¡£
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
OracleµÄÎﻯÊÓͼÌṩÁËÇ¿´óµÄ¹¦ÄÜ£¬¿ÉÒÔÓÃÓÚÔ¤ÏȼÆËã²¢±£´æ±íÁ¬½Ó»ò¾Û¼¯µÈºÄʱ½Ï¶àµÄ²Ù×÷µÄ½á¹û£¬ÕâÑù£¬ÔÚÖ´Ðвéѯʱ£¬¾Í¿ÉÒÔ±ÜÃâ½øÐÐÕâЩºÄʱµÄ²Ù×÷£¬¶ø´Ó¿ìËٵĵõ½½á¹û¡£ÎﻯÊÓͼÓкܶ෽ÃæºÍË÷ÒýºÜÏàËÆ£ºÊ¹ÓÃÎﻯÊÓͼµÄÄ¿µÄÊÇΪÁËÌá¸ß²éѯÐÔÄÜ£»ÎﻯÊÓͼ¶ÔÓ¦ÓÃ͸Ã÷£¬Ôö¼ÓºÍɾ³ýÎﻯÊÓͼ²»»áÓ°ÏìÓ¦ÓóÌÐòÖÐSQLÓï¾äµÄÕýÈ ......
ÓÃoracleµÄжÔسÌÐò²¢²»ÄÜÍêȫжÔظɾ»¡£Èç֮ǰµÄÃüÃûµÄoracle sid ²»ÄÜÔÙʹÓ᣻áÌáʾsid´æÔÚ¡£ÏÂÃæÊÇÔÚwinxpÏÂÍêȫжÔØoracleµÄ·½·¨¡£
1¡¢¿ªÊ¼££¾ÉèÖ㣾¿ØÖÆÃæ°å££¾¹ÜÀí¹¤¾ß££¾·þÎñ
Í£Ö¹ËùÓÐOracle·þÎñ¡£
2¡¢¿ªÊ¼££¾³ÌÐò££¾Oracle - OraHome81££¾Oracle ......
SQLÊÇÓÃÓÚ·ÃÎÊORACLEÊý¾Ý¿âµÄÓïÑÔ£¬PL/SQLÀ©Õ¹ºÍ¼ÓÇ¿ÁËSQLµÄ¹¦ÄÜ£¬Ëü ͬʱÒýÈëÁ˸üÇ¿µÄ³ÌÐòÂß¼¡£ PL/SQLÖ§³ÖDMLÃüÁîºÍSQLµÄÊÂÎñ¿ØÖÆÓï¾ä¡£DDLÔÚPL/SQLÖв»±»Ö§³Ö£¬Õâ¾ÍÒâζ×÷ÔÚPL/SQL³ÌÐò¿éÖв»ÄÜ´´½¨±í»òÆäËûÈκζÔÏ󡣽Ϻà µÄPL/SQL³ÌÐòÉè¼ÆÊÇÔÚPL/SQL¿éÖÐʹÓÃÏóDBMS_SQLÕâÑùµÄÄÚ½¨°ü»òÖ´ÐÐEXECUTE IMMEDIATEÃüÁÁ¢¶¯Ì ......