API tools faq
paste
Advertisement
jets-

seedOO - GDWin

jets-
Nov 6th, 2015
117
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 20.41 KB | None | 0 0
raw download clone embed print report
  1. /* tb_funcionarios */
  2.  
  3. INSERT INTO tb_funcionarios VALUES ('06234438765', 'Walter White', TO_DATE('30/03/2014','dd/mm/yyyy'), TO_DATE('13/04/1976','dd/mm/yyyy'), NULL);
  4. INSERT INTO tb_funcionarios VALUES ('88140983799', 'Jesse Pinkman', TO_DATE('08/02/1966','dd/mm/yyyy'), TO_DATE('15/06/1931','dd/mm/yyyy'), NULL);
  5. INSERT INTO tb_funcionarios VALUES ('90752904834', 'Todd Price', TO_DATE('28/11/2008', 'dd/mm/yyyy'), TO_DATE('29/11/1962', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='06234438765'));
  6. INSERT INTO tb_funcionarios VALUES ('84865465963', 'Laura Thompson', TO_DATE('20/07/1960', 'dd/mm/yyyy'), TO_DATE('07/10/1934', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='06234438765'));
  7. INSERT INTO tb_funcionarios VALUES ('73235295212', 'Nancy Greene', TO_DATE('01/08/1962', 'dd/mm/yyyy'), TO_DATE('01/12/1939', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='06234438765'));
  8. INSERT INTO tb_funcionarios VALUES ('88838233153', 'Richard Palmer', TO_DATE('07/09/1971', 'dd/mm/yyyy'), TO_DATE('06/02/1949', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='06234438765'));
  9. INSERT INTO tb_funcionarios VALUES ('57424468667', 'Irene Nelson', TO_DATE('21/10/1992', 'dd/mm/yyyy'), TO_DATE('09/02/1932', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='06234438765'));
  10. INSERT INTO tb_funcionarios VALUES ('94183732742', 'Craig Marshall', TO_DATE('30/09/1981', 'dd/mm/yyyy'), TO_DATE('24/08/1951', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='06234438765'));
  11. INSERT INTO tb_funcionarios VALUES ('42025593625', 'Dennis Morrison', TO_DATE('28/01/2005', 'dd/mm/yyyy'), TO_DATE('24/03/1951', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='06234438765'));
  12. INSERT INTO tb_funcionarios VALUES ('31988589642', 'Earl Jenkins', TO_DATE('24/05/2007', 'dd/mm/yyyy'), TO_DATE('07/11/1982', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='06234438765'));
  13. INSERT INTO tb_funcionarios VALUES ('97268251891', 'Lois Davis', TO_DATE('28/06/1992', 'dd/mm/yyyy'), TO_DATE('24/07/1967', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='06234438765'));
  14. INSERT INTO tb_funcionarios VALUES ('57158935832', 'Evelyn Banks', TO_DATE('22/02/2009', 'dd/mm/yyyy'), TO_DATE('24/11/1988', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='06234438765'));
  15. INSERT INTO tb_funcionarios VALUES ('80817022099', 'Elizabeth Ortiz', TO_DATE('14/07/1988', 'dd/mm/yyyy'), TO_DATE('14/01/1953', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='06234438765'));
  16. INSERT INTO tb_funcionarios VALUES ('99053717997', 'Eugene Jenkins', TO_DATE('01/10/1980', 'dd/mm/yyyy'), TO_DATE('06/09/1946', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='06234438765'));
  17. INSERT INTO tb_funcionarios VALUES ('52806078197', 'Kathleen Baker', TO_DATE('24/10/1986', 'dd/mm/yyyy'), TO_DATE('11/01/1952', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='06234438765'));
  18. INSERT INTO tb_funcionarios VALUES ('93366940787', 'Richard Mason', TO_DATE('07/05/1974', 'dd/mm/yyyy'), TO_DATE('17/09/1930', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='06234438765'));
  19. INSERT INTO tb_funcionarios VALUES ('19392779618', 'Bruce Hicks', TO_DATE('11/09/1995', 'dd/mm/yyyy'), TO_DATE('02/08/1971', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='06234438765'));
  20. INSERT INTO tb_funcionarios VALUES ('66886800515', 'Jessica Rogers', TO_DATE('10/12/1996', 'dd/mm/yyyy'), TO_DATE('23/10/1955', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='06234438765'));
  21. INSERT INTO tb_funcionarios VALUES ('90746704523', 'Aaron Marshall', TO_DATE('21/03/2004', 'dd/mm/yyyy'), TO_DATE('24/06/1980', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='06234438765'));
  22. INSERT INTO tb_funcionarios VALUES ('48671138077', 'Christopher Day', TO_DATE('16/02/1980', 'dd/mm/yyyy'), TO_DATE('13/04/1962', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='06234438765'));
  23. INSERT INTO tb_funcionarios VALUES ('09677549050', 'Joseph Lewis', TO_DATE('18/12/2015', 'dd/mm/yyyy'), TO_DATE('31/07/1995', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='06234438765'));
  24. INSERT INTO tb_funcionarios VALUES ('25104679287', 'Andrew Barnes', TO_DATE('26/04/1970', 'dd/mm/yyyy'), TO_DATE('10/04/1948', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='06234438765'));
  25. INSERT INTO tb_funcionarios VALUES ('55223845862', 'Bruce Gilbert', TO_DATE('28/02/1984', 'dd/mm/yyyy'), TO_DATE('27/09/1945', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='88140983799'));
  26. INSERT INTO tb_funcionarios VALUES ('14400581772', 'Philip Howell', TO_DATE('28/06/1967', 'dd/mm/yyyy'), TO_DATE('07/08/1948', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='88140983799'));
  27. INSERT INTO tb_funcionarios VALUES ('16629828403', 'Antonio Hunt', TO_DATE('22/02/2004', 'dd/mm/yyyy'), TO_DATE('20/10/1931', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='88140983799'));
  28. INSERT INTO tb_funcionarios VALUES ('28328322904', 'Evelyn Andrews', TO_DATE('20/09/2013', 'dd/mm/yyyy'), TO_DATE('12/10/1944', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='88140983799'));
  29. INSERT INTO tb_funcionarios VALUES ('77206501260', 'Paul Smith', TO_DATE('04/05/1994', 'dd/mm/yyyy'), TO_DATE('23/06/1948', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='88140983799'));
  30. INSERT INTO tb_funcionarios VALUES ('12230884090', 'Willie Jackson', TO_DATE('20/09/2000', 'dd/mm/yyyy'), TO_DATE('11/12/1972', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='88140983799'));
  31. INSERT INTO tb_funcionarios VALUES ('10705340017', 'Patrick Reid', TO_DATE('02/08/1995', 'dd/mm/yyyy'), TO_DATE('25/07/1962', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='88140983799'));
  32. INSERT INTO tb_funcionarios VALUES ('44160467456', 'Angela Carroll', TO_DATE('20/08/2000', 'dd/mm/yyyy'), TO_DATE('27/05/1937', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='88140983799'));
  33. INSERT INTO tb_funcionarios VALUES ('79859148466', 'Paul Nguyen', TO_DATE('20/01/2005', 'dd/mm/yyyy'), TO_DATE('04/12/1973', 'dd/mm/yyyy'), (SELECT REF(S) FROM tb_funcionarios S WHERE cpf='88140983799'));
  34. /* tb_telefones_funcionarios */
  35.  
  36. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='90752904834'), tp_telefones_funcionarios(tp_telefone('73-955851930')));
  37. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='88140983799'), tp_telefones_funcionarios(tp_telefone('86-544220923')));
  38. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='06234438765'), tp_telefones_funcionarios(tp_telefone('67-593225915')));
  39. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='84865465963'), tp_telefones_funcionarios(tp_telefone('30-966035845')));
  40. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='73235295212'), tp_telefones_funcionarios(tp_telefone('12-305231025')));
  41. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='88838233153'), tp_telefones_funcionarios(tp_telefone('58-128915989')));
  42. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='57424468667'), tp_telefones_funcionarios(tp_telefone('69-089661833')));
  43. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='94183732742'), tp_telefones_funcionarios(tp_telefone('01-082838113')));
  44. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='42025593625'), tp_telefones_funcionarios(tp_telefone('10-716206606')));
  45. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='31988589642'), tp_telefones_funcionarios(tp_telefone('49-576866426')));
  46. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='97268251891'), tp_telefones_funcionarios(tp_telefone('59-019463948')));
  47. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='57158935832'), tp_telefones_funcionarios(tp_telefone('83-493926329')));
  48. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='80817022099'), tp_telefones_funcionarios(tp_telefone('64-874254541')));
  49. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='99053717997'), tp_telefones_funcionarios(tp_telefone('97-174478839')));
  50. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='52806078197'), tp_telefones_funcionarios(tp_telefone('06-915249410')));
  51. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='93366940787'), tp_telefones_funcionarios(tp_telefone('11-653120573')));
  52. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='19392779618'), tp_telefones_funcionarios(tp_telefone('47-775980291')));
  53. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='66886800515'), tp_telefones_funcionarios(tp_telefone('33-158219829')));
  54. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='90746704523'), tp_telefones_funcionarios(tp_telefone('42-572442986')));
  55. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='48671138077'), tp_telefones_funcionarios(tp_telefone('23-474682320')));
  56. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='09677549050'), tp_telefones_funcionarios(tp_telefone('38-083558365')));
  57. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='25104679287'), tp_telefones_funcionarios(tp_telefone('74-739842145')));
  58. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='55223845862'), tp_telefones_funcionarios(tp_telefone('72-689677057')));
  59. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='14400581772'), tp_telefones_funcionarios(tp_telefone('11-184057062')));
  60. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='16629828403'), tp_telefones_funcionarios(tp_telefone('38-451129023')));
  61. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='28328322904'), tp_telefones_funcionarios(tp_telefone('34-576510381')));
  62. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='77206501260'), tp_telefones_funcionarios(tp_telefone('99-357419494')));
  63. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='77206501260'), tp_telefones_funcionarios(tp_telefone('44-563702997')));
  64. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='10705340017'), tp_telefones_funcionarios(tp_telefone('24-567714659')));
  65. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='44160467456'), tp_telefones_funcionarios(tp_telefone('79-496267747')));
  66. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='79859148466'), tp_telefones_funcionarios(tp_telefone('52-016256469')));
  67. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='04910256448'), tp_telefones_funcionarios(tp_telefone('64-540562398')));
  68. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='89851302606'), tp_telefones_funcionarios(tp_telefone('73-462204136')));
  69. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='68788809434'), tp_telefones_funcionarios(tp_telefone('60-693345220')));
  70. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='92346383395'), tp_telefones_funcionarios(tp_telefone('07-585280716')));
  71. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='13574644097'), tp_telefones_funcionarios(tp_telefone('67-800006041')));
  72. INSERT INTO tb_telefones_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='92496388053'), tp_telefones_funcionarios(tp_telefone('00-212047640')));
  73.  
  74. /* enderecos_funcionarios */
  75. INSERT INTO tb_enderecos_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='90752904834'), '24002419', 'Rua Amaro Gomes Poroca, 91, Várzea');
  76. INSERT INTO tb_enderecos_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='88140983799'), '47146819', 'Av. Agamenon Magalhães, 1000, Santo Amaro');
  77. INSERT INTO tb_enderecos_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='06234438765'), '21162509', '190 Main Street West Salt Lake City, UT 84119');
  78. INSERT INTO tb_enderecos_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='84865465963'), '40037681', '474 Fieldstone Drive Olive Branch, MS 38654');
  79. INSERT INTO tb_enderecos_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='73235295212'), '28554775', '626 Brandywine Drive Middleburg, FL 32068');
  80. INSERT INTO tb_enderecos_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='88838233153'), '21147608', '309 Highland Drive Fairburn, GA 30213');
  81. INSERT INTO tb_enderecos_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='57424468667'), '24931142', '266 School Street Fenton, MI 48430');
  82. INSERT INTO tb_enderecos_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='94183732742'), '19687243', '505 Virginia Avenue yattsville, MD 20782');
  83. INSERT INTO tb_enderecos_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='42025593625'), '40984189', '508 Cambridge Road Mount Prospect, IL 60056');
  84. INSERT INTO tb_enderecos_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='31988589642'), '48939700', '121 New Street Champlin, MN 55316');
  85. INSERT INTO tb_enderecos_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='97268251891'), '15676650', '225 Sycamore Drive Phillipsburg, NJ 08865');
  86. INSERT INTO tb_enderecos_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='57158935832'), '58569663', '441 Park Avenue Omaha, NE 68107');
  87. INSERT INTO tb_enderecos_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='80817022099'), '20749684', '704 Hawthorne Lane Parkville, MD 21234');
  88. INSERT INTO tb_enderecos_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='99053717997'), '31103687', '107 Cypress Court Ladson, SC 29456');
  89. INSERT INTO tb_enderecos_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='52806078197'), '41382473', '407 1st Avenue Wasilla, AK 99654');
  90. INSERT INTO tb_enderecos_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='93366940787'), '16239833', '971 Laurel Drive District Heights, MD 20747');
  91. INSERT INTO tb_enderecos_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='19392779618'), '28887159', '86 Cleveland Avenue Uniondale, NY 11553');
  92. INSERT INTO tb_enderecos_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='66886800515'), '47335459', '17 Amherst Street Glen Allen, VA 23059');
  93. INSERT INTO tb_enderecos_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='90746704523'), '31119034', '558 Beechwood Drive Newtown, PA 18940');
  94. INSERT INTO tb_enderecos_funcionarios VALUES ((SELECT REF(s) FROM tb_funcionarios s WHERE cpf='48671138077'), '49272302', '426 Marshall Street Rocky Mount, NC 27804');
  95.  
  96.  
  97. /* NOVAS DALE AI BOY ! */
  98.  
  99.  
  100.  
  101. /* telefones_clientes */
  102.  
  103. INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='32771001010862'), tp_nt_telefones_clientes(tp_telefone('1097112736')));
  104. INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='74023615300569'), tp_nt_telefones_clientes(tp_telefone('1098522898')));
  105. INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='35480432803963'), tp_nt_telefones_clientes(tp_telefone('1099631901')));
  106. INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='40824079424045'), tp_nt_telefones_clientes(tp_telefone('1098326714')));
  107. INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='50997772767181'), tp_nt_telefones_clientes(tp_telefone('1099367308')));
  108. INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='61841660367260'), tp_nt_telefones_clientes(tp_telefone('1097878759')));
  109. INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='49991270192798'), tp_nt_telefones_clientes(tp_telefone('1098480548')));
  110. INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='77016702913997'), tp_nt_telefones_clientes(tp_telefone('1098503945')));
  111. INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='14010782046701'), tp_nt_telefones_clientes(tp_telefone('1099108026')));
  112. INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='94405974919694'), tp_nt_telefones_clientes(tp_telefone('1098424309')));
  113. INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='91913832268294'), tp_nt_telefones_clientes(tp_telefone('1097782276')));
  114. INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='57290869110659'), tp_nt_telefones_clientes(tp_telefone('1098610719')));
  115. INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='26990196975153'), tp_nt_telefones_clientes(tp_telefone('1097208407')));
  116. INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='94395785501995'), tp_nt_telefones_clientes(tp_telefone('1097195017')));
  117. INSERT INTO tb_telefones_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='46168389687831'), tp_nt_telefones_clientes(tp_telefone('1099685226')));
  118.  
  119. /* enderecos_clientes */
  120.  
  121. INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='32771001010862'), '46359768', '579 Oak Lane Parlin, NJ 08859.');
  122. 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.');
  123. INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='35480432803963'), '34311823', '340 Somerset Drive Woodstock, GA 30188.');
  124. INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='40824079424045'), '14956210', '948 William Street Barberton, OH 44203.');
  125. INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='50997772767181'), '43483725', '457 Route 2 Griffin, GA 30223.');
  126. INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='61841660367260'), '14576247', '522 Columbia Street Peachtree City, GA 30269.');
  127. INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='49991270192798'), '48415503', '804 Oak Street Silver Spring, MD 20901.');
  128. INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='77016702913997'), '55153968', '872 Bridge Street Oceanside, NY 11572.');
  129. INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='14010782046701'), '14826814', '434 Hickory Street Thibodaux, LA 70301.');
  130. INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='94405974919694'), '28473617', '411 Arlington Avenue Hackensack, NJ 07601.');
  131. INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='91913832268294'), '23573257', '848 Colonial Drive Peabody, MA 01960.');
  132. INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='57290869110659'), '24488350', '201 Bayberry Drive Rosemount, MN 55068.');
  133. INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='26990196975153'), '39413836', '360 Central Avenue Olive Branch, MS 38654.');
  134. INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='94395785501995'), '59547171', '901 Oak Street Natchez, MS 39120.');
  135. INSERT INTO tb_enderecos_clientes VALUES ((SELECT REF(C) FROM tb_clientes C WHERE cnpj='46168389687831'), '59727291', '194 Park Street Belmont, MA 02478.');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!