The Statement object represents a single SQL statement. A Statement is always
instantiated by the SQL object which adds it to the Statements
collection. Use the Excecute method to execute the statement.
Depending on the type of Statement there are additional properties and methods.
To find the type of Statement use the TypeName function on the Statement object.
The Statement Types available are:
A SQL*Plus statement ; e.g. column empno format
00000;
Properties:
Name
Data Type
Description
Index
As Long
The index of this Statement Object in the SQL.Statements
collection.
Text
As Text
The text of the SQL Statement
Methods:
Name
Data Type
Description
Execute
Executes the SQL Statement.
Example:
Select Case TypeName(SQL.Statements(2))
Case "clsStmtDQL": Msgbox "This is a select statement"
Case "clsStmtPLSQL":
Msgbox "This is a PL/SQL statement" End Select
Copyright (C) 1995-2007 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.
sitemap
