The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Advanced & Expert Users
Google UNIX.COM


UNIX for Advanced & Expert Users Advanced UNIX and Linux questions go here. Expert-to-Expert.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
unix file to oracle table ran16 Shell Programming and Scripting 2 06-14-2008 11:27 AM
alert_oss.log oracle log file in hp-unix Assassin Shell Programming and Scripting 3 05-01-2007 05:30 PM
How to pass unix variable to oracle chiru UNIX for Dummies Questions & Answers 1 06-12-2006 01:10 PM
how to pass values from oracle sql plus to unix shell script trichyselva UNIX for Dummies Questions & Answers 2 02-24-2006 07:19 AM
How to pass a oracle variable back to the shell script Jtrinh UNIX for Dummies Questions & Answers 3 07-11-2005 11:07 AM

Reply
 
Submit Tools LinkBack Thread Tools Search this Thread Display Modes
  #1  
Old 06-28-2008
vidyadhar85's Avatar
The Tutor
 

Join Date: Jun 2008
Location: INDIA
Posts: 543
How can i pass a file from unix to oracle??

I am having a file which has the following data
123424
2354235
142424
43423
1434
.
.
.
.
etc
i want to pass these values to oracle at a time by using a file.. can someone suggest me a answer...
waiting......
Reply With Quote
Forum Sponsor
  #2  
Old 06-28-2008
awk awk is offline
Registered User
 

Join Date: Feb 2007
Posts: 120
Quote:
Originally Posted by vidyadhar85 View Post
I am having a file which has the following data
123424
2354235
142424
43423
1434
.
.
.
.
etc
i want to pass these values to oracle at a time by using a file.. can someone suggest me a answer...
waiting......
Oracle supports External Tables in UNIX - which are flat files that are treated like a table within Oracle.

Or, use the sql*loader features

Both of these are explained in the Utilites Manual of Oracle.
Reply With Quote
Google The UNIX and Linux Forums
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes




All times are GMT -7. The time now is 01:32 PM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008. All Rights Reserved.Ad Management by RedTyger Visit The Complex Event Processing Blog

Content Relevant URLs by vBSEO 3.2.0