CODEWITHSUNDEEP
sqloracle-database
user9226222
user9226222

Reputation:

Trouble inserting values into a table in oracle SQL

This is my SQL statement:

insert into client 1 
    (Nom, prénom, DateNaiss, RUE, CP, Ville)
values 
    ('SALMI','SAMI','02/12/1944','RUE N17',100023,'RABAT');

I got this message:

ORA-00926: missing VALUES keyword

What am I missing?

Upvotes: 0

Views: 635

Answers (2)

Barbaros Özhan
Barbaros Özhan

Reputation: 65408

the problem is due to wrong table name client 1, replace with client_1 or "client 1" or client as you mentioned.

D e m o

Upvotes: 0

RoMEoMusTDiE
RoMEoMusTDiE

Reputation: 4824

should be 

insert into client (Nom,prénom,DateNaiss,RUE,CP,Ville) 
values('SALMI','SAMI','02/12/1944','RUE N17',100023,'RABAT');

Upvotes: 1

Related Questions