Re: variables in sql-statements

"Simon Schrammel" <ssh_at_tetrag.ch> wrote in message news:U9FV6.100$io1.504251_at_news...
> 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:
> PL/SQL: SQL Statement ignored
>
>
> Thank you for your help.
>
> Simon
>
Simon,

Use the Oracle package dbms_sql to use dynamic sql to access the database. Also for simple "dynamic" sql's example
truncate table tablename (where tablename is known dynamically) check out execute immediate sql_statement;------- (In Oracle 8i)

HTH
PT Received on Wed Jun 13 2001 - 16:05:32 CEST