Answer Posted / soujanya

See the example below...

create or replace procedure addn(a in number,b in number, c
out number)
is
begin
c:=a+b;
dbms_output.put_line(c);
end addn;

Now we can call the in and out parameters as

declare a variable for the out parameter as

var n number;
exec addn(5,10,:n);
print n;

What does varchar include?

952

---

Explain the commit statement.

1160

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

953

---

How do you respond to dementia behavior?

971

---

What is informix sql?

979

---

Can we join two tables without common column?

1005

---

Are subqueries better than joins?

976

---

How can you view the errors encountered in a trigger?

962

---

Explain dml and ddl?

996

---

Is a secondary key the same as a foreign key?

1038

---

What is sql and db2?

1008

---

Which kind of parameters cannot have a default value in pl sql?

1149

---

what happens if null values are involved in expressions? : Sql dba

1045

---

How to use boolean type in select statement?

1077

---

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1038

---