Answer:
see explaination
Explanation:
SCRIPT :
drop table Vendor;
create table Vendor (VendorName varchar2(20), InvoiceNumber number (20), InvoiceDueDate date, Balance number(32,6));
insert into VENDOR (VENDORNAME,INVOICENUMBER,INVOICEDUEDATE,BALANCE) values ('ABC',121,TO_TIMESTAMP('01-01-18','DD-MM-RR HH12:MI:SSXFF AM'),1000);
Insert into Vendor (VENDORNAME,INVOICENUMBER,INVOICEDUEDATE,BALANCE) values ('XYZ',1212121,to_timestamp('02-01-18','DD-MM-RR HH12:MI:SSXFF AM'),100000);
declare
cursor c1 is select * from Vendor;
begin
for i in c1
loop
if I.BALANCE < 1001 then
DBMS_OUTPUT.PUT_LINE('Vendor Name '||I.VENDORNAME||', Invoice Number '||I.INVOICENUMBER||', Invoice DueDate '||I.INVOICEDUEDATE||',BALANCE '||I. BALANCE);
else
dbms_output.put_line('Vendor Name '||i.VendorName||', Invoice Number '||i.InvoiceNumber||', Invoice DueDate '|| i.InvoiceDueDate||' Balance due is less than $1000');
end if;
end LOOP;
end;
output : SCRIPT OUTPUT
table VENDOR dropped.
table VENDOR created.
1 rows inserted.
1 rows inserted.
anonymous block completed
dbms output :
Vendor Name ABC, Invoice Number 121, Invoice DueDate 01-JAN-18,BALANCE 1000
Vendor Name XYZ, Invoice Number 1212121, Invoice DueDate 02-JAN-18 Balance due is less than $1000
