Oracle Issues

Databases
1

Hey,
I’m working on an Oracle script file for an assignment at the moment. I have two objects : visitor and address and want a 1-M relationship between them.

I have added the following into visitor:

visitor_addressrref REF address_objtyp,

but I always get an error. Any ideas?

2

Please could someone attempt to help me out? I need to get this fixed today?

3

I also have an object created with 3 subtype objects created “under” it. How would I insert data into both the main object and 1 of the 3 subtypes in one statement?

4

No one has any ideas then?