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;

Explain the rollback statement?

962

---

What is restrict in sql?

1031

---

Which one is faster ienumerable or iqueryable?

865

---

Is oracle sql free?

927

---

What happens when a trigger is associated to a view?

840

---

Enlist the data types that can be used in pl/sql?

1002

---

Does sql support programming?

1007

---

What is mutating sql table?

1039

---

how to drop an existing index in mysql? : Sql dba

1017

---

What is pl sql package?

991

---

What is the difference between cross join and natural join?

960

---

What is the main reason behind using an index?

965

---

Why do we use sql constraints? Which constraints we can use while creating database in sql?

972

---

What is auto increment feature in sql?

1067

---

Can we write dml inside a function in sql server?

899

---