Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, krishna.

Asked: October 30, 2016 - 5:07 am UTC

Last updated: October 30, 2016 - 10:02 am UTC

Version: 12

Viewed 1000+ times

You Asked

DBMS_ASSERT package is used in NDS to validate data and to prevent SQL injection attacks. What is the difference between QUALIFIED_SQL_NAME, SIMPLE_SQL_NAME and SQL_OBJECT_NAME? This is confusing. Please explain with practical examples.

and Connor said...

Tim Hall has a nice writeup on this

https://oracle-base.com/articles/10g/dbms_assert_10gR2



Is this answer out of date? If it is, please let us know via a Comment

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library