PROSAGA码农传奇-Oracle-SQL变量创建

SQL变量创建

作者: 荧惑
发布时间: 2024-12-26 01:17:25 (26天前)
转自：

<div class =“post-text”itemprop =“text”>
  <P>
    看起来像SQL * Plus。
  </p>
   <pre>
    <code>
      SQL> create table var (variable_value number, loc varchar2(5), atom varchar2(5), variable_name varchar2(10));

Table created.

SQL> set ver off
SQL>
SQL> column set_schema_pow new_value schema_pow
SQL>
SQL> select variable_value set_schema_pow
  2  from &schema..var
  3  where
  4  loc = 'PROD'
  5  and atom = '&vta'
  6  and variable_name = 'schema_pow';
Enter value for schema: scott
Enter value for vta: a

no rows selected

SQL>

</code>
  </pre>
  <P>
    甚至这个（将一些数据存储到表中）：
  </p>
   <pre>
    <code>
      SQL> insert into var values (100, 'PROD', 'a', 'schema_pow');

1 row created.

SQL> column set_schema_pow new_value schema_pow
SQL>
SQL> select variable_value set_schema_pow
  2  from &schema..var
  3  where
  4  loc = 'PROD'
  5  and atom = '&vta'
  6  and variable_name = 'schema_pow';
Enter value for schema: scott
Enter value for vta: a

SET_SCHEMA_POW
--------------
           100

SQL>

</code>
  </pre>
</DIV>