There is no inheretence like what you said in Oracle. why you use the tables like that. If you follow the ERD you never get the tables like these.
Can Table be Inheretence? details in contents.