Need help creating a specific Oracle View

190 pts.
Tags:
Oracle development
Oracle Nested Tables
Oracle Views
VARCHAR
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • OracleATE
    [...] per page:Related Blogs:Pfeifer Studio - PfeiferBlog - http://www.pfeiferstudio.com/blogs.aspxNeed help creating a specific Oracle View54 minutes ago by itanswers  We have several tables with what would probably have been nested [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following