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

What is difference between TRUNCATE & DELETE?

16 Answers   Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,

---

Why we use cross join?

0 Answers  

---

When are we going to use truncate and delete?

0 Answers  

---

TABLE A TABLE B EMPNO ENAME EMPNO ENAME 1 A 1 A 2 B 2 B 3 C 3 C 4 D 4 D 5 E 5 E 6 F 7 G HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?

10 Answers   Satyam,

---

what is the output of this query selet * from employee where 1=2 ??

11 Answers  

---

What is bulk collections?

2 Answers  

---

Why is the cursor important?

0 Answers  

---

Where is all the data on the internet stored?

0 Answers  

---

What are %type and %rowtype for?

0 Answers  

---

What is difference between a PROCEDURE & FUNCTION ?

6 Answers   Satyam,

---

describe transaction-safe table types in mysql : sql dba

0 Answers  

---

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

9 Answers   Zensar,

---