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.

What is sql select statement?

503

---

What is sql injection vulnerability?

494

---

what is a record in a database ? : Sql dba

566

---

Can we commit inside a trigger?

547

---

How do I filter in sql profiler?

534

---

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

555

---

What is auto increment in sql?

583

---

What is primary key secondary key alternate key candidate key?

542

---

What is query syntax?

519

---

describe mysql connection using mysql binary. : Sql dba

550

---

What is sql rowcount?

554

---

How do you update a table in sql?

519

---

how to enter binary numbers in sql statements? : Sql dba

487

---

How do you write an index?

524

---

Can a foreign key be null?

586

---