how do I concatinate a substitution variable to form part of the string?

Oracle sqlplus ユーザー定義変数の使い方

sqlplus USER/PASSWORD@接続文字列 AS SYSDBA

sqlplus SYS/$SYS_PASSWORD@ORCL AS SYSDBA

sql> define COLUMN_NAME=colA

sql> select &COLUMN_NAME._001 from table1;

select colA_001 from table1

コメント

人気の投稿