image

exact fetch returns more than requested number of rows

Problem : DECLARE empname VARCHAR2(200); BEGIN select ENAME into empname from emp where dept_id=20; END; / Reason : The above code returns the multiple rows , here the select into statements accepts only one row. i.e A┬áSELECT INTO┬ástatement will throw an error if it returns anything other than 1 row. If it returns 0 rows, … continue reading

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube