Creating an index-organized table : Create Table « Table « Oracle PL / SQL

Oracle PL / SQL 1.  Aggregate Functions 2.  Analytical Functions 3.  Char Functions 4.  Constraints 5.  Conversion Functions 6.  Cursor 7.  Data Type 8.  Date Timezone 9.  Hierarchical Query 10.  Index 11.  Insert Delete Update 12.  Large Objects 13.  Numeric Math Functions 14.  Object Oriented Database 15.  PL SQL 16.  Regular Expressions 17.  Report Column Page 18.  Result Set 19.  Select Query 20.  Sequence 21.  SQL Plus 22.  Stored Procedure Function 23.  Subquery 24.  System Packages 25.  System Tables Views 26.  Table 27.  Table Joins 28.  Trigger 29.  User Previliege 30.  View 31.  XML Java Java Tutorial Java Source Code / Java Documentation Java Open Source Jar File Download Java Articles Java Products Java by API C# / C Sharp C# / CSharp Tutorial ASP.Net JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial PHP Python SQL Server / T-SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript VBA / Excel / Access / Word Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

Oracle PL / SQL » Table » Create Table   Creating an index-organized table SQL> -- Creating an index-organized table: SQL> SQL> create table states (   2        state_id         varchar2(2),   3        state_name       varchar2(20),   4        constraint states_pk   5          primary key (state_id)   6      )   7      organization index   8      / Table created. SQL> SQL> drop table states;                     Related examples in the same category 1.  Create table template 2.  Create table with data type: VARCHAR2, Date, Number(8,2) 3.  Using a CREATE TABLE statement: create a table with primary key 4.  Creating Table with combined primary key 5.  Create table with foreign key 6.  create as select 7.  create as select, then add primary key 8.  CREATE TABLE AS SELECT with where clause 9.  Creating Table and indicate tablespace 10.  An example of creating an index-organized table: 11.  Create a table with 'deferrable initially immediate' 12.  include a complete CREATE INDEX clause as part of the CREATE TABLE statement 13.  Create a table by specifying the storage settings 14.  Create a table with ORGANIZATION INDEX 15.  Use 'using index' option when creating a table 16.  Create a table and set storage FREELISTS 2 17.  Create a table with 'overflow INCLUDING y' 18.  Create table with Check Constraints 19.  Create table with Unique Constraints 20.  Creating an External Table

w__w__w._j_a_va2__s_.___c_o__m___ | Contact Us

Copyright 2003 - 08 Demo Source and Support. All rights reserved.

All other trademarks are property of their respective owners.