'Define/Variable' Tag

• sqlplus中define定义的常量和variable定义的变量的区别

  10月 3, 2009

  define相当于定义一个字符常量，通过define定义之后，在通过&或者&&引用的时候不需要输入了。oracle在执行的时候自动用值进行了替换； variable定义的是绑定变量。 (1) define SQL> alter session set nls_language = american; Session altered. SQL> define DEFINE _DATE = "03-OCT-09" (CHAR) DEFINE _CONNECT_IDENTIFIER = "myoracle" (CHAR) DEFINE _USER = "SCOTT" (CHAR) DEFINE _PRIVILEGE = "" (CHAR) DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR) DEFINE _EDITOR = "Notepad" (CHAR) DEFINE _O_VERSION = "Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 [...]

  posted in Oracle 知识杂记 by | 编辑