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;

Which kind of parameters cannot have a default value in pl sql?

0 Answers  

---

Explain Connect by Prior?

2 Answers  

---

Is it possible to include an insert statement on the same table to which the trigger is assigned?

0 Answers  

---

What is bulk collect in pl sql?

0 Answers  

---

cursor types? explain with example programs?

1 Answers   HP,

---

When do we use triggers?

0 Answers  

---

How to execute OS(operating system) command from pl/sql?

3 Answers  

---

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

0 Answers  

---

What does the argument [or replace] do?

0 Answers  

---

Can we call a function containing dml statements in a select query?

0 Answers  

---

What is user defined functions?

0 Answers  

---

What is oracle sql developer?

0 Answers  

---