There are a table column number is not a fixed value is only one line
AA BB CC DD... .
1 2 3 4... .


Need through the statements into the following format

AA 1
BB 2
CC 3
DD
4. .
. .

CodePudding user response:

Write a stored procedure
Traverse user_tab_columns
Among inserted into a temporary table?

CodePudding user response:

 if is 11 g with pivot