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);

What is a loop in sql?

935

---

Which is faster subquery or join?

1144

---

what is cursor. write example of it. What are the attributes of cursor.

1309

---

What is a delimiter in sas?

978

---

what is the difference between sql and t-sql? : Transact sql

1040

---

What is oracle pl sql developer?

933

---

What is thread join () in threading?

944

---

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1041

---

Define concurrency control. : Transact sql

1102

---

Is and as keyword in pl sql?

904

---

What is %rowtype in pl sql?

923

---

What is pl/sql language case sensitive?

1059

---

Is sqlexception checked or unchecked?

918

---

Why do we need pl sql?

934

---

Explain what is an index?

999

---