Answer Posted / 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];

what is a view? : Sql dba

828

---

What do you mean by stored procedures? How do we use it?

739

---

What is sql constant?

703

---

Why triggers are used?

769

---

What is where clause in sql?

767

---

What is sql indexing?

772

---

What is a rank in sql?

728

---

Is pl sql still used?

712

---

what is commit? : Sql dba

841

---

how to convert numeric values to character strings? : Sql dba

795

---

How to fetch alternate records from a table?

907

---

Does access use sql?

767

---

What are different types of keys?

767

---

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

810

---

What is sql server and ase?

737

---