PL/SQL 学习笔记3

 SQL> var a number SQL> begin 2 :a :=1000; 3 end; 4 / PL/SQL procedure successfully completed. SQL> edit Wrote file afiedt.buf 1 begin 2 dbms_output.put_line(:a); 3* end; SQL> / 通过这个代码可以看出通过pl/sql初始化赋值的Bind variable可以被其他Pl/sql程序调用

 

%type 类型应用的话 如果前面用的是database column的话 那么不可以加not null,前面引用的是声明的变量可以应用not null

 

A NOT NULLdatabase column constraint does not apply to variables that are declared using %TYPE.  
Therefore, if you declare a variable using the %TYPEattribute that uses a database column defined as NOT  
NULL, you can assign the NULLvalue to the variable.  

eg:

 

 

绑定变量

A bind variable is a variable that you declare in a host environment.

 Bind variables can be used to pass run-time values, either