Tell Me Glossary

5.1 Overview of DBMS_ASSERT

Previous previous|next Next Page

DBMS_ASSERT is an Oracle-supplied PL/SQL package that contains functions that are specifically crafted to filter, sanitize, and validate Oracle identifiers.

ENQUOTE_LITERAL Encloses the string literal within single quotation marks Animation
SIMPLE_SQL_NAME Verifies that the string is a simple SQL name Animation

Rather than relying on public synonyms, always specify the SYS schema when you call DBMS_ASSERT.

Other than the two recommended functions stated above, DBMS_ASSERT also contains five more functions. For more details on this topic, see:
Oracle® Database PL/SQL Packages and Types Reference, DBMS_ASSERT