Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- BEGIN;
- INSERT INTO log_localidade (loc_nu_sequencial, loc_nosub, loc_no, cep, ufe_sg, loc_in_situacao, loc_in_tipo_localidade, loc_nu_sequencial_sub, loc_key_dne, temp)
- VALUES ((SELECT MAX(loc_nu_sequencial)+1 FROM log_localidade), 'Salvador', 'Salvador', '41720003', 'BA', 0, 'M', 0, '92ZBKV5ID4LAGUAL', NULL);
- INSERT INTO log_bairro (bai_nu_sequencial, ufe_sg, loc_nu_sequencial, bai_no, bai_no_abrev)
- VALUES ((SELECT MAX(bai_nu_sequencial)+1 FROM log_bairro), 'BA', (SELECT MAX(loc_nu_sequencial) FROM log_localidade),
- 'Imbuí', 'Imbui');
- INSERT INTO log_logradouro (log_nu_sequencial, ufe_sg, loc_nu_sequencial, log_no, log_nome, bai_nu_sequencial_ini, bai_nu_sequencial_fim, cep, log_complemento, log_tipo_logradouro, log_status_tipo_log, log_no_sem_acento, log_key_dne, ind_uop, ind_gru, temp)
- VALUES ((SELECT MAX(log_nu_sequencial)+1 FROM log_logradouro), 'BA',
- (SELECT MAX(loc_nu_sequencial) FROM log_localidade),
- 'Novo Imbuí', 'Rua Novo Imbuí', (SELECT MAX(bai_nu_sequencial) FROM log_bairro), 0, '41720003', NULL,
- 'Rua', 'S', 'Rua Novo Imbui', NULL, 'N', 'N', NULL);
- commit;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement