Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......

OracleÁÙʱ±íʹÓÃÎÊÌâ - Oracle / ¿ª·¢

ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ