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
How to connect the oracle server as sysdba?
What are the parameters that we can pass through a stored procedure?
What are the ansi data types supported in oracle?
Is truncate autocommit in oracle?
How do I manually uninstall oracle client?
How to change program global area (pga) in oracle?
Explain oracle insert into command?
what is the use of system.effective.date variable in oracle?
How can we find out the duplicate values in an oracle table?
What is the fastest query method to fetch data from the table?
What is oracle and what are its different editions?
Explain parameter file in oracle.
What is integrity and what is constraint??Explain with example
How to lock and unlock a user account in oracle?
Is there any function in oracle similar like group_concat of mysql?