declare v_foundrows boolean := false;begin for r in ( select * from employees where employee_id= &dno ) loop dbms_output.put_line(r.last_name || ' ' || r.salary); v_foundrows := true; end loop; if not v_foundrows then raise no_data_found; ...
Tuesday, March 8, 2016
IN clause IN SQL
An In_condition is a membership condition. it tests a value for membership in a list of values orsubquery.The Condition defined using in Operator is also known as the membership condition.In works with values of all data types..When we using character,dates or non alpha -numeric strings,the list items must be enclosed with single quotation marks For...
