Answer Posted / vipin kumar (m.c.a)

For calling both have the different method--
To call function

variablename:=functionname(arguments);

To call procedure

procedurename(argumentlist);

Are pl sql variables case sensitive?

1045

---

How can we implement rollback or commit statement in a trigger?

1034

---

Why sql query is slow?

997

---

what is sql profiler? : Sql dba

1041

---

What is the maximum number of triggers, you can apply on a single table?

998

---

What are the types of records?

988

---

What is difference between left and right outer join?

987

---

What is sql query limit?

978

---

Is sql easier than java?

1016

---

how to rename an existing table in mysql? : Sql dba

1064

---

What is field delimiter?

1048

---

What is the use of sqlerrd 3?

944

---

How can you fetch first 5 characters of the string?

1018

---

Why plvtab is considered as the easiest way to access the pl/sql table?

1216

---

how to calculate expressions with sql statements? : Sql dba

1034

---