Skip to content

Instantly share code, notes, and snippets.

@recursivecodes

recursivecodes/create-person-table.sql

Created April 18, 2019 14:27
Show Gist options
  • Save recursivecodes/467b7f64363bbadd18bb510c49934cb0 to your computer and use it in GitHub Desktop.
Save recursivecodes/467b7f64363bbadd18bb510c49934cb0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
create-person-table.sql
CREATE TABLE person (
id NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY,
version NUMBER(20) NOT NULL,
first_name VARCHAR2(50) NOT NULL,
last_name VARCHAR2(50) NULL,
is_cool NUMBER(1,0) NOT NULL
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment