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
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£© tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname ½á¹û£º µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£ ³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......