Lai ievadītu datus šajā tabulā es izmantoju rīku SQLLOADER. Tam nolūkam es izveidoju kontroles failu ar sekojošu saturu:
load data
infile *
into table INSTRUMENTI
fields terminated by "," optionally enclosed by '"'
(ID, NOSAUKUMS, NOTES, IPASNIEKS COLUMN OBJECT (PK, VARDS, UZVARDS, DZIMUMS, AMATS, NODALA, KONTAKTI, ALGA))
BEGINDATA
(1,"Amurs","Labs",DARBINIEKS("150588-10256", "SVETLANA","NAUMECA", "SIEVIETE", "APKOPEJA", "DARBA NODALA", "28378568", 100.00));
(2,"Zagis","Liels",DARBINIEKS("140388-10205", "NATALIJA","KRASILNIKOVA", "SIEVIETE","APKOPEJA","KULTURAS NODALA","24351324",250.00));
(3,"Liels amurs","",DARBINIEKS("130588-10202", "ARTURS","FEOKLISTOVS", "VIRIETIS","RADIOTEHNIKIS","KULTURAS NODALA","28654324",500.00));
(4,"Liels zagis","",DARBINIEKS("160554-10345", "SERGEJS","EIDUKS", "VIRIETIS","RADIOTEHNIKIS","DARBA NODALA","28789054",50.00));
(5,"Skruve","Uz +",DARBINIEKS("150588-10256", "SVETLANA","NAUMECA", "SIEVIETE", "APKOPEJA", "DARBA NODALA", "28378568", 100.00));
(6,"Skruve","Uz -",DARBINIEKS("170565-15432", "ALEKSIS","KOKS", "VIRIETIS","RADIOTEHNIKIS","DARBA NODALA","23451324",500.00));
(7,"Atslega","Uz 9",DARBINIEKS("185876-10234", "INGA","ZARA", "SIEVIETE","APKOPEJA","DARBA NODALA","28357890",400.00));
(8,"Atslega",Uz 12",DARBINIEKS("150588-10256", "SVETLANA","NAUMECA", "SIEVIETE", "APKOPEJA", "DARBA NODALA", "28378568", 100.00));
(9,"Atslega","Uz 14",DARBINIEKS("190587-10098", "JURIJS","NIKOLAJEVS", "VIRIETIS","OPERATORS","APSTRADES NODALA","21251324",300.00));
(10,"Cirvis","Smags",DARBINIEKS("150588-10256", "SVETLANA","NAUMECA", "SIEVIETE", "APKOPEJA", "DARBA NODALA", "28378568", 100.00));
INFILE * nosaka, ka informācija, kuru ir jāievada būs šajā pašā failā, nevis citā, ar nākamo komandu tiek definēta tabula, kurā jāievada datus. FIELDS TERMINATED BY nosaka katra lauka atdalīšanas simbolu no cita lauka, bet enclosed by nosaka teksta informācijas simbolus, kas tiks izvietoti pirms sākuma un beigās. 5. rindā tiek nosauktas tabulas kolonnas, kurās būs jāievieto datus (kolonna IPASNIEKS tiek definēta kā objektu kolonna, aiz tā iekavās tiek pārskaitīti objekta dati). No 7. rindas tiek pārskaitīti dati, kurus ievadīsim (sintakse maz ar ko atšķiras no datu ievades ar INSERT INTO palīdzību.
Izveidoto teksta failu vēlāk palaidu ar konsoles palīdzību, ievadot komandu:
sqlldr login/password control=”ceļš pie kontroles faila”
Mēs sekmīgi ievadījām 10 ierakstus tabulā INSTRUMENTI.…
