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 -> Some questions Oracle (SQL)

Some questions Oracle (SQL)

From: <rhillebrand_at_starren.nl>
Date: 2000/03/22
Message-ID: <8bb5cq$ghn$1@nnrp1.deja.com>#1/1

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

Original text of this message

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