What does the DBMS_ASSERT.SIMPLE_SQL_NAME function do?

The DBMS_ASSERT.SIMPLE_SQL_NAME function validates whether the given input string is a simple SQL name. The DBMS_ASSERT.SIMPLE_SQL_NAME function does not check the length of the given input string.

Syntax:

DBMS_ASSERT.SIMPLE_SQL_NAME (string VARCHAR2 CHARACTER SET ANY_CS)
RETURN VARCHAR2 CHARACTER SET string%CHARSET;

where string is the input string.

The term ANY_CS allows any of the CLOB or NCLOB locators as input.

Note: When the input string is not a simple SQL name, the DBMS_ASSERT.SIMPLE_SQL_NAME function raises the ORA44003: string is not a simple SQL name exception.

• Previous Entry: What does the COUNT method do?
• Next Entry: What is a query string?