I want to findout whether a record for the given criteria exists or not in a table.
I have written the query like this
Select count(P_InvoiceID) into invoiceCount
where voucher.id = P_InvoiceID and voucher.scac = P_SCACCode;
But I do not require the count, just I want exist or not exist (boolean), Is there any other way of finding it out?