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


      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


      0004 Y …


      0251 N


      0253 Y

      Any help will be greatly appreciated