ORACLE-BASE - Web Scripting for Oracle (PHP, Perl, JSP and ASP): "Web Scripting for Oracle (PHP, Perl, JSP and ASP)
This article presents the basic syntax for several popular web scripting languages that connect to Oracle databases. All database requests are separated into subroutines and are performed against the SCOTT.EMP table using bind variables. The examples for each language have the same format:
* Accept a parameter called DEPTNO from the query string, or default the value if it is omitted.
* Connect to the SCOTT schema.
* Query records from the EMP table that match the specified DEPTNO.
* Insert a new employee and requery the data.
* Update an existing employee and requery the data.
* Delete an existing employee and requery the data.
* Disconnect from the database.
The output from the scripts is not well-formed HTML, as this would increase the size and complexity of each script.
* PHP
* Perl
* Java Server Pages (JSP)
* Active Server Pages (ASP)
* Expected Output"
