Simple PL/SQL code to throw NO_DATA_FOUND exception

Background

Good database question for beginners.Write a simple PL/SQL code snippet to throw NO_DATA_FOUND exception. You cannot raise this exception. Maybe try to understand how the candidate answers this. Simple code is as follows - 

?

1 2 3 4 5 6

DECLARE    nowt VARCHAR(10); BEGIN    SELECT * INTO nowt FROM DUAL WHERE 1=0; END; /

and it should throw the exception - 

?

1 2 3 4 5 6 7 8 9 10 11 12

Error starting at line 8 in command: DECLARE    nowt VARCHAR(10); BEGIN    SELECT * INTO nowt FROM DUAL WHERE 1=0; END; Error report: ORA-01403: no data found ORA-06512: at line 4 01403. 00000 -  "no data found" *Cause:    *Action:

Related Links

• Database Normalization(OSFG)
• Declare variables in PL/SQL(OSFG)
• Basic PL/SQL syntax and query executions on Oracle 11g R2 database(OSFG)
• Difference between DML and DDL statements in SQL(OSFG)
• Simple PL/SQL code to throw NO_DATA_FOUND exception