Need help creating a specific Oracle View
We have several tables with what would probably have been nested columns if that feature had existed when they were created. They are simple VARCHAR2 columns occurring a fixed number of times (2 to 4). Since they are often null, the true number is variable with a fixed maximum. Although we would prefer not to restructure these tables and the applications that access them, it would be useful to access them as if the recurring columns were in nested tables. Is it possible to create a view to accomplish that?
Software/Hardware used:
Software/Hardware used:
ASKED:
February 3, 2009 4:02 PM
UPDATED:
February 3, 2009 6:34 PM
Answer Wiki:
Could you please provide some example data and explain how you are dealing with the data in those colums now ?
Also, the Oracle version could be useful.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
