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

ÈÝÒ׺öÊÓµÄ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 ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

oracle exp/imp ×Ö·û¼¯

ʹÓÃultraedit32´ò¿ªµ¼³öµÄdmpÎļþ£¬ÎļþÄÚÈÝÒÔÊ®Áù½øÖÆÏÔʾÊý¾Ý£¬ÆäÖеڶþ¡¢Èý×Ö½ÚµÄÊý¾Ý¼Ç¼µÄÊÇ´ËÎļþµÄ×Ö·û¼¯¡£
ÀýÈ磺
03 54
½«Æäת»»Îª10½øÖÆ£¬ÖµÎª852£¬Ê¹ÓÃÃüÁî
select nls_charset_name(852) from dual
µÃµ½½á¹û
ZHS16GBK
µ±Ç°Ê¹ÓÃwinXP¼òÌåÖÐÎIJÙ×÷ϵͳ£¬Oracle¿Í»§¶ËĬÈÏ×Ö·û¼¯ÎªGBK¡£
´´½¨Êý¾Ý¿â£¬É趨 ......

³¹µ×жÔØORACLE(WINXP)

ÓÃoracleµÄжÔسÌÐò²¢²»ÄÜÍêȫжÔظɾ»¡£Èç֮ǰµÄÃüÃûµÄoracle sid ²»ÄÜÔÙʹÓ᣻áÌáʾsid´æÔÚ¡£ÏÂÃæÊÇÔÚwinxpÏÂÍêȫжÔØoracleµÄ·½·¨¡£
1¡¢¿ªÊ¼£­£¾ÉèÖã­£¾¿ØÖÆÃæ°å£­£¾¹ÜÀí¹¤¾ß£­£¾·þÎñ  
     Í£Ö¹ËùÓÐOracle·þÎñ¡£  
2¡¢¿ªÊ¼£­£¾³ÌÐò£­£¾Oracle  -  OraHome81£­£¾Oracle   ......

¼Ó¿ìOracleµÄ»Ø¹öËÙ¶È

ÎÊÌâÃèÊö
1¡¢Ó¦ÓÃÁ¬½ÓÊý¾ÝÒì³£»ºÂý£¬°üÀ¨¿Í»§¶ËʹÓÃplsqlÁ¬½Ó£»
2¡¢Êý¾Ý¿âÖ÷»úcpuÕ¼ÓÃÂʾӸ߲»Ï£¬IOдÈë¾Ó¸ß²»Ï¡£
3¡¢Ö÷»úÈÕ³£Î¬»¤²Ù×÷ÏìÓ¦Âý£¬Èçman»òw£»
·ÖÎöÎÊÌâ
Øϵͳ¼°oracleÓ¦ÓÃΪʲôÏìÓ¦Âý
1¡¢ÎªÊ²Ã´ÏµÍ³Á¬wÕâô¼òµ¥µÄ²Ù×÷¶¼»á¾õµÃ¿¨ÄØ£¿
2¡¢ÎªÊ²Ã´Ã»ÓÐÈκÎÓ¦ÓýÓÈëµÄÇé¿öÏ£¬Êý¾Ý¿â»áÓдóÁ¿µÄдÈë ......

OracleÊÕ¹ºSun£¬ÒâÔÚIBM£¬Ãëɱ΢Èí

¡¡¡¡Sun±¾À´¾ÍºÜÀ÷º¦£¬Î޷ǽüÄêÀ´Ó¯ÀûÄÜÁ¦ÓÐËùϽµ£¬Oracle¿¿Êý¾Ý¿â׬ÁË´ó°Ñ³®Æ±¡£Á½¼ÒÁªºÏÒÔºóÐγɓCPU-¸ß¶ËÖ÷»ú-²Ù×÷ϵͳ-¿ª·¢»·¾³-Êý¾Ý¿â-ÓïÑÔ-Ó¦ÓÃÈí¼þ”Ò»ÌõÁú²úÆ·Ïߣ¬´ËÇ°ÓдËÄÜÁ¦µÄÖ»ÓÐIBM¡£
¡¡¡¡Á½¼Ò½ñºóµÄÕÐÅƲúÆ·¶Ô±ÈÈçÏ£º
SUN&Oracle IBM
CPU Ultra Power
Ö÷»ú UltraϵÁÐ RS,ASµÈPowerϵÁ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ