Executing Data Definition Language (DDL) statements
Data Definition Language (DDL) statements manage schema objects in the
database. DDL statements create new tables, drop old tables, and establish other
schema objects. They also control access to schema objects. For example:
Set OO4OSession = CreateObject("OracleInProcServer.XOraSession")
Set EmpDb = OO4OSession.OpenDatabase("ExampleDb", "scott/tiger", 0)
EmpDb.ExecuteSQL("create table employees (name VARCHAR2(20),
ssn VARCHAR2(12),
empno NUMBER(6),
mgr NUMBER(6),
salary NUMBER(6)")
EmpDb.ExecuteSQL("GRANT UPDATE, INSERT, DELETE ON employees TO
donna")
EmpDb.ExecuteSQL("REVOKE UPDATE ON employees FROM jamie")
DDL statements also allow you to work with objects in the Oracle database
server. For example:
Set OO4OSession = CreateObject("OracleInProcServer.XOraSession")
Set EmpDb = OO4OSession.OpenDatabase("ExampleDb", "scott/tiger", 0)
EmpDb.ExecuteSQL("create type person_t
as object ( name VARCHAR2(30),
ssn VARCHAR2(12),
address VARCHAR2(50))")
EmpDb.ExecuteSQL("create table person_tab OF person_t")