Answer Posted / ramesh

Nothing Happend package body created with no  errors.
Ex:
 create or replace package jan
 is
 procedure sp1;
 procedure sp2;
 end;
PACKAGE CREATED

 create or replace package body jan as
 procedure sp1 as
 begin
 dbms_output.put_line('hello');
 end;
 procedure sp2 as
 begin
 dbms_output.put_line('how are you');
 end;
 procedure sp3 as
 begin
 dbms_output.put_line('ok');
 end sp3;
 procedure sp4 as
 begin
 dbms_output.put_line('ramesh');
 end sp4;
 end;
PACKAGE BODY CREATED

What is the difference between alter trigger and drop trigger statements?

606

---

How bulk collect improves performance?

576

---

What is rowtype?

573

---

Can you selectively load only those records that you need? : aql loader

615

---

What is data control language?

535

---

---

What is normalization? How many normalization forms are there?

558

---

What is the use of sql trace?

484

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3550

---

What does joining a thread mean?

550

---

What is faster join or subquery?

514

---

Can we insert data into materialized view?

519

---

How do I run a sql trace?

526

---

What is Histogram?

1106

---

What are the uses of sysdate and user keywords?

633

---

How do I start sql profiler?

561

---