var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Why using nested tables rather than REFs ?
What are the nested tables used for ?
I think I understand both nested table and ref concepts.
However, I can't figure out the benefits of the nested vs the ref.
Is there better use cases for both ? How to know ?
Because I personally find the pointer system of ref more clear and organized.
Thank you !
Last edited by JackPoteYes; 03-15-17 at
What do you call a "REF"? What is it? I've been working with Oracle for 20+ years, but I'm not familiar with this term.
Anyway, I can share some thoughts about nested tables. Do I know they exist? Yes. Do I use them? No. Why? I see no benefit.
Originally Posted by
But I agree: I find both concepts pretty useless. I once played around with nested tables (as a replacement for real arrays the way Postgres supports) but they turned out to be horribly slow and rather complicated to use (especially through Java/JDBC).
I think both features come from the "object relational" part that was introduced in Oracle 8, but I don't think any those concepts is of real value.
I never saw the point of using nested tables. They are just over complicated to use. I always use daughter tables to hold the data.
You do not need a parachute to skydive. You only need a parachute to skydive twice.
Shammat, thank you for the REF link. It appears that I should be working
harder with Oracle, after all.
Tags for this Thread