Manual do PHP
Anterior |  | Próxima

# oci_statement_type

(PHP 5)

oci_statement_type -- Returns the type of an OCI statement

## Descrição

string oci_statement_type ( resource statement )

Returns the type of the provided OCI `statement`.

## Parâmetros

`statement`

  A valid OCI statement identifier.

## Valores de retornado

Returns the query type of`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. `CALL` (since PHP 5.2.1 and OCI8 1.2.3)

11. `UNKNOWN`

Returns `FALSE` on error.

## Exemplos

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

## Notas

> Nota: 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.

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