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,²ÉÓÃËÄÉáÎåÈëµÄ·½Ê½.
Ïà¹ØÎĵµ£º
ÔÚCenotOS 5.3ÖÐÎÄ»·¾³Ï°²×°Oracle 10g R2ʱ£¬½øÈëͼÐλ¯½çÃæºó£¬·¢ÏÖÖÐÎÄÂÒÂë¡£
ÔÚÍøÉÏËÑË÷ºó£¬·¢ÏÖÊÇÓÉÓÚLinuxÉÏûÓа²×°Oracle°²×°Ê±Ê¹ÓõÄ×ÖÌå¿âÔì³ÉµÄ¡£
´ÓÒÔÏÂÍøÕ¾ÏÂÔØ×ÖÌå¿â
http://download.csdn.net/source/1073202
È»ºóÔÚLinuxÏÂÖ´ÐÐÒÔÏÂÃüÁ°Ñ×ÖÌå¿â°²×°µ½ÏàӦλÖü´¿É
mkdir -p /usr/share/fonts/zh_CN ......
ÔÚLinuxÉϰ²×°oracleµÄʱºò²»Ð¡ÐݲװÁËÁ½´Îlistener, ¸ãµÃlistenerµÄ¶Ë¿ÚºÅ±ä³ÉÁË1522¶ø²»ÊÇȱʡµÄ1521, ¿Í»§¶ËÁ¬Á˺þö¼Ã»ÓÐÁ¬½ÓÉÏ£¬×îºó²Å·¢ÏÖÊÇlistenerµÄ¶Ë¿ÚºÅ²»¶Ô¡£Ò»ÏÂÊÇÎҸıälistener¶Ë¿ÚºÅµÄ²½Ö裺
1. Ê×ÏÈÐèҪֹͣlistener, ʹÓÃÃüÁîlsnrctl stop
2. listenerÍ£Ö¹ÒԺ󣬵½ÄãµÄ$ORACLE_HOME/network/adminÏÂÕ ......
//¿´¿´ÈçºÎ±àдһЩ¸´ÔӵĴ洢¹ý³Ì
Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
ΪÁËÑéÖ¤£¬ÎÒÏÈ´´½¨Ò»ÕŲâÊÔ±í
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 ......
1.OracleDBConsoleorcl oem¿ØÖÆÌ¨µÄ·þÎñ½ø³Ì
2.OracleJobSchedulerORCL ¶¨Ê±Æ÷µÄ·þÎñ½ø³Ì
3.OracleOraDb10g_home1iSQL*Plus isql*plusµÄ·þÎñ½ø³Ì
4.OracleOraDb10g_home1TNSListener ¼àÌýÆ÷µÄ·þÎñ½ø³Ì
5.Or ......
ÎÒÃÇÒª×öµ½²»µ«»áдSQL,»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQL,ÒÔÏÂΪ±ÊÕßѧϰ¡¢ÕªÂ¼¡¢²¢»ã×ܲ¿·Ö×ÊÁÏÓë´ó¼Ò·ÖÏí£¡
£¨1£©Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
orACLEµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ, ......