Topic
  • 2 replies
  • Latest Post - ‏2012-10-17T18:56:31Z by loicjulien
TSGP_Sameer_Rana
TSGP_Sameer_Rana
4 Posts

Pinned topic Data Studio triggers generate ddl delimiter

‏2011-03-14T15:30:33Z |
Is there some setting in Data Studio that will enable me to generate DDLs for triggers with @ delimiter?
At present it generates with ; by default. I want to change it to @

Urgent help needed.

Regards,
Sameer
Updated on 2012-10-17T18:56:31Z at 2012-10-17T18:56:31Z by loicjulien
  • JamesBrooks
    JamesBrooks
    5 Posts

    Re: Data Studio triggers generate ddl delimiter

    ‏2012-10-11T12:05:37Z  
    In some cases you seem to need 2 different delimiters. One ";" for the end of statements, and one "@" for the end of "create or replace" routines and for "set" statements. Like an execute for the compilers and an execute for the runtime... Can this be done?
  • loicjulien
    loicjulien
    96 Posts

    Re: Data Studio triggers generate ddl delimiter

    ‏2012-10-17T18:56:31Z  
    In some cases you seem to need 2 different delimiters. One ";" for the end of statements, and one "@" for the end of "create or replace" routines and for "set" statements. Like an execute for the compilers and an execute for the runtime... Can this be done?
    Hi,

    I would need to understand more about the use-case you are leveraging in Data Studio: Routine Editor, Generate DDL, Change Management?...

    I am attaching a screenshot of Generate DDL on a trigger, though, this may not be applicable to what you are currently doing.

    Thanks,
    ~Loic