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!

How to insert large piece of data or LOB using SQL clause.

Discussion in 'SQL PL/SQL' started by Totulas, Oct 9, 2013.

  1. Totulas

    Totulas Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hello, eneryone, I have encountered some problems in SQL, hope someone can help me.

    I want to create a table with a bunch of prepared data. For ease of use, I choose to generate a SQL file which contains all
    the sql clauses used to create the table and insert the data. So all the data can only be inserted to a table using sql clause.

    My questions:
    1) If data of a column is large (for example, 1 M text), how to insert it using SQL, is there a piecewise method.
    2) And how can I insert BLOB data using SQL clause.

    What I what is to enclose all the operations in a single SQL file, and when the table is needed, just execute this SQL file.

    Can anyone give me some help, thanks.
     
  2. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
  3. bkoniki

    bkoniki Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    55
    You can use SQL*Loader to insert BLOB data.