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;

what is the difference between implicit conversions and explicit conversions?

2 Answers  

---

What is sqlcommand?

0 Answers  

---

Why truncate is used in sql?

0 Answers  

---

What is full form of rtm?

0 Answers  

---

select top 3 sal from each dept?

17 Answers   IBM, TCS,

---

What is a temporal data type?

0 Answers  

---

What are the two parts of design view?

0 Answers  

---

Is it important to partition hard disk?

0 Answers  

---

Which sql statement is used to delete data from a database?

0 Answers  

---

What is user define exception and example

1 Answers   HP, KP,

---

What is clause?

0 Answers  

---

Is primary key a clustered index?

0 Answers  

---