Home » SQL & PL/SQL » SQL & PL/SQL » TABLE TYPES with clustered (11g)
TABLE TYPES with clustered [message #604296] Fri, 27 December 2013 13:35 Go to next message
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
Re: TABLE TYPES with clustered [message #604299 is a reply to message #604296] Fri, 27 December 2013 13:50 Go to previous message
Michel Cadot
Messages: 64956
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: Mon Jun 26 17:45:23 CDT 2017

Total time taken to generate the page: 0.09303 seconds