Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Parameterization of sql scripts

Re: Parameterization of sql scripts

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Thu, 29 Jan 2004 18:30:54 +0800
Message-ID: <4018E0DE.731E@yahoo.co.uk>


AMIT wrote:
>
> Hi ,
>
> I like to ask about the &#8220;Parameterization of Oracle
> SQL-Scripts&#8221;. 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US