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¡¢ÖØÆô£¬Íê³ÉÐ¶ÔØ¡£
Ïà¹ØÎĵµ£º
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 ......
¡¡¡¾IT168 ¼¼ÊõÎĵµ¡¿ÈκÎÊÂÇé¶¼ÓÐËüµÄÔ´Í·£¬Òª½â¾öÎÊÌ⣬ҲµÃ´ÓÔ´Í·¿ªÊ¼£¬Ó°ÏìORACLEÐÔÄܵÄÔ´Í··Ç³£¶à£¬Ö÷Òª°üÀ¨ÈçÏ·½Ã棺Êý¾Ý¿âµÄÓ²¼þÅäÖÃ:CPU¡¢ÄÚ´æ¡¢ÍøÂçÌõ¼þ¡£
¡¡¡¡1. CPU:ÔÚÈκλúÆ÷ÖÐCPUµÄÊý¾Ý´¦ÀíÄÜÁ¦ÍùÍùÊǺâÁ¿¼ÆËã»úÐÔÄܵÄÒ»¸ö±êÖ¾£¬²¢ÇÒORACLEÊÇÒ»¸öÌṩ²¢ÐÐÄÜÁ¦µÄÊý¾Ý¿âϵͳ£¬ÔÚCPU·½ÃæµÄÒªÇó¾Í¸ü¸ßÁË£¬Èç¹ûÔ ......
×î½ü£¬¹¤×÷µÄÉÏÐèÒª´¦ÀíÒ»ÏÂÏîÄ¿Öеļ«ÉÙÁ¿Êý¾ÝµÄÖØ¸´ÎÊÌâ¡£¾¹ý·ÖÎö£¬½á¹û·¢ÏÖÊdzÌÐò²¢·¢Ã»Óд¦ÀíºÃ¶øµ¼Öµġ£¾¹ýÒ»·¬ÃþË÷£¬¶ÔÊý¾Ý¿âÖеÄËø¼°³ÌÐòµÄ²¢·¢ÓÐÁËÒ»µãµãСµÄÐĵá£ÌØÐ´µ½´ËÀ´Óë´ó¼Ò·ÖÏíһϡ£
Ê×ÏÈ£¬ÎÒÃÇÀ´Á˽âÒ»ÏÂʲô½Ð×öËø¡£
......
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Ö´ÐÐstm.executeQuery(sql); ʱ×ÜÊÇÌáʾ£ºjava.sql.SQLException: ORA-00911: ÎÞЧ×Ö·û£¬ÅªÁ˰ëÌ컹Êdzö´í£¬ÎÞÄΣ¬ÄóöɱÊÖïµ£¬Googleһϣ¬Ôε¹£¬·¢ÏÖÎÒµÄString sql = “select detail from test.result where person_id = 4; "£¬Ã²ËÆÃ»´íÎó°É£¬½á¹ûÎÒÎÒ±ØÐëÈ¥µô×îºó·ÖºÅ£¬±¾À´ÊÇÏë¸ãµÃרҵµã£¬¾Í¼Û¼Ó¸ö·Ö ......