#255 CREATE OR REPLACE feature

open
nobody
engine (144)
5
2010-11-15
2010-11-15
SadKo
No

Need to have CREATE OR REPLACE instruction support for:
- Functions
- Procedures
- Triggers
- Views
- ???

Now the latest checkout from trunk says only that token 'OR' is unexpected.

Discussion

  • Fred Toussi
    Fred Toussi
    2010-11-19

    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.

     
  • SadKo
    SadKo
    2010-11-19

    Sure. But it's not a bug, it's a feature request. It would be good if such syntax could be supported.

     
  • Fred Toussi
    Fred Toussi
    2012-02-27

    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.