Hi everyone,
I am working on Oracle 11g DB and i am using plsql allround automation tool.
I am trying to pull the data where the credit card expiration date column has 00/0000
I tried to create the tables and insert the data but i am getting an error while i am inserting the data
create table payment
(contract number(10),
expiration_date date);
insert into payment values (100,00/00/0000);
and i am getting ORA-00932: inconsistent datatypes: expected Date got number
but when i enter the data like this insert into payment values (100,'01-JAN-2016'); it is successful
select * from payment
| CONTRACT | EXPIRATION_DATE |
1 | 100 | 1/1/2016 |
All i want is to pull the data where that card expiration date column is having 00/0000
Any help is great appreciated
Thank you guys.