How to populate oracle table?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to populate oracle table?

  1. #1
    Join Date
    Jun 2012
    Posts
    1

    How to populate oracle table?

    hi, I'm newbie programmer and very new in oracle.
    My first project is to create table in oracle database and then access it.
    I already created a table, now my question is how to populate the table I just created? " I need to populate it with csv files"
    Will someone please help me figure this out? If somebody would, would you please explain it to me step by step. Thanks in advance

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,027
    You have two basic options to complete this homework assignment.
    You can use SQL Loader or you can create and external table.

    http://www.orafaq.com/wiki/SQL*Loader_FAQ

    http://asktom.oracle.com/pls/apex/f?...16200346131007

    http://oreilly.com/catalog/orsqlload...pter/ch01.html

    Creating an external table uses the SQL loader utility, but it allows you to query the external table as well as pull data from it.

    Good Luck, and make sure that you put my name on you assignment when you turn it in so that I can get credit.
    this space intentionally left blank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width