Hi Following is the syntax for creating table in mysql. I want to create table with same properties in oracle9i. Can anyone provide me the equivalent syntax for oracle?

 CREATE TABLE IF NOT EXISTS "tbl_audit_trail" (
      "id" int(11) unsigned NOT NULL,
      "old_value" text NOT NULL,
      "new_value" text NOT NULL,
      "action" varchar(20) CHARACTER SET latin1 NOT NULL,
      "model" varchar(255) CHARACTER SET latin1 NOT NULL,
      "field" varchar(64) CHARACTER SET latin1 NOT NULL,
      "stamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
      "user_id" int(11) NOT NULL,
      "model_id" varchar(65) CHARACTER SET latin1 NOT NULL,
      PRIMARY KEY ("id"),
      KEY "idx_user_id" ("user_id"),
      KEY "idx_model_id" ("model_id"),
      KEY "idx_model" ("model"),
      KEY "idx_field" ("field"),
      KEY "idx_old_value" ("old_value"(16)),
      KEY "idx_new_value" ("new_value"(16)),
      KEY "idx_action" ("action")
    ) AUTO_INCREMENT=168 ;