OracleжÔظɾ»·½·¨
OracleжÔØж²»¸É¾»£¬Oracle³¹µ×ɾ³ýµÄ°ì·¨(winxp)
OracleжÔØж²»¸É¾»£¬Oracle³¹µ×ɾ³ýµÄ°ì·¨(winxp)
ÓÃoracleµÄжÔسÌÐò²¢²»ÄÜÍêȫжÔظɾ»¡£Èç֮ǰµÄÃüÃûµÄoracle sid ²»ÄÜÔÙʹÓ᣻áÌáʾsid´æÔÚ¡£ÏÂÃæÊÇÔÚwinxpÏÂÍêȫжÔØoracleµÄ·½·¨¡£
1¡¢¿ªÊ¼££¾ÉèÖ㣾¿ØÖÆÃæ°å££¾¹ÜÀí¹¤¾ß££¾·þÎñ
Í£Ö¹ËùÓÐOracle·þÎñ¡£
2¡¢¿ªÊ¼££¾³ÌÐò££¾Oracle - OraHome81££¾Oracle Installation Products££¾Universal Installer
жװËùÓÐOracle²úÆ·
3¡¢ÔËÐÐregedit£¬Ñ¡ÔñHKEY_LOCAL_MACHINE\SOFTWARE\ORACLE£¬°´del¼üɾ³ýÕâ¸öÈë¿Ú¡£
4¡¢ÔËÐÐregedit£¬Ñ¡ÔñHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services£¬¹ö¶¯Õâ¸öÁÐ±í£¬É¾³ýËùÓÐOracleÈë¿Ú
5¡¢´Ó×ÀÃæÉÏ¡¢STARTUP£¨Æô¶¯£©×é¡¢³ÌÐò²Ëµ¥ÖУ¬É¾³ýËùÓÐÓйØOracleµÄ×éºÍͼ±ê
6¡¢ÖØÐÂÆô¶¯¼ÆËã»ú£¬ÖØÆðºó²ÅÄÜÍêȫɾ³ýOracleËùÔÚĿ¼
7¡¢É¾³ýÓëOracleÓйصÄÎļþ£¬Ñ¡ÔñOracleËùÔÚµÄȱʡĿ¼C:\Oracle£¬É¾³ýÕâ¸öÈë¿ÚĿ¼¼°ËùÓÐ×ÓĿ¼.
Ïà¹ØÎĵµ£º
GROUPINGº¯Êý¿ÉÒÔ½ÓÊÜÒ»ÁУ¬·µ»Ø0»òÕß1¡£Èç¹ûÁÐֵΪ¿Õ£¬ÄÇôGROUPING()·µ»Ø1£»Èç¹ûÁÐÖµ·Ç¿Õ£¬ÄÇô·µ»Ø0¡£GROUPINGÖ»ÄÜÔÚʹÓÃROLLUP»òCUBEµÄ²éѯÖÐʹÓᣵ±ÐèÒªÔÚ·µ»Ø¿ÕÖµµÄµØ·½ÏÔʾij¸öֵʱ£¬GROUPING()¾Í·Ç³£ÓÐÓá£
¹ØÓÚROLLUPºÍCUBEº¯ÊýµÄʹÓã¬Çë²Î¼ûÎÒµÄÁíһƪÎÄÕ¡£
http://blog.csdn.net/wh62592855/archive/2009/1 ......
¿ÉÒÔʹÓÃGROUPING_IDº¯Êý½èÖúHAVING×Ó¾ä¶Ô¼Ç¼½øÐйýÂË£¬½«²»°üº¬Ð¡¼Æ»òÕß×ܼƵļǼ³ýÈ¥¡£GROUPING_ID()º¯Êý¿ÉÒÔ½ÓÊÜÒ»Áлò¶àÁУ¬·µ»ØGROUPINGλÏòÁ¿µÄÊ®½øÖÆÖµ¡£GROUPINGλÏòÁ¿µÄ¼ÆËã·½·¨Êǽ«°´ÕÕ˳Ðò¶ÔÿһÁе÷ÓÃGROUPINGº¯ÊýµÄ½á¹û×éºÏÆðÀ´¡£
¹ØÓÚGROUPINGº¯ÊýµÄʹÓ÷½·¨¿ÉÒԲμûÎÒÇ°ÃæдµÄһƪÎÄÕÂ
http://blog.csdn ......
1£®Êýѧº¯Êý
¢Ù¾ø¶ÔÖµ
l S£ºselect abs(-1) value
l O£ºselect abs(-1) value from dual
¢ÚÈ¡Õû(´ó)
l S£ºselect ceiling(-001) value
l O£ºselect ceil(-001) value from dual
¢ÛÈ¡Õû£¨Ð¡£©
l S£ºselect floor(-001) value  ......
×ÊÁÏ»ñÈ¡×ÔѧϰºÎÃ÷Öø×÷<<Oracle DBA Åàѵ½Ì³Ì>>µÚ¶þ°æ֮ʱ.ÆäÖÐdba_¿ªÍ·µÄ±íÐèÒªÓÐsysdbaȨÏÞ²ÅÄÜ·ÃÎÊ.
1. »ñÈ¡Êý¾Ý¿âÃû×Ö,´´½¨ÈÕÆÚ,µ±Ç°Ä£Ê½,ÈÕ־ģʽµÈµÈ:
SELECT name,created,log_mode,open_mode from v$database;
2. »ñÈ¡ÔËÐÐʵÀýµÄÖ÷»úÃû,ʵÀýÃû,°æ±¾:
SELECT host_name,instance_name,ve ......
×÷ΪoracleµÄÏúÊÛÕæÐÄÕæÒâµÄÔÒâÓë´ó¼Ò·ÖÏíoracleµÄÒ»ÇУ¬ÎÒÕâ±ß²»ÊÇÇþµÀ£¬ÊÇoracle×ÊÉî×Ü´úÀí£¨ÖйúÈí¼þÓë¼¼Êõ·þÎñ¹É·ÝÓÐÏÞ¹«Ë¾£©£¬Ï£Íû´ó¼ÒÓйºÂòoracleÒâÔ¸µÄʱºò¼ÇµÃÎÒ£¨ÕÔÌìÊæ 15010529916£©£¬ÎһᾡÎÒËùÄܵİïÖú´ó¼Ò¡£
×î½üÓкܶàÈËÎÊÎÒoracleµÄ¹ºÂò·½Ê½£ºÔÚÕâÀïÎÒÏë²ûÊöµÄÊÇÉÌÎñÉϵĹºÂò· ......