What are the blocks in stored procedure?
Answer Posted / guest
Begin
--This section must contain atleast one executiable
statment.
Exception
end ;
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is the difference between count 1 and count (*) in a sql query?
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
What is rollback?
What is meaning of <> in sql?
Explain the advantages and disadvantages of stored procedure?
What does the file extension accdb stand for?
Can you join a table to itself?
Can we use joins in subquery?
Which sql statement is used to delete data from a database?
How do I view a sql database?
What is sqlca in db2?
what is a view? : Sql dba
Are sql database names case sensitive?
Which type of cursor is used to execute the dml statement?
Can we delete column in sql?