Skip Headers
Oracle® OLAP DML Reference
11g Release 2 (11.2)

E17122-08
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

EXISTS

The EXISTS function determines whether an object is defined in any attached workspace. The EXISTS function is useful in a program to test whether a definition exists before you try to use it.

Return Value

BOOLEAN

Syntax

EXISTS(name-expression)

Parameters

name-expression

A text expression that specifies the name you want to test.

Usage Notes

Specifying More Than One Name

When name-expression contains multiple object names, EXISTS returns NO even when all the objects specified by name-expression exist in attached workspaces.

Examples

Example 7-79 Using EXISTS

This example tests whether the variable actual has been defined in any attached workspace. The statement

SHOW EXISTS('actual')

produces the following result.

YES