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 are sql functions? Describe the different types of sql functions?

1141

---

What are inner and outer joins examples of both?

955

---

How does pl sql work?

958

---

Mention what plvcmt and plvrb does in pl/sql?

1143

---

Explain aggregate functions are available there in sql?

1007

---

Compare sql & pl/sql

1134

---

Can sql developer connect to db2?

1043

---

What is difference between left and right outer join?

985

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2496

---

Enlist the characteristics of pl/sql?

1801

---

what is 'mysqlimport'? : Sql dba

1046

---

How would you pass hints to the sql processor?

980

---

Define select, insert, create, delete, update, drop keywords

1048

---

How can you select unique records from a table?

1075

---

What are all the common sql functions?

1023

---