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

Oracle ËÄÉáÎåÈ뺯Êý

ceil(number)   ´óÓÚ»òµÈÓÚµÄ×îСÕûÊý  
  floor(number)   СÓÚ»òµÈÓÚµÄ×î´óÕûÊý  
  trunc(number,m)   ÔÚÕûÊýnumberµÄmλÖýصôm¼°ÒÔºóµÄλÊý:  
  Èç:trunc(15.78,1)=15.7    
        trunc(15.78,-1)=15;  
  round(number,m)   Ó÷¨Í¬trunc,²ÉÓÃËÄÉáÎåÈëµÄ·½Ê½.


Ïà¹ØÎĵµ£º

OracleÖÐstart with...connect by prior×Ó¾äÓ÷¨

connect by Êǽṹ»¯²éѯÖÐÓõ½µÄ£¬Æä»ù±¾Óï·¨ÊÇ£º
select ... from tablename start with Ìõ¼þ1
connect by Ìõ¼þ2
where Ìõ¼þ3;
Àý£º
select * from table
start with org_id = 'HBHqfWGWPy'
connect by prior org_id = parent_id;
¼òµ¥ËµÀ´Êǽ«Ò»¸öÊ÷×´½á¹¹´æ´¢ÔÚÒ»ÕűíÀ±ÈÈçÒ»¸ö±íÖдæÔÚÁ½¸ö×Ö¶ ......

ORACLE µÈ´ýʼþ ¡¶ÉîÈëdz³öORACLEµÚ°ËÕ¡·

µÈ´ýʼþµÄÔ´Æð
µÈ´ýʼþµÄ¸ÅÄî´ó¸ÅÊÇ´ÓORACLE 7.0.12ÖÐÒýÈëµÄ£¬´óÖÂÓÐ100¸öµÈ´ýʼþ¡£ÔÚORACLE 8.0ÖÐÕâ¸öÊýÄ¿Ôö´óµ½ÁË´óÔ¼150¸ö£¬ÔÚORACLE 8IÖдóÔ¼ÓÐ220¸öʼþ£¬ÔÚORACLE 9IR2ÖдóÔ¼ÓÐ400¸öµÈ´ýʼþ£¬¶øÔÚ×î½üORACLE 10GR2ÖУ¬´óÔ¼ÓÐ874¸öµÈ´ýʼþ¡£
ËäÈ»²»Í¬°æ±¾ºÍ×é¼þ°²×°¿ÉÄÜ»áÓв»Í¬ÊýÄ¿µÄµÈ´ýʼþ£¬µ«ÊÇÕâЩµÈ´ýÊ ......

½â¾öOracleÖÐÎÄÂÒÂë(ת)


Ò»¡¢Ê²Ã´ÊÇoracle×Ö·û¼¯
¡¡¡¡Oracle×Ö·û¼¯ÊÇÒ»¸ö×Ö½ÚÊý¾ÝµÄ½âÊ͵ķûºÅ¼¯ºÏ,ÓдóС֮·Ö,ÓÐÏ໥µÄ°üÈݹØÏµ¡£ORACLE Ö§³Ö¹ú¼ÒÓïÑÔµÄÌåϵ½á¹¹ÔÊÐíÄãʹÓñ¾µØ»¯ÓïÑÔÀ´´æ´¢£¬´¦Àí£¬¼ìË÷Êý¾Ý¡£ËüʹÊý¾Ý¿â¹¤¾ß£¬´íÎóÏûÏ¢£¬ÅÅÐò´ÎÐò£¬ÈÕÆÚ£¬Ê±¼ä£¬»õ±Ò£¬Êý×Ö£¬ºÍÈÕÀú×Ô¶¯ÊÊÓ¦±¾µØ»¯ÓïÑÔºÍÆ½Ì¨¡£
SELECT * from V$NLS_PARAMETERS ......

ÐÞ¸ÄOracle XDBµÄ8080¶Ë¿Ú

´ÓOracle 9i¿ªÊ¼£¬OracleµÄ°²×°È±Ê¡°üº¬ÁËXDB¡£ÔÚÆô¶¯Êý¾Ý¿âºó£¬Oracle XDBµÄhttp·þÎñ½«»á×Ô¶¯Õ¼ÓÃÁË8080¶Ë¿Ú£¬Õâ¸øÊ¹ÓûòJBoss¡¢Tomcat½øÐÐjava web¿ª·¢µÄÈËÔì³ÉÁËÐí¶à²»±ØÒªµÄÂé·³¡£
±¾ÎĽ«Ö÷Òª½éÉÜÐÞ¸ÄXDBµÄhttpºÍftp·þÎñ¶Ë¿ÚµÄ3ÖÖ·½·¨¡£
1.ʹÓÃdbms_xdb°üÐ޸Ķ˿ÚÉèÖÃ
ʹÓÃsysµÇ¼sqlplus
sqlplus sys/password ......

OracleÓû§¡¢½ÇÉ«¡¢È¨ÏÞºÍϵͳ×ÊÔ´¹ÜÀí³£ÓòÙ×÷

²éѯÓû§ÐÅÏ¢
SELECT USERNAME,DEFAULT_TABLESPACE, TEMPORARY_TABLESPACE, PROFILE, ACCOUNT_STATUS, CREATED from dba_users; ²éѯÓû§¿Õ¼äʹÓúÍÉÏÏÞÇé¿ö
SELECT username, tablespace_name, bytes/1024/1024 space_used_in_mb, max_bytes/1024/1024 max_space_in_mb from dba_ts_quotas; ´´½¨ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ