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];
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can we avoid duplicating records in a query?
Why are sql stored procedures used?
What is mutating error in pl sql?
How can you tell the difference between an index and a view?
What are all different types of collation sensitivity?
What is parallel hint?
Give the order of sql select?
Why is nosql good?
What are the qualities of 2nf?
What is the difference between database trigger and stored procedure?
State few characteristics of pl/sql?
what is meant by urlencode and urldocode? : Sql dba
What are the types of keys?
how do you know if your mysql server is alive? : Sql dba
What is the sql query to display the current date?
