Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> SQL Syntax with Objects
Hi,
I have basic problems with SQL-Syntax concerning objects. I don't know
to insert
single attributes in a table with objects. The table looks like:
table example
objecttype A (with attrib1, attrib2)
objecttype B (with attrib3, attrib4)
How can I insert a value for attrib 1 in objecttype A without filling
attrib 2. I only
know how to insert the values for a complete object. (a this time I
wrote a procedure to solve this problem, but there must be another way)
Another question: I want to select only single attributes from objects.
Is the only
way to do this with aliases like 'select a.objecttypeA.attrib1 from
example a'?
Received on Fri May 19 2000 - 00:00:00 CDT
![]() |
![]() |