oracle Ö´ÐÐ˳Ðò - Oracle / »ù´¡ºÍ¹ÜÀí
SQL code: declare v_deptno number(2); v_dname varchar2(14); begin dbms_output.put_line('ÇëÊäÈ벿ÃźźͲ¿ÃÅÃû:'); v_deptno:=&deptno; v_dname:='&dname'; insert into dept01(deptno,dname) values(v_deptno,v_dname); end; / Ö´Ðнá¹û£º Enter value for deptno: 67 Enter value for dname: gg ÇëÊäÈ벿ÃźźͲ¿ÃÅÃû: Ϊʲô¡°ÇëÊäÈ벿ÃźźͲ¿ÃÅÃû¡±Õâ¾ä»°×ÜÊÇÔÚºóÃæ°¡£¡£¡£¡£¡£¡
oracle ÊÇÏȱàÒ룬ÔÙÖ´ÐУ¬±àÒëʱ£¬Èç¹ûÓÐÒªÇóÊäÈëµÄ£¬¾Í»áÌáʾÄãÊäÈ룬ÕâÑù£¬²ÅÄÜÖ´ÐУ¬ËùÒÔ¡°ÇëÊäÈ벿ÃźźͲ¿ÃÅÃû¡±Õâ¾ä»°£¬×ÜÔÚºóÃæ ËüÊÇÏÈ»ñÈ¡ËùÓеÄ&µÄ±äÁ¿µÄÖµ£¬È»ºóÔÙ´¦ÀíÄãµÄ³ÌÐò¿é¡£ ¾ÍºÃÏñÊÇÏȱàÒ룬ÔÙÔËÐУ¬¶ø²»ÊDZ߽âÊͱßÖ´ÐÐ ¶÷ ÔÚÖ´ÐеÄʱºòÏÈÊÇ¿´ÀïÃæÊÇ·ñÓÐλÖñäÁ¿ ÓÐλÖñäÁ¿µÄ»° ¾ÍÏȸøÎ»ÖñäÁ¿¸³Öµ È»ºó²Å½øÐÐÆäËûµÄ²Ù×÷¡£ Enter value for..ÕâÁ½¾ä²»ËãÊä³ö£¬ ÊÇÏȸ³ÖµÈ»ºó²ÅÓÐÖ´ÐУ¬ËùÒÔ ÇëÊäÈë ÄǾä»áÔÚ×îºó Èç¹ûÓÃpl/sql developerÖ´ÐÐÕâ¶Î³ÌÐò¾ÍºÜÈÝÒ׿´³öÀ´ Õâ¸öÔõô²ÅÄÜÏÈÊä³ö×Ö·û£¬ÔÚÊä³öÒª²åÈëµÄÖµ£¡£¿£¿ÒýÓà Enter value for..ÕâÁ½¾ä²»ËãÊä³ö£¬ ÊÇÏȸ³ÖµÈ»ºó²ÅÓÐÖ´ÐУ¬ËùÒÔ ÇëÊäÈë ÄǾä»áÔÚ×îºó Èç¹ûÓÃpl/sql developerÖ´ÐÐÕâ¶Î³ÌÐò¾ÍºÜÈÝÒ׿´³öÀ´ ÓÐûÓÐÌá¸ßÊä³öÓï¾äÓÅÏȼ¶µÄ·½·¨°¡£¡£¡£¡ °¡.....ÄѵÀÖ»ÄÜÕâÑùÀ²¡£¡£¡£¡£¡£ SQL code Code highlighting produced by Actipro CodeHighli
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿ 1 ¿ÉÒÔɾ³ý 2 ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
eclipse 3.3Æô¶¯web¹¤³Ì£¬ÒªÁ¬½Óoracle9iÊý¾Ý¿â±¨ ÑÏÖØ: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error: ORA-12518, TNS:listener could not hand off cli ......