OraFAQ Forum: SQL & PL/SQL » TABLE TYPES with clustered

Home » SQL & PL/SQL » SQL & PL/SQL » TABLE TYPES with clustered (11g)

Fri, 27 December 2013 13:35

Sreekumarkv
Messages: 1
Registered: December 2013

Junior Member

I have a SQl Server udt table type with clustered index. how can i use it in oracle as it has got indexes only on physical tables

Fri, 27 December 2013 13:50

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

In Oracle what you call table with clustered index is named index organized table (IOT).

Previous Topic:	How to find values from one record in a string from another record?
Next Topic:	ORA-30667: cannot drop NOT NULL constraint on a DEFAULT ON NULL column

Goto Forum:

]

Current Time: Fri Apr 26 16:19:57 CDT 2024