The SqlParser type exposes the following members.

Constructors

  NameDescription
Public methodSqlParser
Initializes a new instance of the SqlParser class

Methods

  NameDescription
Public methodStatic memberFixCommand
Parses the comma separated list of bind variables in the command string and builds a new command where the binds list uses the standard ':' marker for binds.
Public methodStatic memberFixList
Parses the comma separated list of bind variables and builds a new list using the standard ':' marker for binds.
Public methodParseInto
Parses into variables from the list.
Public methodParseSql
Parses into and bind variables out of the sql statement.

Properties

  NameDescription
Public propertyBindList
Returns the list of parsed bind variables.
Public propertyIntoList
Returns the list of parsed into variables.
Public propertyNamedParameters
Enables/Disables named parameters substitution.
Public propertyOptimizeParameters
Enables/Disables parameters optimization. When enabled, identical parameters (bind expressions) are parsed into a single Parameter instance.
Public propertyParametersPrefix
Returns/Sets the prefix to use with named parameters.
Public propertyRemoveInto
Enables/Disables extraction of the INTO clause.
Public propertySqlParsed
Set this property to tell the parser if it's a sql expression parsed or not. I.e. should function bind variables be parsed or not. This property is used from the Application Forms framework and set when SQL is executed rather than PL/SQL. We need this for optimizing parsing as we should not parse function parameters for sql statements.

See Also