January 31, 2011

check errors in compiled code in toad

SELECT * FROM USER_ERRORS WHERE NAME='PACKAGE NAME';

No comments:

Post a Comment

Thanks for your comments submitted.,will review and Post soon! by admin.

COALESCE-SQL

Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...