Answer Posted / gvk

functions and procedures:
1.Functions Returns a value, procedure not return a value.
2.parsed & compiled at runtime, Procedure stored as a
pseudo code in database ie. Compiled form.
3.Cannot effect the state of database,sp effect the state
of database using Commit etc..
4.mainly used to compute the values, sp used to process the
tasks.
5.It can be invoked from sql statement :eg:select, sp can
not invoked.
6.it is not accept more than one argument.sp accept more
than one argument.

Trigger and procedure:

1.It is run Automatically , sp run it manually.
2.With in a trigger u can call the sp, with in a sp u can
not call the trigger.
3.when u r creating the trigger u have to identify event
and action of your trigger. not possible in sp.
4.Trigger not pass the arguments but sp pass the arguments.

What are few of the schema objects that are created using PL/SQL?

1027

---

How to select unique records from a table?

1051

---

What is hibernate and its relation to sql?

1116

---

How do I edit a stored procedure?

988

---

What is rank function in sql?

1018

---

How would you convert date into julian date format?

1000

---

Can you have more than one key in a database?

931

---

What do you mean by query optimization?

996

---

What is sql table?

962

---

How do you write an index?

962

---

How much ram can sql express use?

979

---

Write a unique difference between a function and a stored procedure.

991

---

how many tables will create when we create table, what are they? : Sql dba

1067

---

how to get a list of indexes of an existing table? : Sql dba

955

---

what is the difference between join and union? : Sql dba

1106

---