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 does the t-sql command ident_incr does? : Transact sql

1009

---

What is the sql case statement?

951

---

Can we use joins in subquery?

1085

---

What kind of join is join?

903

---

Does access use sql?

967

---

what is the difference between a web-garden and a web-farm? : Sql dba

1009

---

how many tables will create when we create table, what are they? : Sql dba

1018

---

What are the disadvantages of file system?

1162

---

What are sql objects?

1012

---

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

906

---

How exception is different from error?

969

---

How many types of relationship are there?

973

---

What is pl sql collection?

919

---

Why is a primary key important?

967

---

what is uncommittable transactions? : Transact sql

953

---