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

oracleÖеÄto_char()

½éÉÜto_char(Êý×Ö, ‘¸ñʽ’)£¬±È½Ï³£Óõĸñʽ
9   ±íʾÓÐЧλÊý
0   ÓÃ0²¹×ãλÊý
B   Óÿոñ²¹×ãλÊý
Ô­ÊýµÄλÖÃÓÐʵ¼ÊÊý×ÖռλµÄʱºò£¬0ºÍ9µÄЧ¹ûÊÇÒ»ÑùµÄ¡£
0ºÍ9µÄÇø±ðÔÚÓÚ¸ñʽÖеÄÄÇһλÖÃʵ¼ÊÊý×ÖûÓÐվλµÄÇé¿öÏ¡£
select to_char(0.45,'0.99'); ½á¹ûÊÇ0.45
select to_char(0.45,'9.99'); ½á¹ûÊÇ.45
select to_char(2.45,'0.99'); ½á¹ûÊÇ2.45
select to_char(2.45,'9.99'); ½á¹ûÊÇ2.45
ÒòΪ0.45µÄÓÐЧÊý×ÖÊÇСÊýµãºóµÚһλ£¬Ð¡ÊýµãǰûÓÐÓÐЧÊý×Ö£¬¸ÄΪÈç¹ûÏëÒªÏÔʾµÄ»°£¬¾ÍÒªÓÃ0À´²¹³äλÊý¡£
Àý×Ó£º
SELECT
to_char(123.45, '0009.9'),
to_char(123.45, '9999.9'),
to_char(123.45, 'B999.9')
from dual;
½á¹ûΪ
TO_CHAR(123.45,'0009.9') TO_CHAR(123.45,'9999.9') TO_CHAR(123.45,'B999.9')
------------------------ ------------------------ ------------------------
0123.5 123.5 123.5


Ïà¹ØÎĵµ£º

oracle install

1 ¡¢´´½¨Óû§ºÍ×é
 /usr/sbin/groupadd oinstall
 /usr/sbin/groupadd dba
 /usr/sbin/useradd -g oinstall -G dba oracle
2¡¢ÅäÖÃOSºËÐIJÎÊý
 1£©±à¼­Îļþ /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmm ......

install oracle 9204 on linux as4

 ÏÈroot´ò²¹¶¡£ºp3006854_9204_linux.zip
ÔÙÉèoracle»·¾³±äÁ¿
°²×°
°²×°½áÊø½¨¿â֮ǰÐèÒª´òµÄ²¹¶¡ÓУº
p2617419_220_GENERIC.zip
p3119415_9204_linux.zip
¾ßÌå²Î¿¼ÕâÆªÎÄÕ£º
Redhat Enterprise Linux 4°²×°oracle
¹Ø¼ü×Ö: redhat el4 oracle °²×°
Ò». °²×°×¼±¸
  1. as4°²×°Íêºó£¬ÐèÒª¼ì²éÏÂÁÐÈí¼þ ......

OracleÊý¾Ý×ÖµäµÄµ¼³ö

-- ²éѯij±íµÄÊý¾Ý×Öµä
 SELECT  A.TABLE_NAME AS "±íÃû",A.COLUMN_NAME AS "×Ö¶ÎÃû",
 DECODE(A.CHAR_LENGTH,0,DECODE(A.DATA_SCALE,NULL,A.DATA_TYPE,A.DATA_TYPE||'('||A.DATA_PRECISION||','||A.DATA_SCALE||')'),
 A.DATA_TYPE||'('||A.CHAR_LENGTH||')') as "×Ö¶ÎÀàÐÍ1",A.DATA_TYPE AS "×Ö¶Î ......

³¹µ×Ð¶ÔØORACLE(WINXP)

ÓÃoracleµÄÐ¶ÔØ³ÌÐò²¢²»ÄÜÍêÈ«Ð¶ÔØ¸É¾»¡£Èç֮ǰµÄÃüÃûµÄoracle sid ²»ÄÜÔÙʹÓ᣻áÌáʾsid´æÔÚ¡£ÏÂÃæÊÇÔÚwinxpÏÂÍêÈ«Ð¶ÔØoracleµÄ·½·¨¡£
1¡¢¿ªÊ¼£­£¾ÉèÖã­£¾¿ØÖÆÃæ°å£­£¾¹ÜÀí¹¤¾ß£­£¾·þÎñ  
     Í£Ö¹ËùÓÐOracle·þÎñ¡£  
2¡¢¿ªÊ¼£­£¾³ÌÐò£­£¾Oracle  -  OraHome81£­£¾Oracle   ......

OracleÊý¾Ý¿âÓαêʹÓôóÈ«

SQLÊÇÓÃÓÚ·ÃÎÊORACLEÊý¾Ý¿âµÄÓïÑÔ£¬PL/SQLÀ©Õ¹ºÍ¼ÓÇ¿ÁËSQLµÄ¹¦ÄÜ£¬Ëü ͬʱÒýÈëÁ˸üÇ¿µÄ³ÌÐòÂß¼­¡£ PL/SQLÖ§³ÖDMLÃüÁîºÍSQLµÄÊÂÎñ¿ØÖÆÓï¾ä¡£DDLÔÚPL/SQLÖв»±»Ö§³Ö£¬Õâ¾ÍÒâζ×÷ÔÚPL/SQL³ÌÐò¿éÖв»ÄÜ´´½¨±í»òÆäËûÈκζÔÏ󡣽Ϻà µÄPL/SQL³ÌÐòÉè¼ÆÊÇÔÚPL/SQL¿éÖÐʹÓÃÏóDBMS_SQLÕâÑùµÄÄÚ½¨°ü»òÖ´ÐÐEXECUTE IMMEDIATEÃüÁÁ¢¶¯Ì ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ