Answer Posted / rahul khanke
pre defined exception u should not have to declare in
declare section
ex. dul_value_error
when_duplicate_row
etc
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain the purpose of %type and %rowtype data types with the example?
Explain the advantages and disadvantages of stored procedure?
List and explain the different types of join clauses supported in ansi-standard sql?
Does truncate need commit?
How do sql databases work?
How to fetch alternate records from a table?
Can we create table inside stored procedure?
What are primary key and foreign key and how they work?
What is the difference between count 1 and count (*) in a sql query?
Why is a primary key important?
what are the drivers in mysql? : Sql dba
Can you have more than one trigger on a table?
what are wild cards used in database for pattern matching ? : Sql dba
What are the basic sql commands?
What jobs use sql?