Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

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

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ