Wm Allen Smith
asked on
Sql Developer Oracle12 c--not enough values
Hi
I am getting a "not enough values" error in SQL developer. I am trying to enter three user-prompted values into a table that contains five fields. Here is the query:
INSERT INTO APPEALS (APPEAL_ID, CRIME_ID,FILING_DATE, HEARING_DATE, STATUS)
VALUES '', &CRIME_ID, &FILING_DATE 'MM-DD-YYYY' , &HEARING_DATE 'MM-DD-YYYY','';
Appeal_Id is a sequence value; &CRIME_ID, &FILING_DATE, &HEARING_DATE are substitution variables.
What am I doing wrong here? Any help would be appreciated.
Thanks!
I am getting a "not enough values" error in SQL developer. I am trying to enter three user-prompted values into a table that contains five fields. Here is the query:
INSERT INTO APPEALS (APPEAL_ID, CRIME_ID,FILING_DATE, HEARING_DATE, STATUS)
VALUES '', &CRIME_ID, &FILING_DATE 'MM-DD-YYYY' , &HEARING_DATE 'MM-DD-YYYY','';
Appeal_Id is a sequence value; &CRIME_ID, &FILING_DATE, &HEARING_DATE are substitution variables.
What am I doing wrong here? Any help would be appreciated.
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER