Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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,²ÉÓÃËÄÉáÎåÈëµÄ·½Ê½.


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

oracle 10g ÔÚ RED HAT ENTERPRISE LINUX 5ϵݲװ

ORACLE 10GÔÚLINUXµÄ°²×°:
ÏÈÉÏÀ´Á½ÕÅͼ:
DBAÊÇŬÁ¦µÄ·½Ïò,ORACLE DBA°üÂÞÍòÏó,Á¬LINUX/UNIX¶¼¸ã²»¶¨,»¹ÅªP¸öORACLE°¡.
Á½²¿·Ö:
1.RED HAT ENTERPRISE LINUX 5µÄ°²×°
  Äѵã(¶ÔÓÚÏÖÔÚµÄÎÒÀ´Ëµ):1.1YUM±¾µØÔ´µÄÅäÖÃ;ÍøÂçÓÐÏà¹Ø×ÊÁÏ,²»¶à˵ÁË.ÓÉÓÚÊDZ¾»úʹÓÃ,²Î¿¼ÁËFTPÔ´ºó,ÎÒʹÓÃÁËFILEÔ´;
   &nb ......

javaµ÷ÓÃoracle´æ´¢¹ý³Ì

//¿´¿´ÈçºÎ±àдһЩ¸´ÔӵĴ洢¹ý³Ì
Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
ΪÁËÑéÖ¤£¬ÎÒÏÈ´´½¨Ò»ÕŲâÊÔ±í
create table mytest(myid varchar2(30),myname varchar2(50));
´æ´¢¹ý³ÌΪ£º
create or replace PROCEDURE mytest2(id in varchar2,name in varchar2)  as
begin
   insert into mytest (myid,myname) valu ......

Oracle ×Ö·û¼¯µÄ²é¿´ºÍÐÞ¸Ä

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

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ºÅ