try again.
write a simple sql script to get what you want, I added "-- notes" at the end of the line, remove them:
Code:
set colsep ' ' -- that is: a tic a tab a tic; you cannot see a tab; this makes csv format
set head off -- don't print the header crud
set pages 0
set lines 999 -- do no wrap on col 80, this can be set larger
set trimspool on
set feedback off
spool myoutputfile.txt
select fld1, fld2, fld3 from mytable -- obviously this is made up
where fld3='something';
spool off
save that script as: one.sql then clean up the dashes
You can run the script from sqlplus:
Code:
sqlplus myusername/mypassword@mydbname
@one
exit
If you need to automate running your script , create a shell script, one.sh
1. create one.sh:
Code:
#!/bin/ksh # or #!/bin/bash
sqlplus myusername/mypassword@mydbname <<EOF
@one
exit
EOF
NOTE: the last EOF has to be in column #1.
Search the forums for a 'here document', EOF could be PDQBACH or anything you like.
2.
Code:
chmod +x one.sh
3.
Code:
./one.sh
Last edited by jim mcnamara; 06-01-2010 at 07:55 AM..
sqlplus -s username/passwd@dbname <<EOF
set colsep ' '
set feedback off
set lines 9999
spool results.csv
set trimspool on
set pages 999
select * from importcell;
exit
EOF
This makes a tab-delimited csv file.
set colsep ',' makes a comma-delimited csv file.
---------- Post updated at 07:44 AM ---------- Previous update was at 07:28 AM ----------
The csv file does not get created. I added a path for it
Code:
#!/bin/bash
sqlplus -s datasafe/datasafe@DS61MTN <<EOF
set colsep ' '
set feedback off
set lines 9999
spool /var/local/dsx/import/results.csv
set trimspool on
set pages 999
select * from AFFECTLEVEL;
exit
EOF
HI
I have a dsv file that looks like:
<<BOF>>
record_number|id_number|first name|last name|msisdn|network|points|card number|gender
312|9101011234011|Test Junior|Smith|071 123 4321|MTN|73|1241551413214444|M
313|9012023213011|Bob|Smith|27743334321|Vodacom|3|1231233232323244|M... (4 Replies)
I am trying to compare the data in lines 3 & 5 to see if they match up to the '-S570' (see first code set, all proprietary information has been removed from code set)
spawn telnet
Trying ...
Connected to CA-LOS1234-ASE-S570.cl .
Escape character is '^]'.
CA-LOS1234-ASE-S570
Username: ... (1 Reply)
Hi,
I have one file, say file 1, that has data like below where 19900107 is the date,
19900107 12 144 129 0.7380047
19900108 12 168 129 0.3149017
19900109 12 192 129 3.2766666E-02
... (3 Replies)
Hi All,
I have a huge matrix file consisting some some millions rows and 6000 columns. The contents are just floating point numbers in the matrix. I want to extract each column (i.e. 6000 of them) and store each column in a separate file.
For example, 1.dat will consist of elements from column... (4 Replies)
Hi
I need to write a bash script to take the data stored in 3 oracle tables .. and filter them and store the results in a csv file.
It is an Oracle database
Thank you (1 Reply)
Hi ,
I have input file and i want to extract below strings
<msisdn xmlns="">0492001956</ msisdn> => numaber inside brackets
<resCode>3000</resCode> => 3000 needs to be extracted
<resMessage>Request time
getBalances_PSM.c(37): d out</resMessage></ns2:getBalancesResponse> => the word... (14 Replies)
Hi
I need to calculate the number of occurrences of a item in a number of files using Perl.
The item appears continually throughout the files but in each case I only want to calculate it in certain blocks of the file.
Example - Calculalte the number of occurrences of a 'pass' in a block of... (0 Replies)
I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated.
Input:
test_data_1
1 2 90%
4 3 91%
5 4 90%
6 5 90%
9 6 90%
test_data_2
3 5 92%
5 4 92%
7 3 93%
9 2 92%
1 1 92%
...
Output:... (7 Replies)