Answer Posted / rat

Yes i am aggree with all three answers but there are
diffrent Scenarios.

you can not call a procedure in which dml ,ddl statement or
transaction controling statement is used.

you can all a procedure in which only select statement is
used.

please chekc if you dont have trust.

what are the difference between clustered and a non-clustered index? : Sql dba

1029

---

How do I audit the sql sent to the server?

1000

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1134

---

Difference between table function and pipelined function?

1013

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1159

---

What is the difference between in and between in sql?

1054

---

What if we write return in procedure?

1415

---

What is secondary key?

929

---

Why should I use postgresql?

1009

---

What is crud diagram?

936

---

How to run pl sql program in mysql?

1011

---

What is a function in oracle pl sql?

1029

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2015

---

How to use distinct and count in sql query? Explain

1011

---

Who is the owner of mysql database?

1053

---