5.3 Choose a Verification Routine
After you determine the type of identifier you need to verify, use the following table to select the appropriate verification routine:
Identifier Type |
Verification Routine |
| SQL Literal | Verify whether the literal is a well-formed SQL literal by using DBMS_ASSERT.ENQUOTE_LITERAL. |
| Simple SQL Name | Verify the input string conform to the basic characteristics of a simple SQL name by using DBMS_ASSERT.SIMPLE_SQL_NAME.
|
Step 1 Decompose the qualified SQL name into its simple SQL names by using DBMS_Utility.Name_Tokenize(). Step 2: Verify each of the simple SQL names using DBMS_ASSERT.SIMPLE_SQL_NAME. |