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

Database implementation and querying - Essay ExampleSQL create table a1_words ( language varchar2(15) constraint language primar y key) Table created. SQL introduce into a1_language determine (Romanian) 1 form created. SQL go in into a1_language values (English) 1 row created. SQL stack away 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 (Slovenia n) 1 row 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 agitate 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/content/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, theologi cal disciplines, bible study ,2008,NULL) 1 row created. SQL insert into a1_journal values