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

How do you explain an index?

778

---

How many sql statements are used? Define them.

566

---

Does asenumerable execute the query?

589

---

What is self-join and what is the requirement of self-join?

622

---

what is bdb (berkeleydb)? : Sql dba

555

---

---

How to run sql functions in pl/sql?

531

---

What are the subsets of sql?

541

---

Name the operator which is used in the query for pattern matching?

496

---

what is a trigger in mysql? Define different types of trigger. : Sql dba

542

---

what is auto increment? : Sql dba

563

---

what does myisamchk do? : Sql dba

550

---

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

535

---

What are aggregate functions in sql?

617

---

Explain commit, rollback and savepoint.

596

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

3181

---