Answer Posted / sudhakar naraparaju

I created a test package and executed.

create or replace package test is
procedure p1(v1 in Varchar);
Procedure p2(v2 in varchar2);
procedure p3(v3 in char);
end;
/

create or replace package body test is
procedure p1(v1 in Varchar) is

begin
dbms_output.put_line(' The input data for v1 is: '||v1);
end;

Procedure p2(v2 in varchar2) is

begin
dbms_output.put_line(' The input data for v2 is: '||v2);
end;

procedure p3(v3 in char) is
begin
dbms_output.put_line(' The input data for v3 is: '||v3);
end;

end;
/

I called each procedure in sql by setting the serveroutput
on:

begin
test.P3('Testing Procedure P3');
end;

I got the below output:
The input data for v1 is: Testing Procedure P1
The input data for v2 is: Testing Procedure P2
The input data for v3 is: Testing Procedure P3

what is bcp? When is it used?

1090

---

What are primary key and foreign key and how they work?

960

---

Does truncate table reset auto increment?

977

---

What is nosql vs sql?

1154

---

Can we edit a view in sql?

962

---

What are conditional predicates?

1031

---

Explain the working of primary key?

1073

---

what are the type of locks ? : Sql dba

944

---

What is a natural join?

1045

---

Is left join faster than join?

1033

---

What is right join in sql?

1075

---

how many ways to get the current time? : Sql dba

988

---

Where is sql database stored?

959

---

What are packages in pl sql and also explain its advantages?

1012

---

What is the purpose of cursors in pl/sql?

1122

---