Set shell variables from SQLPLUS query results Example script for getting sqlplus query results into environment variables using awk and ksh (I only use bash or ksh so don't even know how to set a variable in csh).
Replace USER with the actual username, PASS with user's password and DB with the tnsname for database you're connecting to. ...
Display long text fields in query results set long [size]
- or -
set longchunksize [size]
Enables to select long text fields (chunks are lines separated by end of line, so it will display them as one line)