I have a humungous select statement stored in A.A_VAL_T. When I try to select the CLOB, I always get only 80 lines. I need to retrieve the whole select statemnt in SQL*Plus. Is that possible? I ultimately want to pass the select from a bash shell to sql*plus. I'm inexperienced with CLOB. I've only worked with LONG data types in the past.
SQL> desc a
Name Null? Type
----------------------------------------- -------- -------------
A_APLN_T NOT NULL VARCHAR2(126)
A_KY_ID NOT NULL VARCHAR2(255)
A_VAL_T CLOB
A_REC_MTN_TS NOT NULL DATE
A_REC_MTN_ID NOT NULL VARCHAR2(8)
SQL> SELECT a_val_t AS clob_col
2 -- INTO x
3 FROM a
4 WHERE a_apln_t = 'TimeSlice' AND a_KY_ID = 'EDW';
CLOB_COL
--------------------------------------------------------------------------------
SELECT TO_CLOB(