wood burning stoves 2.0*
The moose likes JDBC and the fly likes Table Inheritence  in oracle? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Table Inheritence  in oracle?" Watch "Table Inheritence  in oracle?" New topic

Table Inheritence in oracle?

scott miles
Ranch Hand

Joined: Jun 16, 2011
Posts: 70
Could anybody brief about Table inheritence in oracle with simple example. Tried to look on different website
but did not get any concrete simple example? say if we have employee class in java and Manager class is extending
employee. Now i want to insert the values in manager class. then some values should go to employee table too along with manager table. could some body help me how we can achieve this thru JDBC?
chris webster

Joined: Mar 01, 2009
Posts: 1606

Tables are not classes or objects so they do not inherit anything. You could have a column in your table to distinguish managers e.g. Employee_type. This will allow you to put all the records in one table but identify managers as a subset. If you are going to use a relational database like Oracle, you need to find out why relational data modelling is different from OO modelling.

No more Blub for me, thank you, Vicar.
I agree. Here's the link: http://aspose.com/file-tools
subject: Table Inheritence in oracle?
Similar Threads
UML / Relational Modeling
Quick question on hierarchical Entity Relationships....
EJB3 Entity Relationship
Hibernate Inheritance..