| Need help in reading from flat tile in shell scripting [message #124111] |
Thu, 16 June 2005 08:23  |
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  |
 |
Mahesh Rajendran
Messages: 10708
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
