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,²ÉÓÃËÄÉáÎåÈëµÄ·½Ê½.
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
Êý¾Ý¿âÉè¼Æ£º
CREATE TABLE ADVERTISE_CATEGORY
(
CATEGORY_ID NUMBER PRIMARY KEY, --½ÚµãID
CATEGORY_NAME VARCHAR2(500), &nb ......
µÈ´ýʼþµÄÔ´Æð
µÈ´ýʼþµÄ¸ÅÄî´ó¸ÅÊÇ´ÓORACLE 7.0.12ÖÐÒýÈëµÄ£¬´óÖÂÓÐ100¸öµÈ´ýʼþ¡£ÔÚORACLE 8.0ÖÐÕâ¸öÊýÄ¿Ôö´óµ½ÁË´óÔ¼150¸ö£¬ÔÚORACLE 8IÖдóÔ¼ÓÐ220¸öʼþ£¬ÔÚORACLE 9IR2ÖдóÔ¼ÓÐ400¸öµÈ´ýʼþ£¬¶øÔÚ×î½üORACLE 10GR2ÖУ¬´óÔ¼ÓÐ874¸öµÈ´ýʼþ¡£
ËäÈ»²»Í¬°æ±¾ºÍ×é¼þ°²×°¿ÉÄÜ»áÓв»Í¬ÊýÄ¿µÄµÈ´ýʼþ£¬µ«ÊÇÕâЩµÈ´ýÊ ......
´ÓOracle 9i¿ªÊ¼£¬OracleµÄ°²×°È±Ê¡°üº¬ÁËXDB¡£ÔÚÆô¶¯Êý¾Ý¿âºó£¬Oracle XDBµÄhttp·þÎñ½«»á×Ô¶¯Õ¼ÓÃÁË8080¶Ë¿Ú£¬Õâ¸øÊ¹ÓûòJBoss¡¢Tomcat½øÐÐjava web¿ª·¢µÄÈËÔì³ÉÁËÐí¶à²»±ØÒªµÄÂé·³¡£
±¾ÎĽ«Ö÷Òª½éÉÜÐÞ¸ÄXDBµÄhttpºÍftp·þÎñ¶Ë¿ÚµÄ3ÖÖ·½·¨¡£
1.ʹÓÃdbms_xdb°üÐ޸Ķ˿ÚÉèÖÃ
ʹÓÃsysµÇ¼sqlplus
sqlplus sys/password ......
@@servername:·µ»ØÔËÐÐSQL ServerÊý¾Ý¿â±¾µØ·þÎñÆ÷µÄÃû³Æ¡£
@@remserver:·µ»ØµÇ¼¼Ç¼ÖмÇÔØµÄÔ¶³ÌSQL Server·þÎñÆ÷µÄÃû³Æ¡£
@@connections:·µ»Ø×ÔÉÏ´ÎÆô¶¯SQL ServerÒÔÀ´Á¬½Ó»òÊÔͼÁ¬½ÓµÄ´ÎÊý£¬ÓÃÆä¿ÉÈùÜÀíÈËÔ±·½±ãµØÁ˽â½ñÌìËùÓÐÊÔͼÁ¬½Ó·þÎñÆ÷µÄ´ÎÊý¡£
@@cursor_rows:·µ»Ø×îºóÁ¬½ÓÉϲ¢´ò¿ªµÄÓαêÖе±Ç°´æÔڵĺϸñ ......