Personal Good evening I want to insert data in a table but it presents an error "too many values" I will put my code for you to analyze.
Insert into account tab (account_id, bank_id, account_id, account_id, account_digit_number, account_type_cd, account_value) values (1,1,1,1, '123', 1, 'home', 10.00);
My information about the tab_tab table
You were passing more values to insert than declared columns to receive.
Try to execute the insert below:
insert into tab_Conta (id_correntista,id_banco,id_conta,id_agencia,nr_digito_conta,cd_tipo_correntista,vl_saldo)values(1,1,1,1,123,1,10.00);
It was man rolled. Thanks, man another doubt when trying to run an insert with TO_Date it has the following error. a non-numerical character was found where a numerical one was expected. My Oracle Command