...imam problem i ne kapiram kako da ga resim . Mlatim se nesto za ispit za fax,i potrebno mi je da unesem podatke u tabele.
Problem je sledeci...
ovo mogu da unosim samo liniju po liniju....inace mi javlja "ORA-00911: invalid character " . Nije preterani problem...ostalo mi radi ok ali...bas me kopka u cemu je problem ?
Da uprostim pitanje...kako da isprocesiram ceo ovaj kod odjednom...da ne unosim liniju po liniju koda
ps-- tek sam uzeo da radim malo sql...ako pitam gluposti sorry
ps2-- korisitm oracle express 10g
hvala unapred
Problem je sledeci...
Code:
INSERT INTO POSEDUJE VALUES ('FO2341','BA789256','15-mar-84','10134');
INSERT INTO POSEDUJE VALUES ('JS2938','HD293847','02-mar-75','100');
INSERT INTO POSEDUJE VALUES ('JJ3847','HD543235','17-may-85','15736');
INSERT INTO POSEDUJE VALUES ('OZ8347','FF849583','15-sep-91','2948');
INSERT INTO POSEDUJE VALUES ('PP3958','HA385767','08-aug-95','903');
INSERT INTO POSEDUJE VALUES ('PA9485','UJ203954','31-mar-94','1920');
INSERT INTO POSEDUJE VALUES ('TX9283','HD293847','15-feb-97','92870');
INSERT INTO POSEDUJE VALUES ('PA9485','GG847264','13-mar-96','1920');
INSERT INTO POSEDUJE VALUES ('JJ3847','HA928375','17-may-87','45736');
INSERT INTO POSEDUJE VALUES ('JS2938','IA192837','15-apr-83','55612');
INSERT INTO POSEDUJE VALUES ('FO2341','FF849583','20-dec-89','79865');
INSERT INTO POSEDUJE VALUES ('JJ3847','BA789256','27-aug-93','15736');
INSERT INTO POSEDUJE VALUES ('TX9283','HD543235','14-nov-95','28721');
INSERT INTO POSEDUJE VALUES ('FO2341','BA789256','15-mar-84','10134');
INSERT INTO POSEDUJE VALUES ('JS2938','HD293847','02-mar-75','100');
INSERT INTO POSEDUJE VALUES ('JJ3847','HD543235','17-may-85','15736');
INSERT INTO POSEDUJE VALUES ('OZ8347','FF849583','15-sep-91','2948');
INSERT INTO POSEDUJE VALUES ('PP3958','HA385767','08-aug-95','903');
INSERT INTO POSEDUJE VALUES ('PA9485','UJ203954','31-mar-94','1920');
INSERT INTO POSEDUJE VALUES ('TX9283','HD293847','15-feb-97','92870');
INSERT INTO POSEDUJE VALUES ('PA9485','GG847264','13-mar-96','1920');
INSERT INTO POSEDUJE VALUES ('JJ3847','HA928375','17-may-87','45736');
INSERT INTO POSEDUJE VALUES ('JS2938','IA192837','15-apr-83','55612');
INSERT INTO POSEDUJE VALUES ('FO2341','FF849583','20-dec-89','79865');
INSERT INTO POSEDUJE VALUES ('JJ3847','BA789256','27-aug-93','15736');
INSERT INTO POSEDUJE VALUES ('TX9283','HD543235','14-nov-95','28721');
ovo mogu da unosim samo liniju po liniju....inace mi javlja "ORA-00911: invalid character " . Nije preterani problem...ostalo mi radi ok ali...bas me kopka u cemu je problem ?
Da uprostim pitanje...kako da isprocesiram ceo ovaj kod odjednom...da ne unosim liniju po liniju koda
ps-- tek sam uzeo da radim malo sql...ako pitam gluposti sorry
ps2-- korisitm oracle express 10g
hvala unapred