No rows returned will raise Oracle Exception NO_DATA

what is the difference between no rows returned and null
returned?

Question Posted / suman rana

Answer Posted / suman rana

No rows returned will raise Oracle Exception NO_DATA_FOUND,
but Null returned will not raise this exception

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is blob data type in oracle?

1089

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1027

What is oracle analytical function?

1111

How to start a specific oracle instance?

1016

What is the difference between hot backup and cold backup in oracle?

999

How to build data dictionary view an new database?

990

How do I know if oracle is installed on windows?

909

Why packages are used in oracle?

1045

How can you merge two tables in oracle?

973

Is oracle a language?

925

Which are the five query types available in oracle?

934

How do I escape a reserved word in oracle?

1186

Explain the different normalization forms?

1055

How many types of tables are there in oracle?

1043

Why use resource manager in Oracle?

1090