Please help - ORA-00917: missing comma insert error

Bivol Victor
create table gradinita333333 
(
    cod_Copil     number not null,
    cod_Parinti   number not null,
    nume_T        varchar2(25) ,
    nume_M        varchar2(25) ,
    prenume_M     varchar2(25) ,
    prenume_T     varchar2(25) ,
    nume_C        varchar2(25),
    data_nasterii date,
    adresa        varchar2(100),
    Grupa         number(5)
)

INSERT INTO gradinita333333 (cod_Copil, cod_Parinti, nume_T, nume_M, prenume_M, prenume_T, nume_C, data_nasterii, adresa, Grupa) 
VALUES ('1114', '4312', 'Bogdan','Randulescu','Ioana','Randulescu','Victor', 'TO_DATE('17/02/1995', dd/mm/yyyy','StrStefanCelMic','1'));
Littlefoot

A missing statement terminator for create table, as well as invalid usage of to_date along with a superfluous closing bracket for insert lead to various errors. When fixed, it works:

SQL> CREATE TABLE gradinita333333(
  2    cod_copil      NUMBER NOT NULL,
  3    cod_parinti    NUMBER NOT NULL,
  4    nume_t         VARCHAR2(25),
  5    nume_m         VARCHAR2(25),
  6    prenume_m      VARCHAR2(25),
  7    prenume_t      VARCHAR2(25),
  8    nume_c         VARCHAR2(25),
  9    data_nasterii  DATE,
 10    adresa         VARCHAR2(100),
 11    grupa          NUMBER(5)
 12  );

Table created.

SQL> INSERT INTO gradinita333333(
  2      cod_copil,
  3      cod_parinti,
  4      nume_t,
  5      nume_m,
  6      prenume_m,
  7      prenume_t,
  8      nume_c,
  9      data_nasterii,
 10      adresa,
 11      grupa
 12    )VALUES(
 13      '1114',
 14      '4312',
 15      'Bogdan',
 16      'Randulescu',
 17      'Ioana',
 18      'Randulescu',
 19      'Victor',
 20      to_date('17/02/1995 ', 'dd/mm/yyyy'),
 21      'StrStefanCelMic',
 22      '1'
 23    );

1 row created.

SQL>

Collected from the Internet

Please contact debugcn@gmail.com to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Java

Missing comma in Oracle insert

From Dev

Error 1120: Access of Undefined Property help please

From Dev

Oracle SQL missing comma error

From Dev

ORA-00917: missing comma error

From Dev

Ionic serve throws this error code help please

From Dev

Please help me correct the syntax error

From Dev

ORA-00917: missing comma when insert not exist in oracle

From Dev

ORA-00917 Missing Comma, but it isn't missing?

From Dev

java.sql.SQLException: ORA-00917: missing comma while Inserting rows in a table

From Dev

ORA-00917, missing comma

From Dev

Error: ORA-00917: missing comma 00917. 00000 - "missing comma"

From Dev

C# {"ORA-00917: missing comma"} INSERT QUERY ERROR

From Dev

Please help me debug this error about for/in in Javascript

From Dev

ORA-00917, missing comma

From Dev

Deja Dup restore error Help Please

From Dev

Null Pointer Exception Error .Please help me

From Dev

java.sql.sqlexpcetion:ORA-00917:missing comma

From Dev

error 3075 syntax missing comma

From Dev

ArrayIndexOutOfBoundsException please help find the error

From Dev

ORA-00936: missing expression ORACLE please help me

From Dev

ORA-00917: Missing Comma SQL Oracle error

From Dev

Please help in finding the error

From Dev

What is the error in this code please help:

From Dev

ORA-00917: missing comma when insert not exist in oracle

From Dev

java.sql.SQLException: ORA-00917: missing comma while Inserting rows in a table

From Dev

Missing Comma, oracle ORA-00917

From Dev

getting error ORA-01400:cannot insert NULL ... while inserting data with help of rowtype

From Dev

sql oracle, error "PL/SQL: SQL Statement ignored" and "PL/SQL: ORA-00917: missing comma"

From Dev

ORA-00917 missing comma in Powershell

Related Related

HotTag

Archive