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

ORACLEÈÏÖ¤Åàѵ³£¼ûÎÊÌâ

ORACLEÈÏÖ¤Åàѵ³£¼ûÎÊÌâ
1¡¢ÎÊ£ºÊ²Ã´ÊÇ Oracle ÈÏÖ¤£¿¶¼ÓÐÄÄЩÖÖÀࣿ                              
¡¡¡¡´ð£ºOracle ÈÏÖ¤ÊÇÓÉOracle¹«Ë¾°ä²¼²¢ÊµÊ©µÄÒ»ÏîȨÍþµÄרҵ¼¼Êõ±ê×¼ËüÊÇרΪÈÏÖ¤ÄÇЩÄܹ»Âú×ã¶ÔOracleºËÐIJúÆ·µÄ·þÎñÓëÖ§³Ö²¢¾ßÓÐæµÊìµÄ²Ù×÷ÄÜÁ¦Óë¹ã·ºÀíÂÛ֪ʶµÄרҵÈËÊ¿¡£Oracle ÈÏ֤Ŀǰ·ÖΪÈý¸ö²ã´ÎOCA¡¢OCP¡¢OCM¡£¼´Oracle Certified Professi£¨Ö»ÓÐOracle9iÓд˼¶ÈÏÖ¤£©£¬OCP¼´£¬Oracle Certified Professi£¬OCM¼´Oracle Certified Master¡£ÆäÖÐOCP°üÀ¨ÁËÊý¾Ý¿â¹ÜÀí·½ÏòµÄDBA¡¢Êý¾Ý¿â¿ª·¢·½ÏòµÄDEV¼°OracleÓ¦ÓòúÆ··½ÏòµÄApplicationsר¼Ò¡£
2¡¢ÎÊ£ºOracle ÈÏÖ¤¶ÔÎÒ¸öÈ˵ÄÒâÒåºÎÔÚ£¿                                  
   ´ð£ºÒâÒåÖØ´ó¡£»ñµÃÓëÖ°ÎñÏà¹ØµÄÈÏÖ¤£¬Ö¤Ã÷ÄúÊÇÒ»¸öºÏ¸ñµÄ¼¼ÊõÈËÔ±¡£ ×÷ΪOracle ÈÏ֤ר¼Ò£¬Äú½«¾ßÓжÔÒµ½ç×î¾ßÌôÕ½ÐԵĻúÓö¸üÉîµÄ¶´²ìÁ¦ ²¢»ñÈ¡¸ü¶àµÄÊÕ»ñ ÐÅÏ¢¼¼ÊõÁìÓòÐèÒª´óÁ¿×¨¼Ò£¬Í¬Ê±¹¤×÷¾ºÕùÒ²Òì³£¼¤ÁÒ£¬ ²»ÂÛ¶ÔÓÚÐÂÊÖ»¹ÊÇÓо­ÑéµÄר¼Ò¶¼ÐèÒªÕÆÎÕÓÃÈ˵¥Î»¸ÐÐËȤµÄ¼¼Êõ¡£ÓÃÈ˵¥Î»Ñ°ÕÒ¸÷ÖÖ·½Ê½À´Çø·ÖÔ±¹¤ºÍDZÔÚÔ±¹¤ÒªÇóÔ±¹¤±ØÐë¾ß±¸ÎªÓÐЧ¹¤×÷ËùÐèµÄ¼áʵµÄ¼¼Êõ»ù´¡¡£
3¡¢ÎÊ£ºÔõÑù²ÅÄÜ»ñµÃOracle ÈÏÖ¤£¿
¡¡´ð£ºÄúÐèÒª°´ÕÕÄúµÄÖ°Òµ·¢Õ¹·½Ïò£¬²Î¼ÓÅàѵ²¢Í¨¹ýÏàÓ¦µÄOracle¹ú¼ÊÈÏÖ¤¡£
4¡¢ÎÊ£ºÎÒÏ뿼Oracle  ÈÏÖ¤£¬ÇëÎʿɲ»¿ÉÒÔÖ±½Ó²Î¼Ó¿¼ÊÔ£¿
´ð£º´Ó2002Äê9ÔÂ1ÈÕÆðOracle¹«Ë¾¿ªÊ¼Ö´ÐÐеÄÈÏÖ¤¹æ¶¨£ºÖ±½Ó²Î¼Ó¿¼ÊÔÄú½«²»ÄÜ»ñµÃ Oracle ÈÏÖ¤¡£Ò²¾ÍÊÇ˵£¬ÄúÈç¹ûÏë»ñµÃOracle¾Í±ØÐë²Î¼ÓOracleÊÚȨ½ÌÓýÖÐÐĵÄÅàѵ£¬Õâ¾ÍÒâζ×ÅÖ»ÓвμÓÁËOracleÕý¹æÑϸñÅàѵµÄÈË£¬²ÅÓÐ×ʸñ»ñµÃOracleר¼ÒÈÏÖ¤£¬Õâ¾Í±£Ö¤ÁËOracle ÈÏÖ¤µÄº¬½ðÁ¿£¬Ò²ÊǶÔOracle ÈÏ֤ר¼ÒµÄ±£»¤¡£
5¡¢ÎÊ£ºOracle 9i²úÆ·µÄ¶¨Î»¼°¹¦ÄÜÊÇʲô£¿
¡¡´ð£ºOracle 9iÊý¾Ý¿âÊÇOracle¹«Ë¾ÍƳöµÄ×îÐÂÒ»´úÊý¾Ý¿â£¬ÓëOracle 8iÏà±ÈÔö¼ÓÁËÉÏ°ÙÖÖÐÂÌØÐÔ£¬ÆäÖÐ×îÍ»³öµÄÊǾ­¼ÃÐÔ¡¢¸ß¿ÉÉìËõÐԺ͸߿ÉÓÃÐÔÒÔ¼°ÍêÉƵŦÄÜ¡£Oracle 9i²ÉÓÃÁËReal Application  Clusters¼¼Êõ£¬ÎªÓû§ÌṩÁËÎÞÏ޵ĿÉÉìËõÐÔºÍ×


Ïà¹ØÎĵµ£º

ORACLEʹÓÃEXCEPTIONS±í²éѯ³ö±íÖÐÖظ´¼Ç¼

SQL> conn system/oracle
Connected.
SQL> create table scott.t1(id number primary key,name varchar2(10)); --´´½¨²âÊÔ±í
Table created.
SQL> select constraint_name,table_name,constraint_type, --²é¿´ÏàÓ¦ÍêÕûÐÔÔ¼ÊøµÄ״̬
  2  status,deferrable,deferred,validated
  3  fro ......

½â¾öOracle 9iºÍTomcat¶Ë¿Ú³åÍ»(תÔØ)


    ·½°¸Ò»£º
    ÐÂ×°ÁËϵͳºó£¬·¢ÏÖÔÚµ÷ÊÔ³ÌÐòʱTOMCATÌáʾ8080¶Ë¿ÚÒѱ»Õ¼Óã¬ÓÚÊÇÔËÐÐNETSTAT -ANO²é¿´¶Ë¿ÚʹÓÃÇé¿ö£¬·¢ÏÖ8080¶Ë¿Ú±»ORACLEµÄ¼àÌýÆ÷¸øÕ¼ÓÃÁË£¬ÓÚÊǽáºÏÉÏÍø²éµ½·½·¨£¬½«ORACLE XDBµÄHTTP·þÎñ¶Ë¿Ú¸Ä³É8081£¬ÎÊÌâ½â¾ö¡£
 
    ×ܽáһϿɽâ¾öµÄ·½ ......

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 ......

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ÖеÄto_char()

½éÉÜto_char(Êý×Ö, ‘¸ñʽ’)£¬±È½Ï³£Óõĸñʽ
9   ±íʾÓÐЧλÊý
0   ÓÃ0²¹×ãλÊý
B   Óÿոñ²¹×ãλÊý
Ô­ÊýµÄλÖÃÓÐʵ¼ÊÊý×ÖռλµÄʱºò£¬0ºÍ9µÄЧ¹ûÊÇÒ»ÑùµÄ¡£
0ºÍ9µÄÇø±ðÔÚÓÚ¸ñʽÖеÄÄÇһλÖÃʵ¼ÊÊý×ÖûÓÐվλµÄÇé¿öÏ¡£
select to_char(0.45,'0.99'); ½á¹ûÊÇ0.45
select ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ