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
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
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: 58954
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 Sep 01 14:11:20 CDT 2014

Total time taken to generate the page: 0.09416 seconds