¹ØÓÚOracleµÄLoop²Ù×÷
ÓÐÒ»¸ö±íÃûΪTest£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎCola£¬ÓÃLoop²Ù×÷ÏòÀïÃæ²åÈë8ÌõÊý¾Ý£¨0-10£©£¬µ«Åųý5-7£¬ ¸ÃÈçºÎʵÏÖ£¬Íû¸ßÊÖÖ¸½Ì¡£¡£
for i in 0..7 loop if i>=5 then insert into test(Cola) values(i+3); else insert into test(cola)values(i); end if; end loop;ÒýÓà for i in 0..7 loop if i>=5 then insert into test(Cola) values(i+3); else insert into test(cola)values(i); end if; end loop; ·Ç³£¸Ðл£¡
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i 2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1 3.oracle sql developer°æ±¾ 1.5.5 ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......
ÒÔǰ³ÌÐòºÃºÃµÄ,ÄܽøÐÐÈκβÙ×÷ µ«´Ó×òÌ쿪ʼͻȻÁ¬½ÓÊý¾Ý¿âʧ°Ü,´úÂëÈçÏÂ: try { ::CoInitialize(NULL); hr=m_pConnection.Creat ......
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд ORACLEÖУº select floor(months_between(date1,date2)) from A date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ DB2ÖÐÈçºÎʹÓÃÐ ......