sql test

INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='32771001010862'), tp_nt_telefones_clientes(tp_telefone('1097112736')));
INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='74023615300569'), tp_nt_telefones_clientes(tp_telefone('1098522898')));
INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='35480432803963'), tp_nt_telefones_clientes(tp_telefone('1099631901')));
INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='40824079424045'), tp_nt_telefones_clientes(tp_telefone('1098326714')));
INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='50997772767181'), tp_nt_telefones_clientes(tp_telefone('1099367308')));
INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='61841660367260'), tp_nt_telefones_clientes(tp_telefone('1097878759')));
INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='49991270192798'), tp_nt_telefones_clientes(tp_telefone('1098480548')));
INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='77016702913997'), tp_nt_telefones_clientes(tp_telefone('1098503945')));
INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='14010782046701'), tp_nt_telefones_clientes(tp_telefone('1099108026')));
INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='94405974919694'), tp_nt_telefones_clientes(tp_telefone('1098424309')));
INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='91913832268294'), tp_nt_telefones_clientes(tp_telefone('1097782276')));
INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='57290869110659'), tp_nt_telefones_clientes(tp_telefone('1098610719')));
INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='26990196975153'), tp_nt_telefones_clientes(tp_telefone('1097208407')));
INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='94395785501995'), tp_nt_telefones_clientes(tp_telefone('1097195017')));
INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='46168389687831'), tp_nt_telefones_clientes(tp_telefone('1099685226')));

/* enderecos_clientes */

INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='32771001010862'), '46359768', '579 Oak Lane Parlin, NJ 08859.');
INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='74023615300569'), '38372503', '878 8th Avenue Lake In The Hills, IL 60156.');
INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='35480432803963'), '34311823', '340 Somerset Drive Woodstock, GA 30188.');
INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='40824079424045'), '14956210', '948 William Street Barberton, OH 44203.');
INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='50997772767181'), '43483725', '457 Route 2 Griffin, GA 30223.');
INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='61841660367260'), '14576247', '522 Columbia Street Peachtree City, GA 30269.');
INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='49991270192798'), '48415503', '804 Oak Street Silver Spring, MD 20901.');
INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='77016702913997'), '55153968', '872 Bridge Street Oceanside, NY 11572.');
INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='14010782046701'), '14826814', '434 Hickory Street Thibodaux, LA 70301.');
INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='94405974919694'), '28473617', '411 Arlington Avenue Hackensack, NJ 07601.');
INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='91913832268294'), '23573257', '848 Colonial Drive Peabody, MA 01960.');
INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='57290869110659'), '24488350', '201 Bayberry Drive Rosemount, MN 55068.');
INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='26990196975153'), '39413836', '360 Central Avenue Olive Branch, MS 38654.');
INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='94395785501995'), '59547171', '901 Oak Street Natchez, MS 39120.');
INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='46168389687831'), '59727291', '194 Park Street Belmont, MA 02478.');