select statement does not retrieve any records. what
exception is raised?

Answer Posted / madhu

Here two ways is there
you are using single select statement it display no rows
selected message.

If you are using in PL/SQL BLOCK at that time it raise the
error

NO_DATA_FOUND( IF YOU DECLARED) OTHER WISE IT GO FOR
WHEN OTHERS_THEN EXCEPTION HANDER.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why use resource manager in Oracle?

887


What is a cursor variable?

822


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

790


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

1953


What do you understand by a database object? Can you list a few of them?

810


What is a server parameter file in oracle?

820


What is coalesce function?

804


What is procedure overloading in oracle?

807


What is raw datatype in oracle?

844


What are the numeric comparison operations?

879


How to open and close an explicit cursor in oracle?

823


How to download oracle database 10g xe?

804


What is connection pool in oracle?

770


Where is the export dump file located?

825


What is the difference between I and G in Oracle?

826