Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Some questions Oracle (SQL)
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.
Received on Wed Mar 22 2000 - 00:00:00 CST