NEWS: Total Picture Views: 146791 | Total Article Views: 155156 | Top 5 Most Popular Article: 1. Am I Stuck Algorithm with Becker Robot | 2. How to read a JSON and work with it | 3. PickUpThings with Becker Robot | 4. Encrypted Data GUI (Download .Zip) | 5. Create Wall and Things with Becker

Implicit Cursor Example 1 SQL

Description:

In this example I will be showing Implicit Cursor

Code:

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;
/
Attachments: None

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.

jean8mathieuCreated on 02/25/15


affiliate_link

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.