Manual do PHP
Anterior |  | Próxima

# oci_statement_type

(no version information, might be only in CVS)

oci_statement_type -- Returns the type of an OCI statement

## Description

string oci_statement_type ( resource statement)

oci_statement_type() returns the query type of statement `statement` as one of the following values:

1. `SELECT`

2. `UPDATE`

3. `DELETE`

4. `INSERT`

5. `CREATE`

6. `DROP`

7. `ALTER`

8. `BEGIN`

9. `DECLARE`

10. `UNKNOWN`

Parameter `statement` is a valid OCI statement identifier, returned from oci_parse().

Exemplo 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); ?>`

oci_statement_type() returns `FALSE` on error.

Anterior | Principal | Próxima
oci_set_prefetch | Acima | ocifetchinto