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 the use of system.effective.date variable in oracle?

1161

How to use "startup" command to start default instance?

1095

What happens to the current transaction if a ddl statement is executed?

1057

Point the difference between translate and replace?

1146

How many anonymous blocks can be defined?

1247

Write a syntax for update query in oracle?

1071

How different is ms access and oracle?

1086

Explain oracle’s server parameter file.

1037

What is translate in oracle?

1140

How to create an initialization parameter file?

1100

How does the on-delete-cascade statement work?

1158

How to enter a new row into a table interactively?

1048

How to define an explicit cursor in oracle?

1090

How to install oracle odbc drivers?

1135

Is the After report trigger fired if the report execution fails ?

2950