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
コメント
コメントを投稿