You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register

    • How to insert comma delimited values in one column using DBMS_CLOUD?

    in Autonomous Database 5 comments

    Summary:

    Hi Team,
    We are trying to insert the bulk data using DBMS_CLOUD_COPY_DATA/DBMS_CLOUD.CREATE_EXTERNAL_TABLE.
    In source file, We have few columns like tags/additional infomation is having data with comma delimited values and during the insertion process column data is moving to another/next coloumns.
    How can we avoid splitting of the data into next columns?
    Is there any possiblitiy to skip the few columns data during the inserting processinto tables(eventhough we have the column in our source file).

    Thank you for your help in advance.

    Content (please ensure you mask any confidential information):

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!