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.
This topic has been locked.
2 replies Latest Post - 2012-10-17T18:56:31Z by loicjulien
Pinned topic Data Studio triggers generate ddl delimiter
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-10-17T18:56:31Z at 2012-10-17T18:56:31Z by loicjulien
JamesBrooks 110000R0PY5 PostsACCEPTED ANSWER
Re: Data Studio triggers generate ddl delimiter2012-10-11T12:05:37Z in response to TSGP_Sameer_RanaIn 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 2700007DEB96 PostsACCEPTED ANSWER
Re: Data Studio triggers generate ddl delimiter2012-10-17T18:56:31Z in response to JamesBrooksHi,
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.