Sponsored Content
Top Forums Shell Programming and Scripting Load data to flat file from table. Post 302296517 by jim mcnamara on Wednesday 11th of March 2009 08:47:12 AM
Old 03-11-2009
one way
Code:
echo "
set pages 0
set linesize 1000
set feedback off
spool xyz.lis
select * from abc;
spool off 
exit
" | sqlplus -s username/password@oracledb

You have to adjust the set linesize value to what matches the width of a table row.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Inserting records from flat file to db table

I have 20000 numbers present in a file in each line like 25663, 65465, 74579, 56446, .. .. I have created a table in db with single number column in it. create table testhari (no number(9)); I want to insert all these numbers into that table. how can i do it? can anybody please... (4 Replies)
Discussion started by: Hara
4 Replies

2. Shell Programming and Scripting

shell script to read data from text file and to load it into a table in TOAD

Hi....can you guys help me out in this script?? Below is a portion text file and it contains these: GEF001 000093625 MKL002510 000001 000000 000000 000000 000000 000000 000001 GEF001 000093625 MKL003604 000001 000000 000000 000000 000000 000000 000001 GEF001 000093625 MKL005675 000001... (1 Reply)
Discussion started by: pallavishetty
1 Replies

3. Shell Programming and Scripting

To load data from variable to oracle table

Hi all, How to load variable value into Oracle table? I have created a file validation shell script. After the validation completes, i need to update a Oracle table with the variable value... Can someone help me how to do it? I have searched, but not able to get answer. i have 4... (1 Reply)
Discussion started by: Amit.Sagpariya
1 Replies

4. Shell Programming and Scripting

To load data from variable to oracle table ....???

Hi all, How to load variable value into Oracle table? I have created a file validation shell script. After the validation completes, i need to update a Oracle table with the variable value... Can someone help me how to do it? I have searched, but not able to get answer. i have 4 variables... (2 Replies)
Discussion started by: Amit.Sagpariya
2 Replies

5. Shell Programming and Scripting

inserting data into a table from a flat file

Hi, I want to insert data into a table from a flat file, the file is having around 25 columns and some 10,000 records. The columns values are seperated by a space. Thanks (1 Reply)
Discussion started by: ss_ss
1 Replies

6. Shell Programming and Scripting

load a data from text file into a oracle table

Hi all, I have a data like, 0,R001,2,D this wants to be loaded into a oracle database table. Pl let me know how this has to be done. Thanks in advance (2 Replies)
Discussion started by: raji35
2 Replies

7. Shell Programming and Scripting

How do I load records from table to a flat file!

Hi All, I need to load records from oracle table XYZ to a flat file say ABC.dat. could any one tell me how do i do this in UNXI, Regards Ann (1 Reply)
Discussion started by: Haque123
1 Replies

8. Shell Programming and Scripting

Load data from a flat file to oracle.

I have a flat file with records like Header 123 James Williams Finance2000 124 Pete Pete HR 1500 125 PatrickHeather Engg 3000 Footer The structure is: Eno:4 characters Name:8 characters Surname : 9 characters Dept:7 characters Sal:4characters These are sample... (1 Reply)
Discussion started by: Shivdatta
1 Replies

9. Homework & Coursework Questions

Write a shell script for SQL loader to load data into a staging table

Hi, I'm new to Linux. I'm working on a database, and need to load data in a database table (which I already created) using shell script. The table has two columns - Acct_number (not nullable) and date (timestamp). I'm not able to write a shell script for that. Can any one help me? ... (3 Replies)
Discussion started by: saisudeep
3 Replies

10. Shell Programming and Scripting

URGENT HELP!!! Extracting db table into flat file

Hi All, I am writing a shell script to extract oracle table into a pipe dilemited flat file. Below is my code and I have attached two files that I have abled to generate so far. 1. Table.txt ==> database extract file 2. flat.txt ==> pipe delimited after some manipulation of the original db... (0 Replies)
Discussion started by: express14
0 Replies
PYFAI-SAXS(1)							   User Commands						     PYFAI-SAXS(1)

NAME
pyFAI-saxs - azimuthal integration for SAXS users. DESCRIPTION
saxs_integrate is the Saxs script of pyFAI that allows data reduction for Small Angle Scattering. Parameters: -p=param.poni PyFAI parameter file -w=9.31e-11 wavelength (in meter) -d=-2 dummy value for dead pixels -dd=-1.1 delta dummy -mask=mask mask image -dark=darkImage dark current image -flat=flatImage name of the file containing the flat field -background=filename name of the file containing the background -h print help and exit Usage: python saxs_integrate.py -p=param.poni -w=0.154e-9 file.edf file2.edf file3.edf saxs_integrate is the Saxs script of pyFAI that allows data reduction for Small Angle Scattering. Parameters: -p=param.poni PyFAI parameter file -w=9.31e-11 wavelength (in meter) -d=-2 dummy value for dead pixels -dd=-1.1 delta dummy -mask=mask mask image -dark=darkImage dark current image -flat=flatImage name of the file containing the flat field -background=filename name of the file containing the background -h print help and exit Usage: python saxs_integrate.py -p=param.poni -w=0.154e-9 file.edf file2.edf file3.edf ESRF
January 2012 PYFAI-SAXS(1)
All times are GMT -4. The time now is 05:02 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy