Hi All, I need to export contents of a table whch has one data type as CLOB. I am able to store it ina file using query, "select PROFILE_ID ||'#COL#'|| ADM_TYPE ||'#COL#'|| ACC_TYPE ||'#COL#'|| STATUS ||'#COL#'|| ACC1 ||'#COL#'|| ACC2 ||'#COL#'|| OPAQUE_STRING ||'#ROW#' from PROFILE".
however, the data which is returned is restricted to 82 characters each line. Any means to increase the size ? Regards, Simran
