Implicit Cursor Example 1 SQL
In this example I will be showing Implicit Cursor
DECLARE v_deptno dept.deptno%TYPE; v_dname dept.dname%TYPE; v_loc dept.loc%TYPE; BEGIN SELECT * INTO v_deptno, v_dname, v_loc FROM dept WHERE deptno = 10; dbms_output.put_line(v_deptno||' '||v_dname||''||v_loc); EXCEPTION WHEN no_data_found THEN dbms_output.put_line('There is no matching row'); END; /
Tags: Implicit Cursor no_data_found Exception
Total Views: 674
My name is Jean-Mathieu
I created this website so other people could enjoy finding useful stuff easier. If you have any question do not hesitate to contact me.
|jean8mathieu||Created on 02/25/15|
Disclosure: We are a website that needs compensation to operate like any other website on the internet.
We may receive consideration for our reviews but we are totally unbiased and do not accept paid reviews or fake reviews claiming to be something they are not.