on 09-16-2008 8:35 PM
HI
Can we use oracle nested tables throgh designer
If so how?
Thank you
Kultar,
given the complexity required in querying an Oracle nested table, it might be best to construct a view then submit that view to Designer. Though looking at the syntax of querying a nested table makes it look like an "alias" process, this "alias" is much more complex, thus making it difficult to replicate in a Designer environment. By performing the Oracle "alias" via the view process, the complexity is maintained in an Oracle environment and Designer just executes the view, which in Designer terms, a view and a table appear as the same to Designer. Here is an example of querying on an Oracle Nested Table and why you'll want to do this as a view:
create view Authors_and_Books as
select Auth.Auth_Name, B.* as The_Books_Written
from Authors Auth, table(Auth.Books_Written) B;
So, you'll get a list of Auth_Name and for each of those the books written from the nested table, but to Designer, it will all look like a table.
Thanks,
John
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.