pl/sql - Oracle / »ù´¡ºÍ¹ÜÀí
SQL> set serverout on SQL> dbms_output.put_line('1234') SP2-0734: δ֪µÄÃüÁͷ "dbms_outpu..." - ºöÂÔÁËÊ£ÓàµÄÐС£ SQL> dbms_output.put_line('1234'); SP2-0734: δ֪µÄÃüÁͷ "dbms_outpu..." - ºöÂÔÁËÊ£ÓàµÄÐС£ /??ΪʲôÎÒµÄÕâ¸öÃüÁî¾Í¹ý²»ÁË£¬¿´½Ì³ÌÉ϶¼ÊÇÕâôдµÄ£¬ »·¾³£º oracle 10g winxp
ÊDz»ÊÇÓ¦¸Ã¼Ó¸ö exec dbms_output.put_line('1234');²ÅÐа¡ µ¥¶ÀÖ´ÐУ¬¿ÉÒÔ£¬µ«ÊǷŵ½begin endÀï¾Í²»ÐÐÁË¡£ÈçÏ£º SQL> begin 2 exec dbms_output.put_line('ass'); 3 end; 4 / exec dbms_output.put_line('ass'); * µÚ 2 ÐгöÏÖ´íÎó: ORA-06550: µÚ 2 ÐÐ, µÚ 6 ÁÐ: PLS-00103: ³öÏÖ·ûºÅ "DBMS_OUTPUT"ÔÚÐèÒªÏÂÁÐ֮һʱ£º := . ( @ % ; ·ûºÅ ":=" ±»Ì滻Ϊ "DBMS_OUTPUT" ºó¼ÌÐø¡£ SQL> exec dbms_output.put_line('as'); as PL/SQL ¹ý³ÌÒѳɹ¦Íê³É¡£ SQL> ÒýÓà Ӧ¸ÃÓÃÓï¾ä¿é,ÈçÏ [code=SQL] SQL> set serverout on SQL> begin 2 dbms_output.put_line('1234') ; 3 end; 4 / 1234 PL/SQL ¹ý³ÌÒѳɹ¦Íê³É¡£[code] -- SQL> declare 2 v_ename varchar2(20); 3 begin 4 select ename into v
Ïà¹ØÎÊ´ð£º
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡ Ëæ±ã¸ãÒ»D°æ°É£¬ ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓà 2000,2005¶¼ÕâÑù http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê create or replace package PK_test as type cur_test is ref cursor; end PK_test; --½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩! create or replace ......
Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡ °²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖᣠµã»÷½øÈ룺Database Configuration Assistant 1. ´´½¨Êý¾Ý¿â£»
......