ORA-00933: SQL command not properly ended [message #675943] |
Wed, 01 May 2019 08:13 |
|
davethewelder
Messages: 3 Registered: May 2019
|
Junior Member |
|
|
Hi, just relearning sql and trying to update the First name, last name in the employees table but getting the error "ORA-00933: SQL command not properly ended" . Code below.
INSERT INTO employees (First_Name, Last_Name) VALUES
('Louise', 'Popp')
Where employee_id = '1';
I am stumped as to why. Can anyone explain my mistake?
Davie
|
|
|
|
|
Re: ORA-00933: SQL command not properly ended [message #675947 is a reply to message #675946] |
Wed, 01 May 2019 08:47 |
|
davethewelder
Messages: 3 Registered: May 2019
|
Junior Member |
|
|
Hi again, when I log into live sql i have to create the tables and populate them. I have the script to create the table which works but when I try to populate the employees table I get the "ORA-01438: value larger than specified precision allowed for this column ORA-06512: at "SYS.DBMS_SQL", line 1721" error message. The table structure and code are
Columns
# Column Type Length Precision Scale Nullable Semantics Comment
1 EMPLOYEE_ID NUMBER 22 2 0 No
2 FIRST_NAME VARCHAR2 14 Yes Byte
3 LAST_NAME VARCHAR2 13 Yes Byte
4 EMAIL VARCHAR2 25 Yes Byte
5 PHONE_NUMBER VARCHAR2 25 Yes Byte
6 HIRE_DATE DATE 7 Yes
7 JOB_ID VARCHAR2 10 Yes Byte
8 SALARY NUMBER 22 8 2 Yes
9 COMMISION_PCT NUMBER 22 2 2 Yes
10 MANAGER_ID NUMBER 22 6 0 Yes
11 DEPARTMENT_ID NUMBER 22 4 0 Yes
INSERT INTO employees VALUES
( 101
, 'Neena'
, 'Kochhar'
, 'NKOCHHAR'
, '515.123.4568'
, TO_DATE('21-SEP-1989', 'dd-MON-yyyy')
, 'AD_VP'
, 17000
, NULL
, 100
, 90)
yet again I cannot find the error.
|
|
|
|
|
|
|
|