[thesite] code(this)

[rudy]

 insert into categorys
   ( CATEGORYID, CATTYPEID, CATEGORY
  , CREATED, CREATEDBY, ACTIVE, ACTIVEBY
  , DATEMOD )
 select 
    evolt_seq.nextval, 3847, 'Answer This!'
  , TO_DATE('26-APR-01'), 20, 0, null
  , null
 from dual;

1 row inserted

 select CATEGORYID as ID
 ,substr(CATEGORY,1,21) as category
    , ACTIVE, CREATED   
  from categorys  ORDER BY CATEGORY;

        ID CATEGORY                  ACTIVE CREATED
---------- --------------------- ---------- ---------
     10047 Answer This!                   0 26-APR-01
        18 Backend                        1 01-JUN-99
        17 Code                           1 01-JUN-99
        25 Commentary & Society           1 07-JUL-99
      9741 FAQ                            1 13-APR-01
      4090 IA/Usability                   1 18-NOV-00
        23 Jobs                           1 01-JUN-99
         1 News                           1 28-MAR-99
        12 Reviews & Links                1 29-APR-99
        20 Site Development               1 01-JUN-99
        21 Software                       1 01-JUN-99
        26 Suggestions                    1 08-JUL-99
        22 Visual Design                  1 01-JUN-99
      4091 Web Business                   0 18-NOV-00

14 rows selected.