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 is database white box testing and black box testing?

1157

---

What are the types of sql commands?

1157

---

How to rename a column in the output of sql query?

1124

---

is it possible to pass an object or table to a procedure as an argument?

1176

---

What is sqlcontext?

1145

---

What is the default isolation level in sql server? : Transact sql

1080

---

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1052

---

Explain what is a database?

1134

---

what are the different type of normalization? : Sql dba

1067

---

What is acid property in a database?

1086

---

What are conditional predicates?

1120

---

What is trigger in sql? Explain

1042

---

What is autocommit sql?

1042

---

What are the types of keys?

1063

---

Can one improve the performance of sql*loader? : aql loader

1099

---