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
How can I get the number of records affected by a stored procedure?
Where the sql database files are stored?
List the ways to get the count of records in a table?
What are the three pl sql block types?
Which data type is a composite type?
What is update query?
How many tables can a sql database have?
What is Collation Sensitivity ? What are the various type ?
How can you select unique records from a table?
How to handle bulk data?
Show the two pl/sql cursor exceptions.
what is self join and what is the requirement of self join? : Sql dba
what is sql? : Sql dba
Can we create a trigger on view?
What is indexing in sql and its types?