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

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

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 / »ù´¡Àà

×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
ÏëÒªµÄ½á¹ûÊÇ:
1,Na ......

OracleÈÏÖ¤ - Oracle / ÈÏÖ¤Ó뿼ÊÔ

ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ 
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ