SEO Services
Website Programming in PHP / MYSQL
oci_statement_type
(PHP 5, PECL oci8:1.1-1.2.4)
oci_statement_type — Returns the type of an OCI statement
Description
string oci_statement_type
( resource $statement
)
Returns the type of the provided OCI statement .
Parameters
- statement
-
A valid OCI statement identifier.
Return Values
Returns the query type ofstatement as one of the following values:
- SELECT
- UPDATE
- DELETE
- INSERT
- CREATE
- DROP
- ALTER
- BEGIN
- DECLARE
- CALL (since PHP 5.2.1 and OCI8 1.2.3)
- UNKNOWN
Examples
Example #1 oci_statement_type() example
<?php
$conn = oci_connect("scott", "tiger");
$sql = "delete from emp where deptno = 10";
$stmt = oci_parse($conn, $sql);
if (oci_statement_type($stmt) == "DELETE") {
die("You are not allowed to delete from this table<br />");
}
oci_close($conn);
?>
Notes
Note: In PHP versions before 5.0.0 you must use ocistatementtype() instead. This name still can be used, it was left as alias of oci_statement_type() for downwards compatability. This, however, is deprecated and not recommended.
