Re: Some questions Oracle (SQL)

Oops,
I was forgotten that oracle runs on many platforms, The platform where oracle on is runnning : NT 4.0 Server. Oracle Version : 8.x.

I hope you an give me some pointers.
R. Hillebrand

In article <953753525.3018.0.pluto.d4ee154e_at_news.demon.nl>, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> You'll need to use dbms_sql and/or other dynamic sql mechanisms for
 this.
> As you don't specify your version I can't provide any specific
 pointers.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> <rhillebrand_at_starren.nl> wrote in message
> news:8bb5cq$ghn$1_at_nnrp1.deja.com...
> > Hello,
> > Some questions about oracle :
> > How to create a stored procedure to create a Table with a variable.
> > Example :
> > CREATE PROCEDURE UPCREATETABLE(varTable VARCHAR2) AS
> > BEGIN
> > CREATE TABLE varTable(...);
> > END;
> > How to create a stored procedure insert into a Table with a
 variable :
> > Example :
> > CREATE PROCEDURE UPINSERTDATA(varTable VARCHAR2, varValue as
 NUMBER) AS
> > BEGIN
> > INSERT INTO varTable VALUES (varValue)
> > END;
> > Is this possible ?
> > R. Hillebrand
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 22 2000 - 00:00:00 CST