Different types of interfaces to store data in Excel Sheet to Oracle D

we can save data in Excel Sheet to oracle database using SQL loader ,

Page 1 of 1

1 Replies - 2655 Views - Last Post: 25 February 2008 - 08:55 AM

#1 suddu225  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 24-February 08

Different types of interfaces to store data in Excel Sheet to Oracle D

Post icon  Posted 24 February 2008 - 11:47 AM

we can save data in Excel Sheet to oracle database using SQL loader , i request you friends to tell me in how many ways we can do it without using SQL loader.
Is This A Good Question/Topic? 0
  • +

Replies To: Different types of interfaces to store data in Excel Sheet to Oracle D

#2 beef  Icon User is offline

  • D.I.C Head
  • member icon

Reputation: 1
  • View blog
  • Posts: 141
  • Joined: 02-November 06

Re: Different types of interfaces to store data in Excel Sheet to Oracle D

Posted 25 February 2008 - 08:55 AM

You could use utl_file to read the file in line by line. This can be pretty handy in some situations because you could have a database procedure to load the file in instead of needing to run a script to do it.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1