1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

what query to write to create text data file for uploading data in staging table ?

Discussion in 'SQL PL/SQL' started by Nidhi25, Apr 7, 2010.

  1. Nidhi25

    Nidhi25 Forum Genius

    Messages:
    81
    Likes Received:
    9
    Trophy Points:
    835
    I wish to create create a text data file for uploading in staging table. How do we write query for this. We are to map data from legacy system to oracle system. For that we need to create text data file. We are uploading thrrough custom forms that we have made.
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Re: what query to write to create text data file for uploading data in staging table

    Through Sql*loader it is easy to upload text file data into staging table. For this we need to write one control file.
     
  3. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,345
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Re: what query to write to create text data file for uploading data in staging table

    That doesn't answer the question.

    Creating a text file of data depends on the source and how you want that text file formatted. We need to know what this 'legacy system' is. Depending on the data source there may be tools available to generate a flat file of the data; Sybase and SQL Server offer bcp to generate such files, Oracle can do it through SQL*Plus.

    Without further information it's almost impossible to answer your question.