SIMPLE_SQL_NAME v17
The SIMPLE_SQL_NAME function determines whether the input is a simple SQL name.
SIMPLE_SQL_NAME(str VARCHAR2) RETURN VARCHAR2;
Parameters
str
The input string. White space is trimmed from the string. Mixed case is allowed. A quotation mark is allowed within the string.
Examples
edb=# SELECT SYS.DBMS_ASSERT.SIMPLE_SQL_NAME('ABCD789$#_zxcvbnm') FROM DUAL; simple_sql_name ------------------- ABCD789$#_zxcvbnm (1 row) edb=# SELECT SYS.DBMS_ASSERT.SIMPLE_SQL_NAME('"12 valid name"') FROM DUAL; simple_sql_name ----------------- "12 valid name" edb=# SELECT dbms_assert.simple_sql_name(' sch1.a1 '); ERROR: invalid SQL name (1 row)
- On this page
- Parameters
- Examples