Answer / roopesh kumar

Yes we can write pl/sql code directly in package. This
process is known as package initialisation. In this we can
write the code direct in package body in the end of body.

Answer / a.jyothsna

In package body we can write ..
But in package specification also we can write

PL/SQL allocates memory for the variable's at runtime or at compile time

3 Answers  

---

what is difference between decode and case function?

2 Answers  

---

Write a query to display the current date in sql?

0 Answers  

---

How do you rank data in sql?

0 Answers  

---

What are sql queries used for?

0 Answers  

---

---

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---

What is procedure in pl sql?

0 Answers  

---

HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?

2 Answers  

---

what are ddl statements in mysql? : Sql dba

0 Answers  

---

How to convert ms-excel file to oracle table?

2 Answers  

---

How can I see all tables in sql?

0 Answers  

---

Is progress software supports to ( pl/sql )?

0 Answers  

---