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 are the string functions in sql?

971

---

What is full join?

949

---

What is normalization sql?

1050

---

What is mutating table error?

1175

---

what are the disadvantages of mysql? : Sql dba

1147

---

Why do we use joins?

1033

---

List the various privileges that a user can grant to another user?

1037

---

Explain the steps needed to create the scheduled job?

1036

---

What is difference between sql function and stored procedure?

1002

---

what is the stuff function and how does it differ from the replace function? : Sql dba

1043

---

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1095

---

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

1011

---

What is package in pl sql?

1012

---

Who developed sql?

1033

---

What are the indexing methods?

1040

---