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 rownum?

1030

---

How do I access sql anywhere database?

1017

---

How do you define a foreign key?

1059

---

What is the difference between rename and alias?

1380

---

How do I find sql profiler?

988

---

How do you add a column to a table?

1099

---

How to prepare for oracle pl sql certification?

1105

---

How many scalar data types are supported in pl/sql?

1101

---

Can we use insert statement in function?

1043

---

How to assign sql query results to pl sql variables?

1138

---

how to use 'mysql' to run sql statements? : Sql dba

1108

---

How do temporal tables work?

1015

---

What is a recursive join sql?

1108

---

What is anonymous block in sql?

1167

---

Why trigger is used in sql?

1012

---