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?
February 3, 2009 4:02 PM
February 3, 2009 6:34 PM