FUNCTION name (argument list .....) Return datatype is local variable decl

Give the structure of the function ?

Question Posted / tulsi

Answer Posted / tulsi

FUNCTION name (argument list .....) Return datatype is
local variable declarations
Begin
executable statements
Exception
execution handlers
End;

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Is foreign key mandatory?

556

What is difference between sql and excel?

515

How can you get sql*loader to commit only at the end of the load file? : aql loader

554

How to set up sql*plus output format in oracle?

596

What are different types of functions in sql?

511

What is mutating error?

509

What is sql resultset?

531

Which one is better sql or oracle?

500

Which is the correct statement about truncate and delete?

528

what is the syntax used for partition in tsql? : Transact sql

540

What is record data type?

516

How many disk partitions should I have?

551

How would you pass hints to the sql processor?

530

What are literals in sql server?

534

Is pl sql better than sql?

550