Oracle 为列名的一部分使用定义变量 (& 号)

SQL> create table t ( XXX_ID int , YYY_ID int );

Table created.

SQL>
SQL> insert into t values (10,20);

1 row created.

SQL>
SQL> define product = XXX
SQL>
SQL> select &&product._ID from t;
old   1: select &&product._ID from t
new   1: select XXX_ID from t

    XXX_ID
----------
        10

1 row selected.

SQL>
SQL> define product = YYY
SQL>
SQL> select &&product._ID from t;
old   1: select &&product._ID from t
new   1: select YYY_ID from t

    YYY_ID
----------
        20

1 row selected.
复制