Need to have CREATE OR REPLACE instruction support for:
Now the latest checkout from trunk says only that token 'OR' is unexpected.
This is syntax is not supported.
The functionality is supported by:
CREATE FUNCTION / PROCEDURE ...
ALTER SPECIFIC ROUTINE ..
CREATE VIEW ... AS
ALTER VIEW ... AS
CREATE TRIGGER ...
-- but currently no ALTER TRIGGER. You can create a new trigger then drop the old one. If you have multiple trigger on the same table, you can specify BEFORE old_trigger_name, to put it in the right place / order.
Sure. But it's not a bug, it's a feature request. It would be good if such syntax could be supported.
In ORA syntax mode, this is now supported when the object does not already exist. This can help with some scripts and existing apps. We may extend it in the future.