<%@ taglib uri="http://jakarta.apache.org/taglibs/dbtags" prefix="sql" %><%String title=request.getParameter("title");if(title==null) title="Unicode Enables Globalization"; String author=request.getParameter("author");if (author==null) author="Jonathan Gennick";%><%-- Establish a Oracle database connection --%> SYS change_on_install jdbc:oracle:oci8:@OracleDB oracle.jdbc.driver.OracleDriver <%-- SQL Query to create a table--%> CREATE TABLE OracleCatalog(Journal VARCHAR(25), Publisher Varchar(25), Edition VARCHAR(25),Title varchar(45), Author Varchar(25)) <%-- execute the query --%> <%-- set the SQL query --%> insert into OracleCatalog values('Oracle Magazine', 'Oracle Publishing', 'Nov-Dec 2003','Updating XQuery', 'Jason Hunter') <%-- execute the query --%> <%-- set the SQL query --%> insert into OracleCatalog values('Oracle Magazine', 'Oracle Publishing', 'Jan-Feb 2004','Desgining Schemas', 'Cameron Rourke') <%-- execute the query --%> select JOURNAL, PUBLISHER, EDITION, TITLE, AUTHOR from OracleCatalog

JOURNAL	PUBLISHER	EDITION	TITLE	AUTHOR

<%-- Update a row in the database --%> UPDATE OracleCatalog SET TITLE=?, AUTHOR=? WHERE TITLE=? <%=title%> <%=author%> Updating XQuery select JOURNAL, PUBLISHER, EDITION, TITLE, AUTHOR from OracleCatalog

JOURNAL	PUBLISHER	EDITION	TITLE	AUTHOR

<%-- close a database connection --%>