An In_condition is a membership condition. it tests a value for membership in a list of values or
subquery.
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...
Tuesday, March 8, 2016
Boolean Exception In PLSQL
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
...
