tabel yg memiliki 14 field bertipedata beda dan menyalin query dari tabel tersebut

 thanks to richi, lek feri, mas farid dan pak nur

CREATE TABLE namatab1
(
  COLUMN1 VARCHAR2(20)
, COLUMN2 NUMBER
, COLUMN3 DATE
, COLUMN4 CLOB
, COLUMN5 BLOB
, COLUMN6 BFILE
, COLUMN7 BINARY_DOUBLE
, COLUMN8 BINARY_FLOAT
, COLUMN9 BLOB
, COLUMN10 CHARACTER VARYING(20)
, COLUMN11 DOUBLE PRECISION
, COLUMN12 CHARACTER
, COLUMN13 NUMBER
, COLUMN14 LONG VARCHAR
);


subquery nya
CREATE TABLE namatab2
   AS SELECT column1, column2, column3, column4 FROM namatab1 ;