Search Results

i use sqlplus,


${ORACLE_HOME}/bin/sqlplus -s ${DB_LOGIN}/${DB_PASSWD} <<EOF
SET FEEDBACK OFF
SET HEADING ON
spool /tmp/file1.TMP
SELECT column1,column2,column3 FROM table1;
quit


o/p of...

Actually i use select query in shell script and mailx command to send email. o/p which i get display as below,

STORE DI ITE ITEM CTRL CTRL_DT ...

Hi,
I am selecting few columns from a table using select query in UNIX shell script ans sending the results as E-mail. But the column headings are not displayed fully. Instead it displays only a...

Hi,
I need to display specific columns using select statement and spooled to a file and sending it as e-mail. But i am not seeing column header in my output even i use SET HEADING ON.//PREDEFINED...