1 Reply Latest reply on Feb 17, 2014 12:36 AM by rp0428

    Toad Sql - convert multiple fields of data into rows - character by character

    Lamb804

      I recently started working in TOAD Oracle and was given the task to create a SQL statement that will take eight 250-column fields from a table and convert them to 2000 rows with row numbers.

      I have no idea how to read character by character (most of the characters being blank).

      How do I use a variable that increases the value by one?

      I tied Select substr(myFieldA,varA,1) from myTable 

      but it doesn't like the variable, also how do I do the looping statement.

       

      My result will be similiar to:

      0001 Y

      0002 N

      0003

      0004 Y …

       

      0251 N

      0252

      0253 Y

      Any help will be greatly appreciated