Advertisement
saleks28

Untitled

Sep 26th, 2020
348
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.47 KB | None | 0 0
  1. CREATE TABLE TestTableManualSect_1(
  2.     CHECK(id<=500000),
  3.     id          NUMBER    GENERATED BY DEFAULT AS IDENTITY,
  4.     TIMESTAMP   TIMESTAMP NOT NULL,
  5.     action      NUMBER    NOT NULL,
  6.     description VARCHAR2(255)
  7. );
  8.  
  9. CREATE TABLE TestTableManualSect_2(
  10.     CHECK(id>5000000),
  11.     id          NUMBER    GENERATED BY DEFAULT AS IDENTITY START WITH 20000001,
  12.     TIMESTAMP   TIMESTAMP NOT NULL,
  13.     action      NUMBER    NOT NULL,
  14.     description VARCHAR2(255)
  15.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement