Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Execute immediate with parameters

733226Nov 10 2009 — edited Nov 10 2009
Hi everybody, i need to do sometingh like this

declare

pdate1 date:=sysdate;
string1 varchar2(1000);

begin

--Sometingh happen here that make lose time...but i need to write in the column the previosly saved sysdate*

string1:='create table a as select b.name, b.surname, b.company, pdate1 as extraction_date from b'

execute immediate string1;

end;

this naturally doesn't work...how i can pass a parameter in the create table made with execute immediate?
Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 8 2009
Added on Nov 10 2009
8 comments
1,668 views