Your Ad Here

advanced code snippet search

Posted By

geekzspot on 12/07/10


Tagged

database Oracle DDL


Versions (?)

boolean column for oracle database tables

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. CREATE TABLE booleans
  2. ( 
  3. isBoolean char(1) DEFAULT 1 NOT NULL CHECK ( isBoolean (1,0) )
  4. );
  5.  
  6. comment ON COLUMN booleans.isBoolean IS 'boolean: 1 for True, 0 for False';
  7.  
  8. CREATE bitmap INDEX isBoolean_index_name ON booleans(isBoolean);

Report this snippet  

You need to login to post a comment.