Skip to content

Instantly share code, notes, and snippets.

@recursivecodes

recursivecodes/create-user-tbl.sql

Last active June 28, 2019 18:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save recursivecodes/10c96583a3cb32b992ce094e38fc5b12 to your computer and use it in GitHub Desktop.
Save recursivecodes/10c96583a3cb32b992ce094e38fc5b12 to your computer and use it in GitHub Desktop.
Download ZIP
create-user-tbl.sql
Raw
create-user-tbl.sql
CREATE TABLE users(
"ID" VARCHAR2(32 BYTE) DEFAULT ON NULL SYS_GUID(), 
"FIRST_NAME" VARCHAR2(50 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
"LAST_NAME" VARCHAR2(50 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
"USERNAME" VARCHAR2(50 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
"CREATED_ON" TIMESTAMP (6) DEFAULT ON NULL CURRENT_TIMESTAMP, 
CONSTRAINT "USER_PK" PRIMARY KEY ("ID")
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment