Answer Posted / roopesh kumar

Diff. B/W Procudure & Func......
(1) Proc. may or may not return value or more than one.
but func. must return a single value.
(2) We can call a func. in a select stmt. but func. should
only with IN parameter.
But we can't call a procedure inside a selct stmt.
because calling a procedure itself a PL/SQL block.

There is no too much diff. b/w proc. & func. but the thing
is that when we are looking to get back a single value we
should use func. in case of more than one then we should go
for proc.

Diff. b/w proc. & trigger..

(1) We have to call a proc. explicitly but trigger will
fire implicitly with assosiated event.

Can you select everything, but 1 or 2 fields, without writer's cramp?

984

---

What is a join query?

966

---

What is the difference between cross join and natural join?

1022

---

What is sqlerrd?

968

---

What are the two virtual tables available at the time of database trigger execution?

1222

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1040

---

Does sap use sql?

996

---

What is t sql used for?

1015

---

What is pls_integer in pl sql?

1106

---

What is use of trigger?

933

---

What is sql indexing?

1011

---

what are null values? : Sql dba

957

---

What are different types of keys?

1106

---

How can we find duplicate records in a table?

948

---

Does db2 use sql?

950

---