Insert, Update, Delete, Create and Drop OCI8 : Oracle : Databases PHP Source Code


PHP Source Code » Databases » Oracle »

 

Insert, Update, Delete, Create and Drop OCI8


Executing Data Definition Language (DDL) and Data Manipulation Language (DML)
statements, like CREATE and INSERT, simply requires a parse and execute:
$s = oci_parse($c1, "create table i1test (col1 number)");
oci_execute($s);

The only-run-once installation sections of applications should contain almost all the CREATE
TABLE
statements used. Applications in Oracle do not commonly need to create temporary
tables at run time. Use inline views, or join tables when required. Temporary tables are
expensive to create and have no statistics for the Oracle optimizer to evaluate.
<?
------
$s oci_parse($c1"create table i1test (col1 number)");
oci_execute($s);
-----
?>


HTML code for linking to this page:

Follow Navioo On Twitter

PHP Source Code

 Navioo Databases
» Oracle