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];

Determine if oracle date is on a weekend?

993

---

describe transaction-safe table types in mysql : sql dba

957

---

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1394

---

What is a rank in sql?

912

---

What is scalar function in sql?

987

---

Describe sql comments?

975

---

how can I make a script that can be bi-language (supports english, german)? : Sql dba

952

---

What sql does db2 use?

935

---

what is difference between delete and truncate commands? : Sql dba

1074

---

what is datawarehouse? : Sql dba

961

---

How can you view the errors encountered in a trigger?

922

---

What is dbo in sql?

928

---

Explain constraints in sql?

990

---

What is cursor and why it is required?

1117

---

What are the two characteristics of a primary key?

936

---