2 Replies Latest reply: Nov 15, 2012 2:10 AM by Chanchal Wankhade RSS

    TABLE CREATION WITH COMMENT STATEMENT

    915750
      Hi ,

      Can I create a table with comment in a single statement ?
      For Example I have mentioned two statements .One is for table creation and other is to add comment on it.


      CREATE TABLE T1 (C1 NUMBER(3)) ;

      COMMENT ON TABLE T1 IS 'OWNER :ASIT' ;

      But,I wanted this task should be accomplish in a single sql statement.

      Is it possible ?

      Thanks a lot in advance.
      --Asit