Answer Posted / alok sinha

Hello Boyz !!

Get excited to see this example thru

declare
--
varx1 number := 0;
varx2 number := 0;
varx3 number := 3;
--
begin
--
--
dbms_output.put_line('In: Varx #1 : initial value :: ' ||
varx1);
dbms_output.put_line('In: Varx #2 : initial value :: ' ||
varx2);
--
dbms_output.put_line('In: Varx #3 : Initial value :: ' ||
varx3);
dbms_output.put_line('

');
dbms_output.put_line('Hhhmmmnnn
Hhhmmmnnn Hhhmmmnnn ');
dbms_output.put_line('

');
--
--
varx3 := xx_func(varx3, varx1, varx2);
--
--
dbms_output.put_line('------------------------------------
--------------');
dbms_output.put_line('---------- Post Function -----------
------');
dbms_output.put_line('------------------------------------
--------------');
dbms_output.put_line('

');
dbms_output.put_line('------------------------------------
--------------');
dbms_output.put_line('Return Value :: Varx #3 :: returned
from function :: '|| varx3);
dbms_output.put_line('Out: Varx #1 : returned from
function :: '|| varx1);
dbms_output.put_line('Out: Varx #2 : returned from
function :: '|| varx2);
--
end;


create or replace function xx_func(north in number, east in
out number, west in out number ) return number is
south number;
begin
south := north + 4;
east := 4;
west := 5;
--
return south;
end xx_func;

How can you fetch common records from two tables?

589

---

How many types of literals are available in pl sql?

516

---

Who is the owner of mysql database?

553

---

How we can update the view?

602

---

What is embedded sql in db2?

507

---

---

What is clause?

609

---

Is pl sql a scripting language?

591

---

Does inner join remove duplicates?

522

---

What is procedure explain with example?

542

---

What is oracle pl sql developer?

532

---

what are the advantages and disadvantages of views in a database? : Sql dba

532

---

how can we find the number of rows in a table using mysql? : Sql dba

586

---

What are the set operators in sql?

558

---

Are subqueries faster than joins?

577

---

how to use 'mysql' to run sql statements? : Sql dba

539

---