QUALIFIED_SQL_NAME v17
The QUALIFIED_SQL_NAME function determines whether the input string is a qualified SQL name.
Use the following grammar to represent a qualified SQL name.
<simple qualified name> => <simple name> ['.' <simple name>] <dblink name> => <simple qualified name> ['@' <conn string>] <conn string> => <simple name> <qualified name> => <simple qualified name> ['@' <dblink name>]
Parameters
str
The input string. A quotation mark is allowed within the input string.
Examples
edb=# SELECT SYS.DBMS_ASSERT.QUALIFIED_SQL_NAME('schema_name."object_name"@dblink_name') FROM DUAL; qualified_sql_name --------------------------------------- schema_name."object_name"@dblink_name (1 row) edb=# SELECT SYS.DBMS_ASSERT.QUALIFIED_sql_name('こんにちは') FROM DUAL; qualified_sql_name -------------------- こんにちは (1 row) edb=# SELECT dbms_assert.qualified_sql_name('db1".etc"'); ERROR: invalid qualified SQL name
- On this page
- Parameters
- Examples