Interested to Buy Any Domain ? << Click Here >> for more details...
What are the components of a PL/SQL block ?
- 3 Answers
- 12608 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / a.jyothsna
Declare section
---
declaring the variables
---
Begin section
---
executable statements
---
Exception section
---
exception handlers
---
end;
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / nishi
Declare section
---
declaring the variables
---
Begin section
---
executable statements
---
Exception section
---
exception handlers
---
end;
| Is This Answer Correct ? | 1 Yes | 0 No |
declare
cursor
user defined exception
variable
begin
sql statement
plsql statement (application wise/business logic)
exception
end;
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain ddl statements in pl/sql?
What is coalesce sql?
What are the different sql languages?
define sql insert statement ? : Sql dba
What do you think about pl/sql?
Types of locks in database ?
What are the different type of joins in sql?
What does the acronym acid stand for in database management?
Does varchar need length?
What is sorting in sql?
What is lexical units in pl sql?
When is the update_statistics command used?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
