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.
Printable View
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 = :p_value;
Sorry I am not putting that Icon .I didn't know how it is getting there . You have use ':' before P_val
'select * from tab where col=:p_value;'