Answer Posted / nishi
Declare section
---
declaring the variables
---
Begin section
---
executable statements
---
Exception section
---
exception handlers
---
end;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the purpose of %type and %rowtype data types?
What is pragma in pl sql?
How do I find duplicates in a single column in sql?
What is rownum?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
How to read xml file in oracle pl sql?
what is the difference between char_length and length? : Sql dba
what is 'mysqlcheck'? : Sql dba
What are the disadvantages of not performing database normalization?
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
How does postgresql compare to "nosql"?
What is the difference between mdf and ndf files?
Difference between truncate, delete and drop commands?
What is pls integer?
What is numeric function sql?