Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> SQL Syntax with Objects

SQL Syntax with Objects

From: Roland Winkler <rwinkler_at_okay.net>
Date: 2000/05/19
Message-ID: <3925841F.632FA24F@okay.net>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US