07-19-2005
I use sqlldr on a monthly basis as follows:
1. Create a control file - filename.ctl
2. Create an executable script - load_file (or whatever you want to call it)
3. Make sure the file you want to load does not change name or type, mine is just called start.csv and in comma seperated format. Write some error checking code for this.
##filename.ctl##
load data
infile start.csv
into table contact append
fields terminated by ',' optionally enclosed by '"'
(
URN,
TITLE,
FIRST_NAME,
OTHER_NAME,
LAST_NAME
)
##load_file##
sqlldr scott/tiger control=filename.ctl
##start.csv - first record example##
"0061031","Mr","B","A","Williams"
load_file will look at the control file and import the values from start.csv as required. If you sure the file is being placed in a directory it is worth while checking whether it exists before trying to import it into oracle else abort.
sqlldr does create a filename.log in the directory where you specified unless you specify a path as shown with the example by vgersh99.
Pretty basic but with a cron job should be able to get it working easily.
Hope this helps.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i would like to export a particular table in my oracle database installed in a hpux box. i would like to determine the filesize of the output before performing these action so i can assess if my harddisk can still handle it.
thanks as usuall :rolleyes: (1 Reply)
Discussion started by: inquirer
1 Replies
2. Shell Programming and Scripting
Since i'm new to scripting i'm findind it difficult to code a script. The script has to be an executable with 2 paramters passed to it.The Parameters are
1. The Control file name(.ctl file)
2. The Data file name(.csv file)
Does anybody have an idea about it? :confused: (3 Replies)
Discussion started by: Csmani
3 Replies
3. Shell Programming and Scripting
Hi
Does any one have any idea on uploading the data using Unix Shell script from text file to Oracle database.
Requirement:-
1. Need to connect to Oracle database from Unix Shell script.
2. Need to pick Text file from some location on Unix Box.
3. Need to upload the data from text file to... (6 Replies)
Discussion started by: chandrashekharj
6 Replies
4. Shell Programming and Scripting
Hi All,
I am trying to load a data from a files in a particular directory to a database..
cd $SCC
isql metdb >> ${LOGDATA}/LOAD.LOG < !
load from "${LDATA}/${FORM}.ld" insert into $LOADTABLE
!
But it's showing the error "syntax error at line 46 : `<<' unmatched"
Can u plz help me... (5 Replies)
Discussion started by: grajesh_955
5 Replies
5. Shell Programming and Scripting
Hi,
I want to write a shell script which will export data from oracle table .
I don't want to save that data . I want the queries .
Right now i am right clicking on the table and clicking on export as to my desktop .
Please let me know if any one have any idea . (2 Replies)
Discussion started by: honey26
2 Replies
6. Shell Programming and Scripting
Hello everyone,
I am new to shell scripting/ loading data into a database.
I want to load data into Oracle database using SQL loader. Can some one please explain why do we need unix shell script to load the data into the database? Also can someone please explain what has to be in that script?... (5 Replies)
Discussion started by: new_prog
5 Replies
7. Shell Programming and Scripting
Export data from database in Excel sheet with the help of Shell script and automated the report every day in the mornig. (1 Reply)
Discussion started by: neeraj617
1 Replies
8. Linux
Hi all,
Is there any out there have a brilliant idea on how to export html table data as .csv or write to txt file with separated comma and also get the filename of link from every table and put one line per rows each table.
Please see the attached html and PNG of what it looks like.
... (7 Replies)
Discussion started by: lxdorney
7 Replies
9. Shell Programming and Scripting
Greetings,
After a few hours of trial and error, I decide to ask for some help.
I am new to AWK and shell script, so please don't laugh :p
I made the below script, to gather data from some logs and have the output into a CSV file :
#!/bin/sh
#Script to collect Errors
... (9 Replies)
Discussion started by: Yagami_Sama
9 Replies
10. UNIX for Beginners Questions & Answers
Hello All,
just wanted to export multiple tables from oracle sql using unix shell script to csv file and the below code is exporting only the first table.
Can you please suggest why? or any better idea?
export FILE="/abc/autom/file/geo_JOB.csv"
Export= `sqlplus -s dev01/password@dEV3... (16 Replies)
Discussion started by: Hope
16 Replies
LEARN ABOUT DEBIAN
dchist
DCHIST(1) DICOM PS3 - DICOM image statistics DCHIST(1)
NAME
dchist - ACR/NEMA DICOM PS3 ... DICOM PS3 - DICOM image statistics
SYNOPSIS
dchist [ -h|histogram ] [ -csv ] [ -withhighbits|highbitsonly ] [ -v|verbose ] [ -filename ]
DESCRIPTION
dchist reads the named dicom or acr-nema input file and describes the statistics of the image pixel data. The primary intent is to deter-
mine the zero order entropy of the image.
The description and verbose output go to standard error.
The basic input switches are described in dcintro(1). Options specific to this program are:
-h|histogram
Display table of pixel value, frequency, probability, contribution to zero order entropy, and cumulative zero order entropy. May
generate a LOT of output !
-csv
Display only a comma separated value pair of pixel value and frequency, one line per value, e.g., for import into a statistical pro-
gram or spreadsheet
-withhighbits
Include as well the values that are above Bits Stored and within Bits Allocated, such as might be overlay bits (regardless of
whether or not there are any 60xx group elements).
-highbitsonly
Use instead the values that are above Bits Stored and within Bits Allocated, such as might be overlay bits, and treat all valid
pixel values below Bits Stored inclusive as zero (regardless of whether or not there are any 60xx group elements).
-v|verbose
Display byte offset from file start and message start, in hexadecimal, and dump contents while reading and once read.
-filename
Show the name of the file supplied in the arguments; a hyphen will be reported if no filename was supplied.
ENVIRONMENT
EXAMPLES
% dchist expmeta.dc3
9.02366 Zero order entropy (bits per pixel)
0x0 Smallest symbol value
0 Smallest symbol length (bits)
0x6e9 Largest symbol value
11 Largest symbol length (bits)
% dchist -h expmeta.dc3
[0x0] 392 p=0.00598145 e=0.0441747 cum=0.0441747
...
[0x6e9] 1 p=1.52588e-05 e=0.000244141 cum=9.02366
9.02366 Zero order entropy (bits per pixel)
0x0 Smallest symbol value
0 Smallest symbol length (bits)
0x6e9 Largest symbol value
11 Largest symbol length (bits)
FILES
SEE ALSO
dcstats(1), dcintro(1)
AUTHOR
Copyright (C) 1993-2010. David A. Clunie DBA PixelMed Publishing. All rights reserved.
BUGS
DICOM PS3 20 August 2007 DCHIST(1)