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 trigger explain with example?

1016

---

How do we use distinct statement? What is its use?

1013

---

Should I use mbr or gpt?

1011

---

How do I remove all records from a table?

1062

---

How to return multiple rows from the stored procedure?

953

---

How does left join work in sql?

985

---

What are the possible values that can be stored in a boolean data field?

984

---

How can we solve sql error: ora-00904: invalid identifier?

1235

---

Can unique keys be null?

883

---

Is the primary key an index?

1018

---

How do you modify a trigger?

914

---

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1022

---

Can we use distinct and group by together?

1025

---

What is a temp table?

1002

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

949

---