DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: insert

  1. 07-23-2002, 10:26 PM #1
    tanaka
    tanaka is offline Junior Member
    Join Date
    Apr 2002
    Posts
    55
    Hi ,

    I have a variable which stores a string like..

    str -> 'abc,1234,xyz'

    Now i want to break this string at the commas and then insert the sepate strings in diffrent columns of a single table.The length of str is not fixed.

    Help needed.
    Reply With Quote Reply With Quote
  2. 07-23-2002, 10:56 PM #2
    balajiyes
    balajiyes is offline Advisor
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    try using DBMS_UTILITY.COMMA_TO_TABLE
    Cheers!
    Cheers!
    OraKid.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width