Advertisement
badrulme

Default Table creation script(P-IT)

Apr 22nd, 2018
291
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE   TABLE tablename(
  2.   table_no            NUMBER(30),
  3.   table_id            VARCHAR2(50),
  4.   ss_creator          NUMBER(30),
  5.   ss_created_on       VARCHAR2(50 BYTE),
  6.   ss_modifier         NUMBER(30),
  7.   ss_modified_on      VARCHAR2(50 BYTE),
  8.   ss_og_no            NUMBER(10),
  9.   company_no          NUMBER(30),
  10.   ss_uploaded_on      VARCHAR2(50 BYTE),
  11.   ss_is_deleted       NUMBER(1)                 DEFAULT 0,
  12.   ss_is_uploaded      NUMBER(1)                 DEFAULT 0
  13.   );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement