What are the components of a PL/SQL block ?

Answer Posted / a.jyothsna

Declare section
---
declaring the variables
---
Begin section
---
executable statements
---
Exception section
---
exception handlers
---
end;

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mdb stand for?

556


What does the file extension accdb stand for?

548


Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

1678


What is sql scripting?

563


Define commit?

549






What are different types of sql commands?

514


Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

548


Is there a way to automate sql execution from the command-line, batch job or shell script?

557


How do you create a unique index?

573


What are sql built in functions?

509


What is cursor in pl sql with examples?

481


What is sqlite used for?

531


Difference between truncate, delete and drop commands?

559


what are the 'mysql' command line arguments? : Sql dba

652


Which are the different types of indexes in sql?

563