* Oracle version: 10g Express Edition
* Operating system: XP
Hello I am trying hard to enter data into a table,
follows the table
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,
Error report:
SQL Error: ORA-01722: número inválido
01722. 00000 - "invalid number"
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