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

oracleʵÀýÃû¡¢Êý¾Ý¿âÃûÓë·þÎñÃûµÄÀí½â

ʵÀýÃû£¨instance_name£©£¬Ò»¸öÓÃÓÚÊý¾Ý¿âºÍ²Ù×÷ϵͳ֮¼äͨÐŵıêÖ¾£¬Êý¾Ý¿âºÍ²Ù×÷ϵͳ֮¼äÒª½øÐн»»¥ÓõľÍÊÇʵÀýÃû£¬ÊµÀýÃû¿ÉÒÔºÍÊý¾Ý¿âÃûÏàͬ£¬Ò»»áÔÙ˵Êý¾Ý¿âÃû£¬Ò»°ãÒ»¸öÊý¾Ý¿âÃû¶ÔÓ¦Ò»¸öʵÀýÃû£¬Ò»¶ÔÒ»¹ØÏµ£¬µ«ÔÚoracleµÄ¼¯ÈºÓ¦ÓÃÖУ¬Êý¾Ý¿âÃûºÍʵÀýÃû¾ÍÊÇÒ»¶Ô¶àµÄ¹ØÏµÁË¡£
¡¡¡¡²é¿´ÊµÀýÃû£ºselect instance_name from v$instance;
¡¡¡¡oracle_sidÓëinstance_nameµÄ¹ØÏµ£ºÍ¬Ñù¶¼ÊÇʵÀýÃû£¬instance_nameÊÇoracleÊý¾Ý¿â²ÎÊý£¬¶øoracle_sidÊDzÙ×÷ϵͳ»·¾³±äÁ¿£¬²Ù×÷ϵͳËù·ÃÎʵÄʵÀýÃû£¬±ØÐëÊÇoracle_sid£¬oracle_sid±ØÐëÓëinstance_nameÒ»Ö¡£
¡¡¡¡Êý¾Ý¿â£¨db_name£©Ãû¾ÍÊÇÊý¾Ý¿âµÄΨһ±êʶ£¬Ï൱ÓÚÈ˵ÄÉí·ÝÖ¤Ò»Ñù£¬Êý¾Ý¿âÃûÔÚ´´½¨Ê±Ó¦¸Ã¾ÍÒª¿¼ÂǺ㬺óÃæ¾¡Á¿²»ÒªÐ޸ģ¬ÒòÉæ¼°Ð޸ĵĵط½±È½Ï¶à£¬ÈÝÒ׳ö´í£¬ÔÚ´´½¨Êý¾Ý¿âcreate databaseʱ£¬ÆäÖеIJÎÊý±ØÐëÊÇDB_name£¬·ñÔò»á³ö´í£¬ÐÞ¸ÄÊý¾Ý¿âʱͬÀí¡£×¢£¬Õâ±ßµÄ´´½¨Êý¾Ý¿âÆäʵÊÇ´´½¨Êý¾Ý¿âÎļþ£¬Ò²¾ÍÊÇË׳ƵÄÓû§¡£
¡¡¡¡²é¿´µ±Ç°Êý¾Ý¿âÃû£ºselect name from v$database;
¡¡¡¡·þÎñÃû£¨service_name£©£¬Ò»°ãÀ´½²£¬Êý¾Ý¿â·þÎñÃûÓëÊý¾Ý¿âÃûÏàͬ¡£
¡¡¡¡²é¿´·þÎñÃû£ºselect value from v$parameter where name = 'service_name';
ÉÏÊö¾ùΪ¸öÈ˹۵㣬ÈçÓв»¶ÔÇë¶à¶àÖ¸Õý£¬¹²Í¬½ø²½£¡


Ïà¹ØÎĵµ£º

[ת]Oracle Ëæ»ú»ñÈ¡NÌõÊý¾Ý


µ±ÎÒÃÇ»ñÈ¡Êý¾Ýʱ,¿ÉÄÜ»áÓÐÕâÑùµÄÐèÇó,¼´Ã¿´Î´Ó±íÖлñÈ¡Êý¾Ýʱ,ÊÇËæ»ú»ñȡһ¶¨µÄ¼Ç¼,¶ø²»ÊÇÿ´Î¶¼»ñȡһÑùµÄÊý¾Ý,ÕâʱÎÒÃÇ¿ÉÒÔ²ÉÈ¡OracleÄÚ²¿Ò»Ð©º¯Êý,À´´ïµ½ÕâÑùµÄÄ¿µÄ.   
  
   1) select * from (select * from tablename order  ......

Oracle Application Express µÄ°²×°

°²×°Ç°µÄ×¼±¸£º
      µÇ¼ϵͳ£ºsqlplus system/0621
1.   ´ÓÊý¾Ý×Öµäv$instanceÖлñÈ¡Êý¾Ý¿âµÄʵÀýÃûºÍ°æ±¾ºÅ£ºselect instance_name,version from v$instance;
2.   ´ÓÊý¾Ý×Öµäv$versionÖлñÈ¡°æ±¾µÄÏêϸÐÅÏ¢£ºselect * from v$version;
3.È·ÈÏoracleËùʹÓõIJÎÊýÎļþ ......

ORACLE to_charº¯ÊýÏê½â


The following are number examples for the to_char
function.
to_char
(1210.73,
'9999.9')
would return '1210.7'
to_char
(1210.73,
'9,999.99')
would return '1,210.73'
to_char
(1210.73,
'$9,999.00')
would return
'$1,210.73'
to_char
(21,
'000099')
would return '000021'
The foll ......

oracleÖеÄrownumαÁÐÉî²ã·ÖÎö

¶ÔÓÚ Oracle µÄ rownum ÎÊÌ⣬ºÜ¶à×ÊÁ϶¼Ëµ²»Ö§³Ö>,>=,=,between...and£¬Ö»ÄÜÓÃÒÔÉÏ·ûºÅ(<¡¢<=¡¢!=)£¬²¢·Ç˵ÓÃ>,>=,=,between..and ʱ»áÌáʾSQLÓï·¨´íÎ󣬶øÊǾ­³£ÊDz鲻³öÒ»Ìõ¼Ç¼À´£¬»¹»á³öÏÖËÆºõÊÇĪÃûÆäÃîµÄ½á¹ûÀ´£¬ÆäʵÄúÖ»ÒªÀí½âºÃÁËÕâ¸ö rownum αÁеÄÒâÒå¾Í²»Ó¦¸Ã¸Ðµ½¾ªÆæ£¬Í¬ÑùÊÇαÁУ¬rownum Ó ......

Oracle ²ÎÊý·ÖÀà ºÍ ²ÎÊýµÄ²é¿´·½·¨


OracleÊý¾Ý¿âϵͳ¸ù¾Ý³õʼ»¯²ÎÊýÎļþinit.oraÖÐÉèÖõIJÎÊýÀ´ÅäÖÃ×ÔÉíµÄÆô¶¯£¬Ã¿¸öʵÀýÔÚÆô¶¯Ö®Ç°£¬Ê×ÏȶÁÈ¡ÕâЩ²ÎÊýÎļþÖÐÉèÖõIJ»Í¬²ÎÊý¡£
OracleϵͳÖеIJÎÊý£¬¸ù¾ÝϵͳʹÓÃÇé¿ö¿ÉÒÔ¼òµ¥·ÖΪÁ½´óÀࣺ
ÆÕͨ²ÎÊý£ºÒ²¾ÍÊÇOracleϵͳÕý³£Ê¹ÓõÄһЩ²ÎÊý£¬
·Ç·²²ÎÊý£º°üÀ¨ÈýÖÖ£¬¹ýʱ²ÎÊý¡¢Ç¿µ÷²ÎÊýºÍÒþ²Ø²ÎÊý¡£
Ëæ×ÅOrac ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ