Home » SQL & PL/SQL » SQL & PL/SQL » Table Types
Table Types [message #316483] Fri, 25 April 2008 06:00 Go to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
There are seven oracle table types:

Heap organized tables
Index organized tables
Index clustered tables
Hash clustered tables
Nested tables
Global temporary tables
Object tables

Am i missing any table types?Are my findings correct on the table types?
Re: Table Types [message #316485 is a reply to message #316483] Fri, 25 April 2008 06:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
External tables.

Regards
Michel
Re: Table Types [message #316492 is a reply to message #316485] Fri, 25 April 2008 06:29 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
oh yes. Thanks.

what about stage & operational tables?
Re: Table Types [message #316493 is a reply to message #316492] Fri, 25 April 2008 06:31 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Those are uses for tables, not types of tables.
Re: Table Types [message #316495 is a reply to message #316493] Fri, 25 April 2008 06:37 Go to previous message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
alright thanks. i was getting very confused between the two.

The seven table types are structure and table organization and stage and operational are basically uses of tables.right?

also XMLtype is also another table type right?

[Updated on: Fri, 25 April 2008 06:40]

Report message to a moderator

Previous Topic: How to return row list? (merged)
Next Topic: When to use partition indexes?
Goto Forum:
  


Current Time: Mon Dec 05 21:35:17 CST 2016

Total time taken to generate the page: 0.08229 seconds