tag:blogger.com,1999:blog-8884584404576003487.post8900955765520569538..comments2024-02-29T09:43:12.251-05:00Comments on ORACLENERD: Nested Tablesoraclenerdhttp://www.blogger.com/profile/12412013306950057961noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-8884584404576003487.post-30970239057146746462009-01-05T16:45:00.000-05:002009-01-05T16:45:00.000-05:00Thanks Mike! I just might have to take you up on ...Thanks Mike! I just might have to take you up on that offer.oraclenerdhttps://www.blogger.com/profile/12412013306950057961noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-435512320371628932009-01-05T16:29:00.000-05:002009-01-05T16:29:00.000-05:00For what it's worth, Chet, I'm about 90% of the wa...For what it's worth, Chet, I'm about 90% of the way through a book on this subject (Michael McLaughlin - Oracle Database 11g PL/SQL Programming).<BR/>I can't promise you I can be of any use, but if you have an issue I can research for you while in the course of my regular study, let me know.<BR/>I'd probably learn in the process and God knows I can use every trick I can find to motivate myself to slog through this thing (it's about 1200 pgs).<BR/>Cheers,<BR/>-MikeUnknownhttps://www.blogger.com/profile/14401032504437933147noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-61819341805293759172009-01-04T11:17:00.000-05:002009-01-04T11:17:00.000-05:00Hadn't thought of that Dom. I'll give that a shot...Hadn't thought of that Dom. I'll give that a shot. Gratzi!oraclenerdhttps://www.blogger.com/profile/12412013306950057961noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-26773133708541693362009-01-04T05:58:00.000-05:002009-01-04T05:58:00.000-05:00My rule of thumb - if you think you need this sort...My rule of thumb - if you think you need this sort of OR structure, keep the underlying tables straight up relational and put an OR view on top.DomBrookshttps://www.blogger.com/profile/02598622186013843759noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-52911435977972249372009-01-03T18:15:00.000-05:002009-01-03T18:15:00.000-05:00I'm glad you pointed me in that direction. I hadn...I'm glad you pointed me in that direction. I hadn't really read the docs on UDTs or nested tables (other than Mr. Morgan's library of course).<BR/><BR/>For me it just comes down to practicality. Once I can find a good use for them (nested tables and the like) I'd be glad to learn more, but until then...oraclenerdhttps://www.blogger.com/profile/12412013306950057961noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-74801482945726808372009-01-03T15:46:00.000-05:002009-01-03T15:46:00.000-05:00Neither did I, but something in your SELECT statem...Neither did I, but something in your <B>SELECT</B> statement just seemed smelly.<BR/><BR/>My first instinct was to stick a <B>ARGUMENTS.COUNT</B> in the select list. I was hoping that since SQL automatically DEREFs objects and allows attribute traversal, that would just invoke the <B>COUNT</B> collection function. That failed, however.<BR/><BR/>So, I fell back to...<BR/><BR/><B> select procedure_name, (select count(1) from arguments) arg_count from procedures</B><BR/><BR/>... just to avoid the cartesian (or atleast what I think is a cartesian.)<BR/><BR/>But, I figured there had to be a better way. So I looked up collection functions and there it was- CARDINALITY. Weird name, though. :PSaager Mhatrehttps://www.blogger.com/profile/03869587109666583246noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-67202048132201286442009-01-03T14:59:00.000-05:002009-01-03T14:59:00.000-05:00I was just playing with this stuff. I don't know ...I was just playing with this stuff. I don't know much about it yet. I appreciate the pointer though...didn't realize those were out there.<BR/><BR/>tanks!oraclenerdhttps://www.blogger.com/profile/12412013306950057961noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-50910179824909860912009-01-03T14:21:00.000-05:002009-01-03T14:21:00.000-05:00You do realize that you're running a cartesian bet...You do realize that you're running a cartesian between your base table and nested table there, right? If you're just looking for a count, the <A HREF="http://www.psoug.org/reference/collect_func.html#ccar" REL="nofollow">cardinality</A> function should help.Saager Mhatrehttps://www.blogger.com/profile/03869587109666583246noreply@blogger.com