TO_CLOB « Data Type « Oracle PL / SQL






1.TO_CLOB(x): Converts x to a character large object (CLOB). A CLOB is used to store large amounts of character data
2.Use to_clob with case when statement