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

Is oracle a relational database?

916

How to use fetch statement in a loop?

1019

what are actual and formal parameters?

1104

Explain the use of control file?

1113

How are extents allocated to a segment?

1125

Explain oracle left join with an example?

1011

Explain coalesce function?

1201

What is memory advisor in Oracle?

1077

material view and view disadvantages?

1073

How do you store pictures in a database?

1005

What is a read write transaction in oracle?

1093

What is meant by a deadlock situation?

1109

What do you mean by a deadlock?

1065

Can we create trigger on materialized view in oracle?

992

What is a user account in oracle?

1121