Re: Triggers now work (it's official)
Ok, i did not see it mentioned, but i scanned the list of change only briefly, so i probably missed it.
I think that views, procedures and triggers are all major leaps ahead. The information schema too is a major improvement but it still needs some crucial elements in my opinion: PARAMETERS for ROUTINES (already recognized as necessary), REFERENTIAL_CONSTRAINTS (also recognized) would be nice, but when you really need that data, you can work around it using just TABLE_CONSTRAINTS.
What i think really is indispensible, is some equivalent of oracle's DBA_DEPEDENCIES view. ISO 9075 also provides such functionality, dispersed over (sorry no ref at my fingers now, mybe wrong names) VIEW_TABLE_USAGE and PROCEDURE_COLUMNS and maybe some others.
Well i could go on and on about it, and I will, but not here ;-).
CU!
Subject
Views
Written By
Posted
3631
July 28, 2005 04:14PM
2357
July 28, 2005 06:31PM
2481
July 29, 2005 03:35AM
Re: Triggers now work (it's official)
2356
July 29, 2005 05:38AM
2627
July 31, 2005 05:33PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.