Answer / kiran

CREATE [OR REPLACE] FUNCTION function_name
[(parameter_name [IN | OUT | IN OUT] type [, ...])]
RETURN return_datatype
{IS | AS}
BEGIN
< function_body >
Return value()
END [function_name];

Answer / tulsi

FUNCTION name (argument list .....) Return datatype is
local variable declarations
Begin
executable statements
Exception
execution handlers
End;

How to come back in normal stage in Mutating Table if mutating table is locked or update data?

2 Answers  

---

How many joins in sql?

0 Answers  

---

scope of exception handling in plsql

4 Answers   Wipro,

---

what are the methods using performance tunning in sql and pl/sql

2 Answers  

---

Is there a 64 bit version of ssms?

0 Answers  

---

---

what happens if you no create privilege in a database? : Sql dba

0 Answers  

---

What is a mutating table

5 Answers   TCS, Tech Mahindra,

---

How many clustered indexes can be created on a table?

0 Answers  

---

How do you add a column to a table?

0 Answers  

---

what are the type of locks ? : Sql dba

0 Answers  

---

What is the cause of mutating table error and how can we solve it?

0 Answers  

---

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 Answers  

---