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 are different clauses used in sql?

1172

---

What are the advantages of normalization?

1129

---

What is the size of partition table?

1088

---

How do I install sql?

1045

---

What are the types of optimization?

1008

---

What is before trigger?

1049

---

how can you create an empty table from an existing table? : Sql dba

1195

---

What does closing a cursor do?

1372

---

What is crud diagram?

993

---

What is %type in pl sql?

1008

---

How many clustered indexes can be created on a table?

1122

---

What does sign mean sql?

1181

---

What is a database event trigger?

1210

---

Is inner join same as self join?

1166

---

How do I know if I have sql express or standard?

1063

---