OraFAQ Forum: Unix » shell script

Home » Infrastructure » Unix » shell script

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

shell script [message #171387]

Tue, 09 May 2006 11:51

chimbs
Messages: 32
Registered: April 2005

Member

Hi,

Can anyone help me to write a shell script which load data from a text file (containing comma delimited datas) into an oracle table? please i am new to shell script.

( ksh)

Thanks a lot

Report message to a moderator

Re: shell script [message #171391 is a reply to message #171387]

Tue, 09 May 2006 12:30

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

have'nt tested. But should work

#!/usr/bin/bash
sqlldr userid=username/password control=yourcontrolfile.ctl

Give execute priviliges to file and execute~.

Report message to a moderator

Re: shell script [message #171392 is a reply to message #171391]

Tue, 09 May 2006 12:31

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://orafaq.com/faq/sql_loader

Report message to a moderator

Re: shell script [message #171397 is a reply to message #171392]

Tue, 09 May 2006 13:16

chimbs
Messages: 32
Registered: April 2005

Member

is it possible to load data without using Sql loader?
is it possible using only shell script?

Report message to a moderator

Re: shell script [message #171398 is a reply to message #171397]

Tue, 09 May 2006 13:23

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You can use PERL to parse through the file.
or even awk, in a few simple cases.
Both options are Pain.
Or
You can use UTL_FILE (Oracle built-in) to read the file line by line
or
Use external tables and treat the file as a table. So No loading is necessary.
Please search the forum.

Report message to a moderator