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 many row comparison operators are used while working with a subquery?

529

---

What is meant by truncate in sql?

520

---

Can we commit inside a trigger?

543

---

What is a unique key and primary key and foreign key?

565

---

What is dml statement?

513

---

---

Explain the the delete statements in sql?

573

---

What is trigger in sql? Explain

530

---

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

663

---

How to display Row Number with Records in Oracle SQL Plus?

586

---

Is nosql relational?

544

---

Explain what is a database?

643

---

Which is better varchar or nvarchar?

541

---

What is pivot query?

591

---

Why we use sql profiler?

556

---

What is sql query optimization?

541

---