Last modified: Friday, May 10, 2013
.html examples below is
compliments of http://hilite.me,
helpfully suggested by
Justin Brooks! notes.txt's contents into
a textarea (without reloading the whole page);
here is the runnable version on nrs-projects: notes.txt;
here is the runnable version on nrs-projects: note
elements within notes.xml into the textarea;
here is the runnable version on nrs-projects: priority attribute, if any, of the
note elements within notes.xml;
into the textarea;
here is the runnable version on nrs-projects: oci_commit when modifying
an Oracle database using OCI8 in PHP;
here is the runnable version on nrs-projects: require_once
to include this footer:
my-std-footer.html phpinfo();
here is the runnable version on nrs-projects: 
jsp-errs shell script to
your nrs-projects bin directory, so you can view the JSP application
log (for error messages!) more conveniently:
cp ~st10/bin/jsp-errs ~/bin # IF have bin directory!
chmod 700 ~/bin/jsp-errs
jsp-errs will display the last 10
lines of the application log
/opt/oracle/product/10.1/oc4j/j2ee/home/log/global-application.log
cpjsp shell script to your
nrs-projects bin directory, so you can copy JSP
files to the JSP container more conveniently:
cp ~st10/bin/cpjsp ~/bin # IF have bin directory!
chmod 700 ~/bin/cpjsp
cpjsp XxxnYourJsp.jsp will copy
and give the proper permissions to your
XxxnYourJsp.jsp JSP. http://nrs-projects.humboldt.edu:8888/examples/jsp/student/XxxnMyJSP.jsp empsal.html above Statement's
executeUpdate
method ResultSetMetaData PreparedStatement
(and including
turning off auto-commit default);
lect08-setup.sql sets up the example
table and initial contents for this example how_many,
using JDBC;
how-many.sql contains the PL/SQL stored
function, how_many, called (from Week 2 Lecture);
note that this also uses
create-bks.sql and
pop-bks.sql
IN OUT
parameters: swap with two
IN OUT parameters swap and demonstrates that it seems to
work! export CLASSPATH=$CLASSPATH:/opt/oracle/product/11.2.0/client_1/oui/jlib/classes12.jar:. ResultSet's
next method) static methods @webstepbystep on Twitter (by our
course textbook's authors), and/or look at their tweets for
links to interesting JavaScript-related articles please.js);
here is the runnable version on nrs-projects: three-param-form.css);
here is the runnable version on nrs-projects: how_many, that has an if-statement, and a parameter;
also has an example of using the nvl
function cursor_loop, which includes
an example of a PL/SQL simple for-loop cursor param_play,
which includes an IN parameter, an OUT parameter,
and an IN OUT parameter author_exists1, procedure
author_exists2, and testing procedure
call_author_exists
that demonstrate exception handling in PL/SQL; uses
author table from
authors.sql insert_odetails, which includes
a user-defined exception; uses tables from
create-bks.sql
and pop-bks.sql exc_test1,
which demonstrates the "one-way" nature of exception
handling exc1,
that includes
a block nested within another block, both with exception
sections, to show how an exception raised by the inner
block can be handled by the outer block SELECT-INTO-assign-null question
count_empls empl_count