creating a view at run-time by using pl/sql procedure [message #284152] |
Thu, 29 November 2007 01:03 |
M.Shakeel Azeem
Messages: 226 Registered: September 2006
|
Senior Member |
|
|
Dear All,
I want to create a view at run-time like
create procedure my_proc(p_date varchar2)
is
create or replace view emp_vw
as select ename,depno
from emp,dept
where hire_date=p_date;
p_date is run-time variable which should be passed from a procedure
and now the view will be refreshed according to passed date
Regards,
M.Shakeel
|
|
|
|
|
|
|
|
|
|
|