OCIStatementType
(PHP 4, PHP 5, PECL oci8:1.0-1.2.4)
OCIStatementType — OCI 구문(statement)의 타입을 리턴한다.
Description
string OCIStatementType
( int $stmt
)
OCIStatementType() 함수는 다음중 하나를 리턴한다:
- "SELECT"
- "UPDATE"
- "DELETE"
- "INSERT"
- "CREATE"
- "DROP"
- "ALTER"
- "BEGIN"
- "DECLARE"
- "UNKNOWN"
Example#1 Code examples
<?php
print "<HTML><PRE>";
$conn = OCILogon("scott","tiger");
$sql = "delete from emp where deptno = 10";
$stmt = OCIParse($conn,$sql);
if ( OCIStatementType($stmt) == "DELETE" ) {
die "You are not allowed to delete from this table<BR>";
}
OCILogoff($conn);
print "</PRE></HTML>";
?>