Home > Contents > Index >
Template Tag TOC  |   Alpha TOC  |   Tag Family TOC  |   Purpose TOC  |   Annotated TOC  |   Index 

 

SQLEXP

Creates a string that can be used as part of an SQL WHERE clause.

Syntax

Parameters

OUTSTR (required)
Name of variable used to store resulting string.

TYPE (required)
Logical operator to use between relational comparison. Possible values are "AND" or "OR", and "IN".

VERB (required)
Relational operator to use. Possible values are:

STR (required)
A comma-separated list of items to test against a column name.

COLNAME (required)
Column name to use in relational comparison.

Description

The SQLEXP tag creates a string that can be used as part of an SQL WHERE clause. SQLEXP takes a comma-separated string of items and a column name and places a relational operator between each item/column name pair. A logical operator is placed between each item/column name comparison.

Note

Before using SQLEXP, you must set a variable called tablename. This enables SQLEXP to automatically quote values for text columns but not for numerical columns.

Error Numbers

The possible values of errno include:

Value
Description
-100
General error.
-103
Bad or missing table name.
-106
Bad column name.

Example

This example constructs a WHERE clause for use by EXECSQL.

This example for SQLEXP sets the variable mywhere to:

See Also

EXECSQL

  Home > Contents > Index >

Oracle XML Tag Reference
Copyright (c) 2013, 2016, Oracle and/or its affiliates. All rights reserved.