Quote:
Originally posted by Caspah
i have a question for anyone that knows sql cuz im a noob...
SQL> INSERT INTO IS_QUALIFIED
2 VALUES (1234, 'ISM 1234','1988-09-09');
VALUES (1234, 'ISM 1234','1988-09-09')
*
ERROR at line 2:
ORA-01861: literal does not match format string
How can i fix this error with inserting the date as a value?
I appreciate any help anyone can give.
|
the problem is you haven't told it what columns to put the values in. It should look like this:
INSERT INTO IS_QUALIFIED (name, of, each, column)
VALUES (1234, 'ISM 1234','1988-09-09');
the names of each column should come in the first set of parentheses (don't forget the commas), and then the proper values in the SAME ORDER come in the second set of parentheses.