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

oracleÊý¾Ý¿âÐ¶ÔØ²½Öè

Ð¶ÔØOracle £º
1¡¢Í£Ö¹ËùÓÐOracle·þÎñ£¬µãUniversal InstallerÐ¶ÔØ
2¡¢É¾³ý×¢²á±íÖеÄËùÓйØÓÚOracleÏî
£¨1£©ÔÚHKEY_LOCAL_MACHINE\SOFTWAREÏ£¬É¾³ýOracleĿ¼
£¨2£©ÔÚHKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\ServicesÏ£¬É¾³ýËùÓÐOracleÏî
£¨3£©ÔÚHKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\ServicesÏ£¬É¾³ýËùÓÐOracleÏî
£¨4£©ÔÚHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\ServicesÏ£¬É¾³ýËùÓÐOracleÏî
£¨5£©ÔÚHKEY_CLASSES_ROOTÏ£¬É¾³ýËùÓÐOracleÏî
3¡¢É¾³ýÓ²ÅÌÉÏËùÓÐOracleÎļþ
£¨1£©Oracle°²×°Îļþ
£¨2£©ÏµÍ³Ä¿Â¼Ï£¬ÔÚProgram filesÎļþ¼ÐÖеÄOracleÎļþ
4¡¢ÖØÆô£¬Íê³ÉÐ¶ÔØ¡£


Ïà¹ØÎĵµ£º

ÔÚoracleÀûÓÃÓαêÈ¡Êý¾Ý¿âµÄ½á¹û¼¯Ó¦ÓÃʵÀý£º

SQL> create table test2(s1 varchar(10),s2 varchar2(10));
±íÒÑ´´½¨¡£
SQL> insert into test2 values('11','111');
ÒÑ´´½¨ 1 ÐС£
SQL> insert into test2 values('22','222');
ÒÑ´´½¨ 1 ÐС£
SQL> CREATE OR REPLACE PACKAGE test222 AS
2 TYPE t_cursor IS REF CURSOR;
3 procedure p_tes ......

¡¾×ª¡¿OracleÐÔÄܵ÷ÓÅÔ­Ôò

¡¡¡¾IT168 ¼¼ÊõÎĵµ¡¿ÈκÎÊÂÇé¶¼ÓÐËüµÄÔ´Í·£¬Òª½â¾öÎÊÌ⣬ҲµÃ´ÓÔ´Í·¿ªÊ¼£¬Ó°ÏìORACLEÐÔÄܵÄÔ´Í··Ç³£¶à£¬Ö÷Òª°üÀ¨ÈçÏ·½Ã棺Êý¾Ý¿âµÄÓ²¼þÅäÖÃ:CPU¡¢ÄÚ´æ¡¢ÍøÂçÌõ¼þ¡£
¡¡¡¡1. CPU:ÔÚÈκλúÆ÷ÖÐCPUµÄÊý¾Ý´¦ÀíÄÜÁ¦ÍùÍùÊǺâÁ¿¼ÆËã»úÐÔÄܵÄÒ»¸ö±êÖ¾£¬²¢ÇÒORACLEÊÇÒ»¸öÌṩ²¢ÐÐÄÜÁ¦µÄÊý¾Ý¿âϵͳ£¬ÔÚCPU·½ÃæµÄÒªÇó¾Í¸ü¸ßÁË£¬Èç¹ûÔ ......

¹ØÓÚMSSQL¼°OracleÊý¾Ý¿âÖеÄËøÓë²¢·¢µÄС½á

      ×î½ü£¬¹¤×÷µÄÉÏÐèÒª´¦ÀíÒ»ÏÂÏîÄ¿Öеļ«ÉÙÁ¿Êý¾ÝµÄÖØ¸´ÎÊÌâ¡£¾­¹ý·ÖÎö£¬½á¹û·¢ÏÖÊdzÌÐò²¢·¢Ã»Óд¦ÀíºÃ¶øµ¼Öµġ£¾­¹ýÒ»·¬ÃþË÷£¬¶ÔÊý¾Ý¿âÖеÄËø¼°³ÌÐòµÄ²¢·¢ÓÐÁËÒ»µãµãСµÄÐĵá£ÌØÐ´µ½´ËÀ´Óë´ó¼Ò·ÖÏíһϡ£
      Ê×ÏÈ£¬ÎÒÃÇÀ´Á˽âÒ»ÏÂʲô½Ð×öËø¡£
   ......

Oracle³£Óýű¾Ê¾Àý

CREATE SEQUENCE s_report_id     INCREMENT BY 1   MAXVALUE 999999    START WITH 1;  
CREATE SEQUENCE checkup_no_seq  NOCYCLE          MAXVALUE 999999    START WITH 2;
 
CRE ......

JavaÁ¬½ÓOracleÎÊÌâ

JavaÖ´ÐÐstm.executeQuery(sql); ʱ×ÜÊÇÌáʾ£ºjava.sql.SQLException: ORA-00911: ÎÞЧ×Ö·û£¬ÅªÁ˰ëÌ컹Êdzö´í£¬ÎÞÄΣ¬ÄóöɱÊÖïµ£¬Googleһϣ¬Ôε¹£¬·¢ÏÖÎÒµÄString  sql = “select detail from test.result where person_id = 4; "£¬Ã²ËÆÃ»´íÎó°É£¬½á¹ûÎÒÎÒ±ØÐëÈ¥µô×îºó·ÖºÅ£¬±¾À´ÊÇÏë¸ãµÃרҵµã£¬¾Í¼Û¼Ó¸ö·Ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ