how to execute a string in PL/SQL [message #39716] |
Sun, 04 August 2002 20:50 |
llz
Messages: 14 Registered: June 2002
|
Junior Member |
|
|
Hi, who can tell me how to execute a string in PL/SQL,
eg
create or replace ttt
is
s :varchar(100);
begin
s :='create table test (f varchar2(10) ';
//////////
how execute s???????????????
end;
|
|
|
Re: how to execute a string in PL/SQL [message #39758 is a reply to message #39716] |
Wed, 07 August 2002 11:18 |
Peter
Messages: 62 Registered: August 2000
|
Member |
|
|
initialize your string variable:
myStr varchar2(500);
and build it as necessary (based upon user input I assume);
once you've figured out all your permutations, simply execute as:
OPEN p_cursor FOR
myStr;
|
|
|