Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Parameterization of sql scripts
AMIT wrote:
>
> Hi ,
>
> I like to ask about the “Parameterization of Oracle
> SQL-Scripts”. What does it means.
> Example from anyone will be appreciated.
>
> Thanks
>
> Faraz.
Typically within SQL Plus
select *
from user_tables
where table_name = '&my_table'
when you run it, you'll be asked to provide a value for my_table
hth
connor
-- ------------------------------- Connor McDonald http://www.oracledba.co.uk Co-Author: "Mastering Oracle PL/SQL - Practical Solutions"Received on Thu Jan 29 2004 - 04:30:54 CST
![]() |
![]() |