Re: DBMS_SQL Dynamically creating views.
From: Yves Roy, IPA <yvesroy_at_cips.ca>
Date: 1998/09/01
Message-ID: <01bdd54e$ed7e1370$437acdcd_at_sctrnt1>#1/1
Date: 1998/09/01
Message-ID: <01bdd54e$ed7e1370$437acdcd_at_sctrnt1>#1/1
[Quoted] Hi Rodger,
[Quoted] [Quoted] Here's a way to have a dynamic view:
Use package variable in your where clause of the view. Then before selecting the view, initialize it.
ex. create view daily_sales as select * from your_sales_tables where sales_date = package_x.global_variable_date; Before selecting the view... in a pl/sql or a C program initialyze it like package_x.global_variable_date = '1998-08-28'
then select * from daily_sales ;
will give you the sales of the '1998-08-28'.
Hope this help.
Yves.
yroy_at_sctr.net
Received on Tue Sep 01 1998 - 00:00:00 CEST