Search Results

USERNAME||' '||EMAIL||' '||FULL_NAME||' '||LAST_LOGIN||'
--------------------------------------------------------------------------------
abcdef abcdef@yahoo.com abcdef abc 29-SEP-11 03.2...

Hi Guys..

Need your help to format the output of my shell script.

I am using spool command to take out put in csv file.

below is my code. (for example)


col USERNAME for a15
col EMAIL...

Hi Guys,

Need you help in one point!

I am working on one shell script which takes following steps :

1. Taking one query result from oracle database
2. Exporting that result to Xls file
3....

I have given input output example below!

---------- Post updated at 06:44 AM ---------- Previous update was at 06:33 AM ----------

Could you pls temme way to create SQL file? Becoz.. whatever i...

Sensitive approach coz.. i tried all the possible ways to work on with spool but script iz nt getting executed..

below is the script that i tried earlier



#!/bin/bash...

#!/bin/bash
ORACLE_HOME=/app/oracle/product/10.0.0.0
export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH
export PATH
x=`sqlplus -s abc_USER/password@abcd.pfizer.com <<EOFSQL
select USERNAME, EMAIL,...

Hi All,

I am in middle of one script. I want output in the form of xls file.

There are 4 fields - user name, email Id, full name, date of birth. I want these details to get in seperate...