Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> variables in sql-statements
Hello
I am creating a script which uses variables. I store the table-names in these variables and I need to uses these variables in sql-statements. How does this work in orcacle?
example:
declare
tab_name varchar2(20);
col_name varchar2(20);
begin
tab_name:='labor';
col_name:='name';
select * from tab_name where col_name='ROM34';
end;
ERRORS:
ORA-06550: line 7, column 15: PLS-00356: 'TAB_NAME' must name a table to which the user has access ORA-06550: line 7, column 1:
Thank you for your help.
Simon Received on Wed Jun 13 2001 - 03:08:41 CDT