25 Ocak 2017 Çarşamba

PL-SQL Table Create

CREATE TABLE OD_TABLE
( SEQ_NO NUMBER(12) not null,
  colum2 varchar2(50) not null,
 colum3 varchar2(50),
 colum4 varchar2(50),
 colum5 varchar2(50),
 colum6 varchar2(50),
  colum7 varchar2(50),
  colum8 varchar2(4000),
  CRE_USER varchar2(50),
  CONSTRAINT OD_TABLE_pk PRIMARY KEY (SEQ_NO)
);


CREATE TABLE OD_TABLE (select * from table_name)