Answer Posted / tulsi
Raise_application_error is a procedure of package
DBMS_STANDARD which allows to issue an user_defined error
messages from stored sub-program or database trigger.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How many columns should be in an index?
What are different types of sql?
What is sql trigger example?
how can we know the number of days between two given dates using mysql? : Sql dba
What is the difference between microsoft access and sql server?
What is blind sql injection?
Define commit?
Define join and name different types of joins?
what is isam? : Sql dba
What is cold data?
Why we use pl sql?
Why do we use %rowtype & %type in plsql?
What is where clause in sql?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
Is pl sql better than sql?