Search Results

Thanks knight_eon...

I need this csv file to be saved in the local PC.. As soon as I run the script file, the csv file shud get saved in the path specified.. Wats the procedure to specify the...

Thanks Scrutinizer & ahamed101,

Both (i)printf "%s\n" "$result_set" > results.csv
(ii) echo "$result_set" > results.csv

is working fine..

Now the output is formatted in the csv file...
...

Here is my coding:

export ORACLE_SID=ABCD
result=`sqlplus -s /NOLOG << EOF
connect username/pass
SELECT count(*) from A;
`
The same way, am collectng all the 5 query's results in 5...

Hi,

I am facing issues while exporting the results retrieved from the Database to an excel file.

I have 5 count query in order to count the records in 5 different tables.

I had connected...