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.

i have some prob lem to tell me about my self in interview first round ...

2151

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

949

---

what are the security recommendations while using mysql? : Sql dba

1095

---

Explain the savepoint statement.

1082

---

What is gpt format?

929

---

how to drop an existing view in mysql? : Sql dba

1042

---

Is primary key always clustered index?

993

---

How delete all data from table in sql?

1004

---

what is 'mysqladmin' in mysql? : Sql dba

1010

---

Explain the types of joins in sql?

1015

---

What is cost in sql execution plan?

964

---

What is the difference between left outer join and left join?

977

---

how to extract a unit value from a date and time? : Sql dba

979

---

What is a constraint?

998

---

What plvcmt and plvrb does in pl/sql?

1294

---