What are the components of a PL/SQL block ?

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


Please Help Members By Posting Answers For Below Questions

Why should I use postgresql?

763


What is a design view?

700


What does select * from mean in sql?

2540


What is pl sql package?

795


What are the basic sql commands?

746






how to do backup entire database? : Transact sql

882


Write a query to find the names of users that begin with "um" in sql?

703


Can we use pl sql in mysql?

711


What are its different types of dbms?

715


How do you run a query?

768


What are sql objects?

738


a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

1950


What are literals in sql server?

738


What is normalization in sql?

718


What is raw datatype in sql?

725