µ±Ç°Î»Ö㺠Ö÷Ò³ > Êý¾Ý¿â > oracle >ÎÄÕÂÄÚÈÝ oracleÊý¾Ý²Ù×÷ºÍ¿ØÖÆÓïÑÔÏê½â À´Ô´£º ×÷Õߣº ·¢²¼Ê±¼ä£º2006-07-10 SQLÓïÑÔ¹²·ÖΪËÄ´óÀࣺÊý¾Ý²éѯÓïÑÔDQL£¬Êý¾Ý²Ù×ÝÓïÑÔDML£¬ Êý¾Ý¶¨ÒåÓïÑÔDDL£¬Êý¾Ý¿ØÖÆÓïÑÔDCL¡£ÆäÖÐÓÃÓÚ¶¨ÒåÊý¾ÝµÄ½á¹¹£¬±ÈÈç ´´½¨¡¢Ð޸ĻòÕßɾ³ýÊý¾Ý¿â£»DCLÓÃÓÚ¶¨ÒåÊý¾Ý¿âÓû§µÄȨÏÞ£»ÔÚÕâÆªÎÄÕÂÖÐÎÒ½«Ïêϸ½²ÊöÕâÁ½ÖÖÓïÑÔÔÚoracleÖеÄʹÓ÷½·¨¡£ ¡¡¡¡DMLÓïÑÔ ¡¡¡¡DMLÊÇSQLµÄÒ»¸ö×Ó¼¯£¬Ö÷ÒªÓÃÓÚÐÞ¸ÄÊý¾Ý...
by ½£ÐÄͨÃ÷ - MySQLÎĵµÖÐÐÄ - 2008-05-30 10:55:57 ÔĶÁ£¨580£© »Ø¸´£¨0£©
ÎáÊÇÐÂÊÖ£¬´ÓÀ´Ã»ÓÐÓÃoracle×ö¹ýÏîÄ¿£¬ÏÖÔÚÐèÒªÓÃoracle 8iÔÚsco unixware 7ÉÏ×öÒ»¸öÊý¾Ý¿â·þÎñÆ÷£¬Íû¸÷λ´ó¸ç´ó½ã°ï棬¸øÒ»¸öÏêϸµÄ¹ý³Ì£¬ÕâÀïÏÈл¹ýÁË£¬ÎÒµÄÓÊÏä aileenyuxiao@vip.sina.com
ѧϰ¹ý³ÌÖеÄ×ܽᣬÓÐÐËȤ²»·Á¿´¿´£¬Èç¹ûÓв»¶ÔµÄµØ·½£¬¸ßÊÖ²»ÒªÁôÇ飡£¡ ¡¡¡¡oracleµÄ±¸·ÝÓë»Ö¸´ÓÐÈýÖÖ±ê×¼µÄģʽ£¬´óÖ·ÖΪÁ½´óÀ࣬±¸·Ý»Ö¸´(ÎïÀíÉϵÄ)ÒÔ¼°µ¼Èëµ¼³ö(Âß¼ÉϵÄ)£¬¶ø±¸·Ý»Ö¸´ÓÖ¿ÉÒÔ¸ù¾ÝÊý¾Ý¿âµÄ¹¤×÷ģʽ·ÖΪ·Ç¹éµµÄ£Ê½(Nonarchivelog-style)ºÍ¹éµµÄ£Ê½(Archivelog-style),ͨ³££¬ÎÒÃǰѷǹ鵵ģʽ³ÆÎªÀ䱸·Ý£¬¶øÏàÓ¦µÄ°Ñ¹éµµÄ£Ê½³ÆÎªÈȱ¸·Ý£¬ËûÃǵĹØÏµÈçÏÂËùʾ ¡¡¡¡ÈýÖÖ·½Ê½¸÷ÓÐÓŵ㣬ÎÒÃÇ×ö¸ö±È½Ï(Õâ¸öÊÇÓÃFirew...
ѧϰ¹ý³ÌÖеÄ×ܽᣬÓÐÐËȤ²»·Á¿´¿´£¬Èç¹ûÓв»¶ÔµÄµØ·½£¬¸ßÊÖ²»ÒªÁôÇ飡£¡ ¡¡¡¡oracleµÄ±¸·ÝÓë»Ö¸´ÓÐÈýÖÖ±ê×¼µÄģʽ£¬´óÖ·ÖΪÁ½´óÀ࣬±¸·Ý»Ö¸´(ÎïÀíÉϵÄ)ÒÔ¼°µ¼Èëµ¼³ö(Âß¼ÉϵÄ)£¬¶ø±¸·Ý»Ö¸´ÓÖ¿ÉÒÔ¸ù¾ÝÊý¾Ý¿âµÄ¹¤×÷ģʽ·ÖΪ·Ç¹éµµÄ£Ê½(Nonarchivelog-style)ºÍ¹éµµÄ£Ê½(Archivelog-style),ͨ³££¬ÎÒÃǰѷǹ鵵ģʽ³ÆÎªÀ䱸·Ý£¬¶øÏàÓ¦µÄ°Ñ¹éµµÄ£Ê½³ÆÎªÈȱ¸·Ý£¬ËûÃǵĹØÏµÈçÏÂËùʾ ¡¡¡¡ÈýÖÖ·½Ê½¸÷ÓÐÓŵ㣬ÎÒÃÇ×ö¸ö±È½Ï(Õâ¸öÊÇÓÃFirew...
±¾ÎÄÎÒ»áÖØµãÌáʾºÍ9i²»Í¬µÄµØ·½¡£ÏêÇë²Î¼û£º http://www.ncn.cn/oracle/10i/o10i_hpux_dbca.htm
INSERT INTO "CHEN"."COLLECT_DEFINE"(NODE_NAME,NODE_IP,NODE_PORT,PORT_TYPE,TYPE_DESC,TIMEOUT_ALARM,REL_NUM) VALUES('101','192.168.16.123',7601,1,'alarm',30,1), ('102','192.168.16.123',7602,1,'alarm',30,2); ÔÚoracleÀïÐв»Í¬Ñ½,²»ÖªµÀÔõôÑùʵÏÖÄØ?
1£®ÒýÑÔ ÓÉÓÚPL/SQL²»ÄÜÓÃÀ´¿ª·¢ÃæÏòÆÕͨÓû§µÄÓ¦ÓóÌÐò£¬±ØÐë½èÖúÆäËûÓïÑÔ»ò¿ª·¢¹¤¾ß¡£ÔÚLinux²Ù×÷ϵͳÏÂÓ¦¸ÃÓÃʲôÓïÑÔ»ò¿ª·¢¹¤¾ßÀ´½øÐÐ oracle Êý¾Ý¿âÓ¦ÓõĿª·¢ÄØ£¿±¾ÎĽ«½éÉÜ£²ÖÖ·½°¸£ºPro*C¡¢JDBC¡£¶øÁíÒ»ÖÖSQLJ·½·¨£¬ÏÞÓÚÆª·ùÊ¡ÂÔ¡£ 2£® »·¾³ÉèÖà 2.1¡¡Èí¼þ»·¾³ ±¾ÎĵÄʵÑé»·¾³ÊÇÔÚRed Hat Linux 8.0²Ù×÷ϵͳÏ£¬ÒòΪ oracle 9iÒªÇóÖÁÉÙ512MBÄڴ棬ËùÒÔÎÒÃÇÑ¡Ôñoracle 8.1.7.0.1×÷ΪÊý¾Ý¿â»·¾³¡£ËµÃ÷Ò»µã£ºoracle 8iµÄ...
create table test (id number default student_id.nextval); //×¢Òâ,student_idΪһ¸öÐòÁÐ,student_id.nextval×ÔÔöΪ1. Õâ¸ö´úÂëΪʲôÔÚoracle´´½¨Êý¾Ý¿âµÄʱºòÐв»Í¨? [ ±¾Ìû×îºóÓÉ yeshenghai ÓÚ 2006-7-19 20:49 ±à¼ ]
¸÷λǰ±²£¬oracleÖÐROWIDµÄÐÐÇ¨ÒÆÊÇÔõô»ØÊ£¿¾ÍÊÇ˵ÎÒselectÁËÒ»¶ÑrowidÈ»ºóÖðÌõ°´rowidɾ³ý£¬Õâ¸ö¹ý³ÌÖÐÈç¹û·¢ÉúÐÐÇ¨ÒÆ£¬ÎÒɾ³ýµÄÊý¾Ý¾Í²»Äܱ£Ö¤¿Ï¶¨¾ÍÊÇÎÒ¿ªÊ¼Ñ¡ÖеÄÄÇЩÐÐÂð£¿
Ïê½â:Êý¾Ý¿âÃû¡¢ÊµÀýÃû¡¢oracle_SID¡¢Êý¾Ý¿âÓòÃû¡¢È«¾ÖÊý¾Ý¿âÃû¡¢·þÎñÃû ---------------------------------------------------- Êý¾Ý¿âÃû¡¢ÊµÀýÃû¡¢Êý¾Ý¿âÓòÃû¡¢È«¾ÖÊý¾Ý¿âÃû¡¢·þÎñÃû £¬ ÕâÊǼ¸¸öÁîºÜ¶à³õѧÕßÈÝÒ×»ìÏýµÄ¸ÅÄî¡£ÏàÐźܶà³õѧÕß¶¼ÓëÎÒÒ»Ñù±»±êÌâÉÏÕâЩ¸ö¸ÅÄî¸ãµÃһͷÎíË®¡£ÎÒÃÇÏÖÔÚ¾ÍÀ´°ÑËüÃÇŪ¸öÃ÷°×¡£ Ò»¡¢Êý¾Ý¿âÃû ʲôÊÇÊý¾Ý¿âÃû£¿ Êý¾Ý¿âÃû¾ÍÊÇÒ»¸öÊý¾Ý¿âµÄ±êʶ£¬¾ÍÏñÈ˵ÄÉí·ÝÖ¤ºÅÒ»Ñù¡£ËûÓòÎÊýDB_NAME±íʾ£¬...
¸½¼þÖÐÊÇÎÒµÄÒ»¸ö²âÊÔÀý×Ó£º OCIBlobLocator *pBlob_array[100]; int iRowCount = 10; char out[8] = "1234\0"; char sqlstr[MAX_PATH] = "selete testblobcol1 from testtable1"; int iRowIdx = 1; int i = 0; .... EXEC SQL FOR :iRowCount ALLOCATE DESCRIPTOR :out; EXEC SQL PREPARE S FROM :sqlstr; EXEC SQL DECLARE C CURSOR FOR S; EXEC SQL OPEN C ; EXEC SQL DESCRIBE OUTPUT S USING DESCRIPTOR :out; ...