Database implementation and querying Essay Example | Topics and Well Written Essays - 2000 words

Database implementation and querying - Essay Example SQL> create table a1_language ( language varchar2(15) constraint language primar y key); Table created. SQL> insert into a1_language values ('Romanian'); 1 row created. SQL> insert into a1_language values ('English'); 1 row created. SQL> insert into a1_language values ('French'); 1 row created. SQL> insert into a1_language values ('German'); 1 row created. SQL> insert into a1_language values ('Afrikaans'); 1 row created. SQL> insert into a1_language values ('Spanish'); 1 row created. SQL> insert into a1_language values ('Catalan'); 1 row created. SQL> insert into a1_language values ('Portuguese'); 1 row created. SQL> insert into a1_language values ('Italian'); 1 row created. SQL> insert into a1_language values ('Turkish'); 1 row created. SQL> insert into a1_language values ('Lithuanian'); 1 row created. SQL> insert into a1_language values ('Russian'); 1 row created. SQL> insert into a1_language values ('Japanese'); 1 row created. SQL> insert into a1_language values ('Slovenian'); 1 r ow created. SQL> insert into a1_language values ('Norwegian'); 1 row created. SQL> insert into a1_language values ('Chinese'); 1 row created. SQL> insert into a1_language values ('Serbian'); 1 row created. SQL> insert into a1_language values ('Slovak'); 1 row created. SQL> insert into a1_language values ('Czech'); 1 row created. SQL> insert into a1_language values ('Polish'); 1 row created. ... l ( issn varchar2(9) constraint issn primary key, tit le varchar2(100), url varchar2(110), publisher_id number(3), keyword varchar2(18 0), start_year number(4), end_year number(4) ); Table created. SQL> commit; Commit complete. SQL> insert into a1_journal values ('1222-569X','Annals of the University of Ora dea : Economic Science','http://steconomice.uoradea.ro/anale/en_index.html',114, 'financial accounting, banking, management, marketing, statistics',2005,NULL); i nsert into a1_journal values ('1311-0160','Balkan Journal of Medical Genetics',' http://versita.metapress.com/content/120841/',118,'genetics, genetic engineering ',2007,NULL); insert into a1_journal values ('1222-569X','Annals of the University of Oradea : Economic Science','http://steconomice.uoradea.ro/anale/en_index.html',114,'fina ncial accounting, banking, management, marketing, statistics',2005,NULL); insert into a1_journal values ('1311-0160','Balkan Journal of Medical Genetics','http: //versita.metapress.com/conte nt/120841/',118,'genetics, genetic engineering',200 7,NULL) * ERROR at line 1: ORA-00911: invalid character SQL> insert into a1_journal values ('1222-569X','Annals of the University of Ora dea : Economic Science','http://steconomice.uoradea.ro/anale/en_index.html',114, 'financial accounting, banking, management, marketing, statistics',2005,NULL); 1 row created. SQL> insert into a1_journal values ('1311-0160','Balkan Journal of Medical Genet ics','http://versita.metapress.com/content/120841/',118,'genetics, genetic engin eering',2007,NULL); 1 row created. SQL> insert into a1_journal values ('0259-9422','Hervormde Teologiese Studies',' http://www.scielo.org.za/scielo.php',115,' theological disciplines, bible study' ,2008,NULL); 1 row created. SQL> insert into a1_journal values