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 db journal file?

1064

---

Explain what is an index?

1055

---

Explain the update statement in sql

990

---

What is indexes?

1056

---

What kind of join is join?

966

---

What are the different types of triggers?

1136

---

What does the sign mean in sql?

989

---

Can a foreign key have a different name?

940

---

What has stored procedures in sql?

1064

---

Explain locks? : Transact sql

1002

---

Why we use join in sql?

966

---

How does a trigger work?

1066

---

What are different types of tables in sql?

998

---

What is sql performance tuning?

917

---

What is PL/SQL Records?

1189

---