Embedded SQL Statements
1. 의미
: SQL statements placed within an application program (Host program)
2. 분류
1) Executable statements
: SQLLIB를 실행시간에 호출하여, 오라클 DB 접속, 데이터 조작, Query,
데이터 접근 Control, 트랜잭션 처리등을 함.
2) Declarative statements
: 오라클 객체, SQLCA, SQL 변수 선언
|
DECLARATIVE STATEMENT |
PURPOSE |
|
ARRAYLEN* |
To use host arrays with PL/SQL |
|
BEGIN DECLARE SECTION* END DECLARE SECTION* |
To declare host variables (optional) |
|
DECLARE* |
To name Oracle schema objects |
|
INCLUDE* |
To copy in files |
|
TYPE* |
To equivalence datatypes |
|
VAR* |
To equivalence variables |
|
WHENEVER* |
To handle runtime errors |
|
EXECUTABLE STATEMENT |
PURPOSE |
|
ALLOCATE* ALTER ANALYZE AUDIT |
To define and control Oracle data |
|
CLOSE |
|
|
COMMENT |
|
|
CONNECT* |
|
|
CONTEXT |
|
|
CREATE |
|
|
DROP |
|
|
ENABLE THREADS |
|
|
FREE |
|
|
GRANT |
|
|
NOAUDIT |
|
|
RENAME |
|
|
REVOKE |
|
|
TRUNCATE |
|
|
DELETE DML |
|
|
EXPLAIN PLAN |
|
|
FETCH* |
|
|
INSERT |
|
|
LOCK TABLE |
|
|
OPEN* |
|
|
SELECT |
|
|
UPDATE |
|
|
COMMIT |
To process transactions |
|
ROLLBACK |
|
|
SAVEPOINT |
|
|
SET TRANSACTION |
|
|
DESCRIBE* |
To use dynamic SQL |
|
EXECUTE* |
|
|
PREPARE* |
|
|
ALTER SESSION |
To control sessions |
|
SET ROLE |
|
|
*Has no interactive counterpart | |
3. 사용
: EXEC SQL SQL statements;
: 모든 EXEC SQL 문은 SQLLIB 라이브러리에 대한 함수 Call로 바뀐다.
