What are the blocks in stored procedure?
Answer Posted / sachin
create /alter proc nameof procedure
as/is
beging
statment
EXCEPTION
end
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the working of primary key?
What is rank dense_rank and partition in sql?
Why function is used in sql?
State some properties of relational databases?
What is trigger in sql? Explain
What plvcmt and plvrb does in pl/sql?
What is crud sql?
What is data definition language?
How do you modify a column in sql?
What is online transaction processing (oltp)?
List different type of expressions with the example.
Why is normalization important?
Can we use the cursor's to create the collection in PL/SQL?
what is text? : Sql dba
What is relationship? How many types of relationship are there?