I can not insert it in a table

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
Post Reply
eduardo.d2
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 67
Joined: Tue, 08 Jan 2008 9:13 pm
Location: são paulo
Eduardo Andrade

Environment information:
* Oracle version: 10g Express Edition
* Operating system: XP

Hello I am trying hard to enter data into a table,
follows the table

Select all

 
TABELA CLIENTES ( 
CODIGO NUMBER(10, 0) NOT NULL, 
NOME VARCHAR2(50) NOT NULL, 
DATA DATE NOT NULL, 
STATUS NUMBER(1, 0) DEFAULT '1' NOT NULL, 
CREDITO NUMBER(12, 2), 
HISTORICO LONG, 
TIPO VARCHAR2(30) DEFAULT 'J' NOT NULL,  
the error that is returning me

Select all

Error report: 
SQL Error: ORA-01722: número inválido 
01722. 00000 -  "invalid number"
and this and INSERT

Select all

 
insert into CLIENTES (CODIGO, 
             NOME, 
             DATA, 
             STATUS, 
             HISTORICO, 
             CREDITO, 
             TIPO, 
             CGC) 
values  
       (1, 
       'EDUARDO', 
       SYSDATE, 
       1, 
       1, 
       'TESTE', 
       'TESTE', 
       'TESTE');
]

from now on, thank you
Trevisolli
Moderador
Moderador
Posts: 2016
Joined: Wed, 12 Jan 2005 3:25 pm
Location: Araraquara - SP
Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP

Brother,

The CGC field is the number number?
Trevisolli
Moderador
Moderador
Posts: 2016
Joined: Wed, 12 Jan 2005 3:25 pm
Location: Araraquara - SP
Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP

Topic moved to the group of sql .
eduardo.d2
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 67
Joined: Tue, 08 Jan 2008 9:13 pm
Location: são paulo
Eduardo Andrade

No

Select all

CGC VARCHAR2(14) NOT NULL )
User avatar
TBou
Rank: Analista Sênior
Rank: Analista Sênior
Posts: 136
Joined: Thu, 05 Aug 2004 9:33 am
Location: Campo Grande - MS
Thiago Bourscheidt
thiago.info@apoiorural.com.br
Analista de Sistemas

Good morning,

See the Credit field, he is number and you are trying to insert 'test' into it. This is the error.


vlw
eduardo.d2
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 67
Joined: Tue, 08 Jan 2008 9:13 pm
Location: são paulo
Eduardo Andrade

Good evening, now it is giving another error

Select all

Error at Command Line:1 Column:12 
Error report: 
SQL Error: ORA-00913: valores demais 
00913. 00000 -  "too many values"
I made the modification in the table, increased the size of it but no advanced

Select all

INSERT INTO CLIENTES(CODIGO, 
                    NOME, 
                    DATA, 
                    STATUS, 
                    CREDITO, 
                    HISTORICO, 
                    TIPO, 
                    CGC) 
            VALUES(01, 
                   'EDUARDO', 
                   SYSDATE, 
                   1, 
                   100, 
                   'TESTE', 
                   'TESTE', 
                   'T', 
                   'TESTE')
Renan Orati
Rank: Analista Júnior
Rank: Analista Júnior
Posts: 90
Joined: Thu, 23 Aug 2007 3:40 pm
Location: São José do Rio Preto - SP

You're spending a more value !!

You indicated 8 fields to receive values ??... however you are passing 9 values ??within "values" !!!!

Select all

 
INSERT INTO CLIENTES(CODIGO, -- campo 1 
                    NOME, -- campo 2 
                    DATA, -- campo 3 
                    STATUS, -- campo 4 
                    CREDITO, -- campo 5 
                    HISTORICO, -- campo 6 
                    TIPO, -- campo 7 
                    CGC) -- campo 8 
            VALUES(01, -- campo 1 
                   'EDUARDO', -- campo 2 
                   SYSDATE, -- campo 3 
                   1, -- campo 4 
                   100, -- campo 5 
                   'TESTE', -- campo 6 
                   'TESTE', -- campo 7 
                   'T', -- campo 8 
                   'TESTE'); -- campo 9 
falou !!
edson.amorim
Rank: Analista Sênior
Rank: Analista Sênior
Posts: 135
Joined: Thu, 04 Oct 2007 3:36 pm
Location: Belo Horizonte - MG

Dear colleague,

As a test, I would take the seven field that is there in your insert. I would trade the content of the last field so that it really is a CGC. See then alternative:

As is:

Select all

 
INSERT INTO CLIENTES(CODIGO, -- campo 1  
                    NOME, -- campo 2  
                    DATA, -- campo 3  
                    STATUS, -- campo 4  
                    CREDITO, -- campo 5  
                    HISTORICO, -- campo 6  
                    TIPO, -- campo 7  
                    CGC) -- campo 8  
            VALUES(01, -- campo 1  
                   'EDUARDO', -- campo 2  
                   SYSDATE, -- campo 3  
                   1, -- campo 4  
                   100, -- campo 5  
                   'TESTE', -- campo 6  
                   'TESTE', -- campo 7  
                   'T', -- campo 8  
                   'TESTE'); -- campo 9  
How would it be correcting the errors:

Select all

 
 
INSERT INTO CLIENTES(CODIGO, -- campo 1  
                    NOME, -- campo 2  
                    DATA, -- campo 3  
                    STATUS, -- campo 4  
                    CREDITO, -- campo 5  
                    HISTORICO, -- campo 6  
                    TIPO, -- campo 7  
                    CGC) -- campo 8  
            VALUES(01, -- campo 1  
                   'EDUARDO', -- campo 2  
                   SYSDATE, -- campo 3  
                   1, -- campo 4  
                   100, -- campo 5  
                   'TESTE', -- campo 6  
                   'T', -- campo 7  
                   '17187482000127'); -- campo 8 
 
  
I hope it helps you !!

Edson
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 11 guests