Question
I am trying to run some INSERT INTO SQL command in OpenOffice Base and i get the error message below 1: Wrong data type: java.lang.IllegalArgumentException)
I am trying to run some INSERT INTO SQL command in OpenOffice Base and i get the error message below
1: Wrong data type: java.lang.IllegalArgumentException)
The Create table code is as below:
create table Books
(
BookId integer PRIMARY KEY,
SequenceNumber integer,
Title char(50),
ISBN char(14),
Author char(30),
cost decimal(7,2),
publication_date date
);
And the INSERT INTO commands are:
insert into Books values(1,1,'Alice in Wonderland','1441435840','Lewis Corell',7.95,'5/1/1997');
insert into Books values(2,1,'A First Course in Database Systems','978-0136006374','Jeffrey Ullman',99.49,'10/6/2007');
insert into Books values(3,1,'Database Systems Concepts','978-0073523323','Abrahm Silberchatz',119.67,'01/27/2010');
Any advice?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started