-
Parameter
Hi,
how to pass a parameter to Dynamic SQL script.
ex: test.sql contains....
Declare
P_value varchar2(10);
P_values := '&v_value';
Begin
select * from tab where col = p_value;
end;
it's possible passing the value like above.
thanks in advance.
-
It should be
select * from tab where col = _value;
Raghu
-
Sorry I am not putting that Icon .I didn't know how it is getting there . You have use ':' before P_val
Raghu
-
'select * from tab where col=_value;'
Raghu
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|