CONNECT TO stud2020;
drop table fasta;
CREATE TABLE fasta 
          ( GENOM CHARACTER (9)     NOT NULL , 
            OPIS VARCHAR (100)             , 
            duzina  integer                ,
            KOD CLOB (5600K)    , 
            PRIMARY KEY (GENOM)  
          );
          
LOAD FROM nc_002655.txt OF DEL LOBS FROM . METHOD P (1, 2, 3) MESSAGES nc_002655.txt.izv 
      INSERT INTO NENAD.FASTA (GENOM, OPIS, KOD) COPY NO INDEXING MODE AUTOSELECT;

update fasta set duzina=length(kod);
