WE CAN RETURN MORE THAN ONE VALUE FOR A FUNCTION BY USING THE CONDITIONAL

How to return more than one value from a function?

Question Posted / vetrikumaran

11 Answers
30637 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / vetrikumaran

WE CAN RETURN MORE THAN ONE VALUE FOR A FUNCTION BY USING
THE CONDITIONAL IF STATEMENT..BUT ONLY ONE RETURN STATEMENT
CAN BE EXECUTED AT A TIME..

IN FUNCTION,BY DEFAULT IN PARAMETER MODE ONLY ALLOWED...

OUT PARAMETERS ARE NOT ALLOWED.

Is This Answer Correct ?

7 Yes

13 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the operators used in select statements?

1000

What is mutating trigger?

969

What is the use of <> sql?

931

List and explain the different types of join clauses supported in ansi-standard sql?

1300

What is a nested table in word?

909

what is the difference between blob and text? : Sql dba

961

What is secondary key?

880

what are the drivers in mysql? : Sql dba

982

Is sql sequential or random?

981

Why do we use function in pl sql?

1006

Are subqueries better than joins?

917

Can we write ddl statements in functions?

1051

How to Execute a Package in PL/SQL.?

1109

What is a ddl command?

1006

What does where 1 1 mean in sql?

979