Kbase P68000: Is possible to create a SQL-92 view in the Database with a Where clause that can use todays date?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Unverified
GOAL:
Is possible to create a SQL-92 view in the Database with a Where clause that can use todays date?
FIX:
Yes, it is possible. Simply use code similar to the following:
DROP VIEW SomeUser.SomeView;
COMMIT;
CREATE VIEW SomeUser.SomeView
AS SELECT * FROM PUB.Order WHERE PUB.Order.OrderDate = SYSDATE();
COMMIT;