Answer / deepu

functions and procedures are both pl/sql programs.
procedures performs a specific task,it takes parameters and
performs the actions.
functions are same as procedures except they wil return a
value.

Answer / manu sankar

Functions can be called inside a sql but procedures cannot

Answer / pr@$@d

Hi Raj ,

Nice answer,

We can use OUT,INOUT also in function but it is not
suggested by Oracle.

Thanks,
-Pr@$@d.
prasadreddi@ymail.com

Answer / raj dhar

Function :- Function always return one value.
Procedure :- Procedure may or may not be return value.

Function :- Function always required " RETURN " key word.
Procedure :- Procedure doesn't require " RETURN" key word.

Function :- Function we use parameter IN.
Procedure :- Procedure we use parameter IN,OUT,INOUT.

etc.

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

0 Answers   Oracle,

---

What is java oracle used for?

0 Answers  

---

How to convert raw data type into text in oracle? Explain

0 Answers  

---

Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.

1 Answers  

---

How do I call oracle stored procedures that take no parameters?

0 Answers  

---

Can group functions be mixed with non-group selection fields?

0 Answers  

---

can you call insert/update/delete in select statements. If yes how? If no what is the other way?

2 Answers  

---

where do i find oracle interview questions.

1 Answers  

---

What are synonyms used for ?

3 Answers  

---

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

0 Answers   Wipro,

---

Which Department has MOST NUMBER of employees?

8 Answers   IBM, LeadSquared, Mastek,

---

How to display First 4 rows From Database Table?

6 Answers  

---