Home » Infrastructure » Unix » Need help in reading from flat tile in shell scripting
Need help in reading from flat tile in shell scripting [message #124111] Thu, 16 June 2005 08:23 Go to next message
Naveen Verma
Messages: 60
Registered: August 2004
Member
Hi Good Morning all
My problem is : First I have to check one table like emp then take all empno's whose dept is Sales, then I need to take their data from flat file by matching this empno.

Could you please help me out to solve this issue by giving a hint or a sample logic.

Thanks
Naveen
Re: Need help in reading from flat tile in shell scripting [message #124112 is a reply to message #124111] Thu, 16 June 2005 08:28 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
option 1.) use sql*loader to load the text file into database.
do comparisons inside the database using oracle means.
option 2.) read the text file using UTL_FILE.
compare with existing table.
option 3.) consider the external flat file as an external table
(only in 9i and above) and compare.
option 4.) external scripting methods.
using perl/shell scripting options read the contens of
text file and compare with table inside oracle.
Previous Topic: Calling a sql (*.sql) script in a Procedure - in Unix Env.
Next Topic: Installation on Unix OS on my PC ????
Goto Forum:
  


Current Time: Thu Mar 28 18:15:29 CDT 2024