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:
0004 Y …
Any help will be greatly appreciated
Hmmm - why did you think you should post a TOAD and SQL question if the SQL Developer forum?
Mark the question ANSWERED and repost it in the SQL and PL/SQL forum.