Home » SQL & PL/SQL » SQL & PL/SQL » Re: how to execute a string in PL/SQL
Re: how to execute a string in PL/SQL [message #39722] Mon, 05 August 2002 02:35
venkatesh
Messages: 72
Registered: August 2000
Member
u can use

execute immediate 'dml/ddl statement'

example:

create procedure createtable (tablename varchar2)
as
sqlstring varchar2(100);
begin
sqlstring := 'create table ' || tablename ||'(name varchar2(10), age number)'

execute immediate sqlstring;
end;

this is a simple example to create a table dynamically by passing the table name thru the procedure...

Report message to a moderator

Previous Topic: database
Next Topic: SQL*Plus returns wrong and different results for same query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 07:00:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.