What are the components of a PL/SQL block ?
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 |
give the syntax of grant and revoke commands? : Sql dba
write sub query for eliminating duplicate rows using analytical function?
how to enter numeric values as hex numbers? : Sql dba
Is it possible to create the following trigger: before or after update trigger for each row?
What is pl/sql and what is it used for?
Explain isolation levels. : Transact sql
What is a natural join sql?
How to add Foreign key in a table after the creation of the table?
What language is oracle sql developer?
What is an example of translating a date into julian format?
What is a system versioned table?
what is the difference between the query and corelated query
8 Answers HSBC, IBM, TCS, Xenosoft,
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)