Oracle-Batch Processing (SQL statement block)

Format:

View code

  Declare  MSG  Varchar2 ( 32  ); P_name  Varchar2 ( 32  ); Outresult  Varchar2 ( 64  );  Begin  P_name: =   '  Xxxx  '  ;  Select Loginname Into MSG From Users Where Loginname = P_name And   1  =  2  ; Dbms_output.put_line (MSG); Exception When Others Then  Outresult:  =   '  Failure ---  '   | Sqlerrm |   '     '   |  P_name; dbms_output.put_line (outresult );  End ;

1. variables can only be declared or declared and assigned values before begin after declare.

2. The accuracy of a variable of the character type must be declared.