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

Can there be 2 primary keys in a table?

997

---

How many unique keys can a table have?

1016

---

what are the 'mysql' command line arguments? : Sql dba

1139

---

What are keys in sql?

1000

---

What is inner join in sql?

1082

---

What is partition in sql query?

999

---

What is an inner join sql?

1029

---

What do you mean by “trigger” in sql?

1081

---

What is the difference among union, minus and intersect?

1001

---

Which tcp/ip port does sql server run?

1009

---

What do you mean by stored procedures?

1014

---

Explain the savepoint statement.

1099

---

Explain character-manipulation functions?

1134

---

What is application trigger?

1001

---

Can we use pl sql in sql server?

1084

---