Give the structure of the function ?

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


Please Help Members By Posting Answers For Below Questions

What are the qualities of 2nf?

541


What is sql comments?

648


Is sql harder than python?

602


What is the most restrictive isolation level? : Transact sql

554


Can function return multiple values in sql?

522






What is sql analyzer?

537


What are the different types of triggers?

589


Can you have more than one trigger on a table?

530


How many commands are there in sql?

545


How do you explain an index?

786


what is 'mysqlshow'? : Sql dba

582


GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

2567


What is record in pl sql?

589


What are triggers in sql?

578


Is it possible to link two groups inside a cross products after the cross products group has been created?

589