Reputation: 457
My create customer table is as follows:
CREATE TABLE customers
(
customer_id NUMBER(5),
store_id NUMBER(4),
firstname VARCHAR2(20),
lastname VARCHAR2(20),
gender CHAR(1),
street VARCHAR2(50),
city VARCHAR2(20),
state VARCHAR2(15),
zip_code VARCHAR2(10),
card_approved CHAR(1),
card_approved_date DATE,
phone_number VARCHAR2(10),
card_number NUMBER(10),
rent_limit NUMBER(2),
overdue_notified CHAR(1),
CONSTRAINT customers_pk PRIMARY KEY(customer_id),
CONSTRAINT customers_fk
FOREIGN KEY(store_id) REFERENCES movie_rental_stores(store_id)
);
My data for the tuple I am trying to update is as follows:
VALUES('00005', '001', 'Aspen', 'Lily', 'F', '267 Lesperance', 'Dallas', 'TX', '34567', 'Y', '05-SEP-2014', '2569842356', '1236395891', '5', 'N');
The Update
statement looks like this:
UPDATE customers
SET lastname = 'Burtner',
WHERE customer_id = '00005';
However, when I execute it I keep getting the following error:
ORA-01747: invalid user.table.column, table.column, or column specification
I tried removing quotes from customer_id
, and every scenario I could think of but it won't let me update it.
Upvotes: 0
Views: 49
Reputation: 16917
You have a trailing comma in your update statement
UPDATE customers
SET lastname='Burtner', <-- here
WHERE customer_id='00005';
Change it to this:
UPDATE customers
SET lastname='Burtner'
WHERE customer_id='00005';
Upvotes: 3