| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Relation-valued attributes (again)
I think I misunderstood your post. Do you have a function name Op that
takes an integer as a parameter and returns a table whose first column
is named Data and is of type string? And then are you trying to join
the function's output with TableT based on it primary key named ID?
Something doesn't make sense here as the join is on two different data
types. Are you trying to select records in TableT based on one or more
tables. Is the problem arising due to the inability to reference tables
themselves in a manner similar to rows of a table? If you could
describe the problem in simpler terms with sample data and what the
final goal is, I might be able to enjoy your problem also :)
table y = function_Op(int x)
TableT
ID
-- 1 2 SELECT * FROM TableT JOIN OP(x) ???Received on Tue Feb 08 2005 - 23:55:03 CST
![]() |
![]() |