Rookie help request

Hello, newbie help appreciated!

Is this the correct way to alter a field to make it NOT NULL? ALTER TABLE TABLE_X
MODIFY (FIELD_Y DATE NOT NULL) TABLESPACE &&abc;

Is this the correct way to add an index? CREATE INDEX pq_idx_XYZ ON TABLE_X
(DATE_FIELD ASC) TABLESPACE &&def;

Thanks Received on Fri Mar 07 2003 - 15:41:42 CST