List of Embedded SQL statements supported by Pro*C :

List of Embedded SQL Statements Supported by Pro*C

Declarative Statements
EXEC SQL ARRAYLEN	To use host arrays with PL/SQL
EXEC SQL BEGIN DECLARE SECTION EXEC SQL END DECLARE SECTION	To declare host variables
EXEC SQL DECLARE	To name Oracle objects
EXEC SQL INCLUDE	To copy in files
EXEC SQL TYPE	To equivalence datatypes
EXEC SQL VAR	To equivalence variables
EXEC SQL WHENEVER	To handle runtime errors
Executable Statements
EXEC SQL ALLOCATE	To define and control Oracle data
EXEC SQL ALTER
EXEC SQL ANALYZE
EXEC SQL AUDIT
EXEC SQL COMMENT
EXEC SQL CONNECT
EXEC SQL CREATE
EXEC SQL DROP
EXEC SQL GRANT
EXEC SQL NOAUDIT
EXEC SQL RENAME
EXEC SQL REVOKE
EXEC SQL TRUNCATE
EXEC SQL CLOSE
EXEC SQL DELETE	To query and manipulate Oracle data
EXEC SQL EXPLAIN PLAN
EXEC SQL FETCH
EXEC SQL INSERT
EXEC SQL LOCK TABLE
EXEC SQL OPEN
EXEC SQL SELECT
EXEC SQL UPDATE
EXEC SQL COMMIT	To process transactions
EXEC SQL ROLLBACK
EXEC SQL SAVEPOINT
EXEC SQL SET TRANSACTION
EXEC SQL DESCRIBE	To use dynamic SQL
EXEC SQL EXECUTE
EXEC SQL PREPARE
EXEC SQL ALTER SESSION	To control sessions
EXEC SQL SET ROLE
EXEC SQL EXECUTE END-EXEC	To embed PL/SQL blocks