HI Team,
I am working with ODI 12c and using LKM SQL to Oracle (Recon)
I wanted to modify the LKM - Create C$(Work) table step so that all column names are created in DOUBLE QUOTES
CURRENT BEHAVIOR
During the Create work table step ,Odi generates SQL like this
CREATE TABLE C$_MY_TABLE
(COL1 varchar2(100),
COL2 Number,
COL3 date
);
Expected Behaviour
I want column names to be created with double quotes, like
CREATE TABLE C$MY_TABLE
(
“COL1” varchar2(100),
“COL2” number,
“COL3” date
)
i tried warapping [CX_COL_NAME] with double quotes ,but ODI still generates unquotes column names
Thanks in advance 🙏
ODI Vesion 12c