API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 18th, 2019
64
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.02 KB | None | 0 0
raw download clone embed print report
  1. create table clientes(
  2. num_clie number(*,0) not null,
  3. empresa char (29) not null,
  4. rep_clie number(*,0),
  5. limite_credito number(*,0),
  6. constraint clientes_pk primary key (num_clie));
  7.  
  8. create table productos(
  9. id_fab char(3) not null,
  10. id_producto char(5) not null,
  11. descripcion char(20) not null,
  12. precio number(*,0) not null,
  13. existencias number(*,0) not null,
  14. constraint productos_pk primary key (id_fab,id_producto));
  15.  
  16. create table repventas(
  17. num_empl number(*,0) not null,
  18. nombre char(15) not null,
  19. edad number(*,0),
  20. oficina_rep number(*,0) not null,
  21. tituto char(11),
  22. contrato date not null,
  23. director number (*,0) not null,
  24. cuota number (*,0),
  25. ventas number (*,0),
  26. constraint repventas_pk primary key (num_empl));
  27.  
  28. desc repventas; /*mostrar informacion sobre los atributos de la tabla (si son nulos o no y el tipo de datos de cada uno*/
  29.  
  30. create table oficinas(
  31. oficina number(*,0) not null,
  32. ciudad char(15) not null,
  33. region char(10) not null,
  34. dir number (*,0) not null,
  35. objetivo number(*,0),
  36. ventas number(*,0) not null,
  37. constraint oficinas_pk primary key (oficina),
  38. constraint oficinas_fk foreign key (dir) references repventas(num_empl) on delete cascade);
  39.  
  40. show table oficinas; /*esto deberia mostrar la tabla, aunque parece que el Developer no lo hace y muestra "Show tables handled"*/
  41. desc oficinas; /*mostrar informacion sobre los atributos de la tabla (si son nulos o no y el tipo de datos de cada uno*/
  42.  
  43. create table pedidos(
  44. num_pedido number(*,0) not null,
  45. fecha_pedido date not null,
  46. clie number(*,0) not null,
  47. repr number(*,0) not null,
  48. fab char(3) not null,
  49. producto char(5) not null,
  50. cant number(*,0) not null,
  51. importe number(*,0) not null,
  52. constraint pedidos_pk primary key (num_pedido),
  53. constraint pedidos_clie_fk foreign key (clie) references clientes(num_clie) on delete cascade,
  54. constraint pedidos_repr_fk foreign key (repr) references repventas(num_empl) on delete cascade,
  55. constraint pedidos_fab_producto_fk foreign key (fab, producto) references productos(id_fab,id_producto) on delete cascade);
  56.  
  57. /*clientes*/
  58. INSERT INTO CLIENTES VALUES(2111,'JCP Inc',103,50000.00);
  59. INSERT INTO CLIENTES VALUES(2102,'Firts Corp',101,65000.00);
  60. INSERT INTO CLIENTES VALUES(2103,'Acme Mfg',105,50000.00);
  61. INSERT INTO CLIENTES VALUES(2123,'Carter Sons',102,40000.00);
  62. INSERT INTO CLIENTES VALUES(2107,'Ace Internatio nal',110,35000.00);
  63. INSERT INTO CLIENTES VALUES(2115,'Smithson Corp',101,20000.00);
  64. INSERT INTO CLIENTES VALUES(2101,'Jones Mfg',106,65000.00);
  65. INSERT INTO CLIENTES VALUES(2112,'Zetacorp',108,50000.00);
  66. INSERT INTO CLIENTES VALUES(2121,'QMA Assoc.',103,45000.00);
  67. INSERT INTO CLIENTES VALUES(2114,'Orion Corp',102,20000.00);
  68. INSERT INTO CLIENTES VALUES(2124,'Meter Brothers',107,40000.00);
  69. INSERT INTO CLIENTES VALUES(2108,'Holm Landis',109,55000.00);
  70. INSERT INTO CLIENTES VALUES(2117,'J.P. Sinclair',106,35000.00);
  71. INSERT INTO CLIENTES VALUES(2122,'Three - Way Lines',105,30000.00);
  72. INSERT INTO CLIENTES VALUES(2120,'Rico Enterprises',102,50000.00);
  73. INSERT INTO CLIENTES VALUES(2106,'Fred Lewis Corp',102,65000.00);
  74. INSERT INTO CLIENTES VALUES(2119,'Solomon Inc',109,25000.00);
  75. INSERT INTO CLIENTES VALUES(2118,'Midwest Systems',108,60000.00);
  76. INSERT INTO CLIENTES VALUES(2113,'Ian schmidt',104,20000.00);
  77. INSERT INTO CLIENTES VALUES(2109,'Chen Associates',103,25000.00);
  78. INSERT INTO CLIENTES VALUES(2105,'AAA Investments',101,45000.00);
  79.  
  80. /*productos*/
  81. INSERT INTO PRODUCTOS VALUES('REI','2A45C','V.Otago Trinquete',79.00,210);
  82. INSERT INTO PRODUCTOS VALUES('ACI','4100Y','Extractor',2750.00,25);
  83. INSERT INTO PRODUCTOS VALUES('QSA','XK47','Reductor',355.00,38);
  84. INSERT INTO PRODUCTOS VALUES('BIC','41672','Plate',180.00,0);
  85. INSERT INTO PRODUCTOS VALUES('IMM','779C','Riostra 2-Tm',1875.00,9);
  86. INSERT INTO PRODUCTOS VALUES('ACI','41003','Articulo Tipo 3',107.00,207);
  87. INSERT INTO PRODUCTOS VALUES('ACI','41004','Articulo Tipo 4',117.00,139);
  88. INSERT INTO PRODUCTOS VALUES('BIC','41003','Manivela',652.00,3);
  89. INSERT INTO PRODUCTOS VALUES('IMM','887P','Perno Riostra',250.00,24);
  90. INSERT INTO PRODUCTOS VALUES('QSA','XK48','Reductor',134.00,203);
  91. INSERT INTO PRODUCTOS VALUES('REI','2A44L','Bisagra Izada',4500.00,12);
  92. INSERT INTO PRODUCTOS VALUES('FEA','112','Cubierta',148.00,115);
  93. INSERT INTO PRODUCTOS VALUES('IMM','887H','Soporte Riostra',54.00,223);
  94. INSERT INTO PRODUCTOS VALUES('BIC','41089','Retn',225.00,78);
  95. INSERT INTO PRODUCTOS VALUES('ACI','41001','Articulo Tipo 1',55.00,277);
  96. INSERT INTO PRODUCTOS VALUES('IMM','775C','Riostra 1-Tm',1425.00,5);
  97. INSERT INTO PRODUCTOS VALUES('ACI','4100Z','Montador',2500.00,28);
  98. INSERT INTO PRODUCTOS VALUES('QSA','XK48A','Reductor',117.00,37);
  99. INSERT INTO PRODUCTOS VALUES('ACI','41002','Articulo Tipo 2',76.00,167);
  100. INSERT INTO PRODUCTOS VALUES('REI','2A44R','Bisagra Dcha',4500.00,12);
  101. INSERT INTO PRODUCTOS VALUES('IMM','773C','Riostra 1/2-Tm',975.00,28);
  102. INSERT INTO PRODUCTOS VALUES('ACI','4100X','Ajustador',25.00,37);
  103. INSERT INTO PRODUCTOS VALUES('FEA','114','Bancada Motor',243.00,15);
  104. INSERT INTO PRODUCTOS VALUES('IMM','887X','Retenedor Riostra',475.00,32);
  105. INSERT INTO PRODUCTOS VALUES('REI','2A44G','Pasador Bisagra',350.00,14);
  106.  
  107. /*rep ventas*/
  108. INSERT INTO REPVENTAS VALUES(105,'Bill Adams',37,13,'Rep.Ventas',to_date('12-FEB-88', 'DD-Mon-YY'),104,350000.00,367911.00);
  109. INSERT INTO REPVENTAS VALUES(109,'Mary Jones',31,11,'Rep.Ventas',to_date('12-OCT-99', 'DD-Mon-YY'),101,300000.00,392725.00);
  110. INSERT INTO REPVENTAS VALUES(102,'Sue Smith',48,21,'Rep.Ventas',to_date('10-DIC-86', 'DD-Mon-YY'),108,350000.00,474050.00);
  111. INSERT INTO REPVENTAS VALUES(106,'Sam Clark',52,11,'VP Ventas',to_date('14-JUN-88', 'DD-Mon-YY'),0,275000.00,299912.00);
  112. INSERT INTO REPVENTAS VALUES(104,'Bob Smith',33,12,'Dir.Ventas',to_date('19-MAY-87', 'DD-Mon-YY'),106,200000.00,142594.00);
  113. INSERT INTO REPVENTAS VALUES(101,'Dan Roberts',45,12,'Rep.Ventas',to_date('20-OCT-86', 'DD-Mon-YY'),104,300000.00,305673.00);
  114. INSERT INTO REPVENTAS VALUES(110,'Tom Snyder',41,0,'Rep.Ventas',to_date('13-ENE-90', 'DD-Mon-YY'),101,0,75985.00);
  115. INSERT INTO REPVENTAS VALUES(108,'Larry Fitch',62,21,'Dir.Ventas',to_date('12-OCT-89', 'DD-Mon-YY'),106,350000.00,361865.00);
  116. INSERT INTO REPVENTAS VALUES(103,'Paul Cruz',29,12,'Rep.Ventas',to_date('01-MAR-87', 'DD-Mon-YY'),104,275000.00,286775.00);
  117. INSERT INTO REPVENTAS VALUES(107,'Nancy Angeli',49,22,'Rep.Ventas',to_date('14-NOV-88', 'DD-Mon-YY'),108,300000.00,186042.00);
  118.  
  119. /*oficinas*/
  120.  
  121. INSERT INTO OFICINAS VALUES(22,'Denver','Oeste',108,300000.00,186042.00);
  122. INSERT INTO OFICINAS VALUES(11,'New York','Este',106,575000.00,692637.00);
  123. INSERT INTO OFICINAS VALUES(12,'Chicago','Este',104,800000.00,735042.00);
  124. INSERT INTO OFICINAS VALUES(13,'Atlanta','Este',105,350000.00,367911.00);
  125. INSERT INTO OFICINAS VALUES(21,'Los Angeles','Oeste',108,725000.00,835915.00);
  126.  
  127. /*pedidos SI DA FALLO, EJECUTAR ESTE BLOQUE POR SEPARADO*/
  128. INSERT INTO PEDIDOS VALUES (112961,TO_DATE('17-DIC-89','DD-MON-YY'),2117,106,'REI','2A44L',7,31500.00);
  129. INSERT INTO PEDIDOS VALUES (113012,TO_DATE('11-ENE-90','DD-MON-YY'),2111,105,'ACI','41003',35,3745.00);
  130. INSERT INTO PEDIDOS VALUES (112989,TO_DATE('03-ENE-90','DD-MON-YY'),2101,106,'FEA','114',6,1458.00);
  131. INSERT INTO PEDIDOS VALUES (113051,TO_DATE('10-FEB-90','DD-MON-YY'),2118,108,'QSA','XK47',4,1420.00);
  132. INSERT INTO PEDIDOS VALUES (112968,TO_DATE('12-OCT-89','DD-MON-YY'),2102,101,'ACI','41004',34,3978.00);
  133. INSERT INTO PEDIDOS VALUES (110036,TO_DATE('30-ENE-90','DD-MON-YY'),2107,110,'ACI','4100Z',9,22500.00);
  134. INSERT INTO PEDIDOS VALUES (113045,TO_DATE('02-FEB-90','DD-MON-YY'),2112,108,'REI','2A44R',10,45000.00);
  135. INSERT INTO PEDIDOS VALUES (112963,TO_DATE('17-DIC-89','DD-MON-YY'),2103,105,'ACI','41004',28,3276.00);
  136. INSERT INTO PEDIDOS VALUES (113013,TO_DATE('14-ENE-90','DD-MON-YY'),2118,108,'BIC','41003',1,652.00);
  137. INSERT INTO PEDIDOS VALUES (113058,TO_DATE('23-FEB-90','DD-MON-YY'),2108,109,'FEA','112',10,1480.00);
  138. INSERT INTO PEDIDOS VALUES (112997,TO_DATE('08-ENE-90','DD-MON-YY'),2124,107,'BIC','41003',1,652.00);
  139. INSERT INTO PEDIDOS VALUES (112983,TO_DATE('27-DIC-89','DD-MON-YY'),2103,105,'ACI','41004',6,702.00);
  140. INSERT INTO PEDIDOS VALUES (113024,TO_DATE('20-ENE-90','DD-MON-YY'),2114,108,'QSA','XK47',20,7100.00);
  141. INSERT INTO PEDIDOS VALUES (113062,TO_DATE('24-FEB-90','DD-MON-YY'),2124,107,'FEA','114',10,2430.00);
  142. INSERT INTO PEDIDOS VALUES (112979,TO_DATE('12-OCT-89','DD-MON-YY'),2114,102,'ACI','4100Z',6,15000.00);
  143. INSERT INTO PEDIDOS VALUES (113027,TO_DATE('22-ENE-90','DD-MON-YY'),2103,105,'ACI','41002',54,4104.00);
  144. INSERT INTO PEDIDOS VALUES (113007,TO_DATE('08-ENE-90','DD-MON-YY'),2112,108,'IMM','773C',3,2925.00);
  145. INSERT INTO PEDIDOS VALUES (113069,TO_DATE('02-MAR-90','DD-MON-YY'),2109,107,'IMM','773C',22,31350.00);
  146. INSERT INTO PEDIDOS VALUES (113034,TO_DATE('29-ENE-90','DD-MON-YY'),2107,110,'REI','2A45C',8,632.00);
  147. INSERT INTO PEDIDOS VALUES (112992,TO_DATE('04-NOV-89','DD-MON-YY'),2118,108,'ACI','41002',10,760.00);
  148. INSERT INTO PEDIDOS VALUES (112975,TO_DATE('12-OCT-89','DD-MON-YY'),2111,103,'REI','2A44G',6,2100.00);
  149. INSERT INTO PEDIDOS VALUES (113055,TO_DATE('15-FEB-90','DD-MON-YY'),2108,101,'ACI','4100X',6,150.00);
  150. INSERT INTO PEDIDOS VALUES (113048,TO_DATE('10-FEB-90','DD-MON-YY'),2120,102,'IMM','779C',2,3750.00);
  151. INSERT INTO PEDIDOS VALUES (112993,TO_DATE('04-ENE-89','DD-MON-YY'),2106,102,'REI','2A45C',24,1896.00);
  152. INSERT INTO PEDIDOS VALUES (113065,TO_DATE('27-FEB-90','DD-MON-YY'),2106,102,'QSA','XK47',6,2130.00);
  153. INSERT INTO PEDIDOS VALUES (113003,TO_DATE('25-ENE-90','DD-MON-YY'),2108,109,'IMM','779C',3,5625.00);
  154. INSERT INTO PEDIDOS VALUES (113049,TO_DATE('10-FEB-90','DD-MON-YY'),2118,108,'QSA','XK47',2,776.00);
  155. INSERT INTO PEDIDOS VALUES (112987,TO_DATE('31-DIC-89','DD-MON-YY'),2103,105,'ACI','4100Y',11,27500.00);
  156. INSERT INTO PEDIDOS VALUES (113057,TO_DATE('18-FEB-90','DD-MON-YY'),2111,103,'ACI','4100X',24,600.00);
  157. INSERT INTO PEDIDOS VALUES (113042,TO_DATE('02-FEB-90','DD-MON-YY'),2113,101,'REI','2A44R',5,22500.00);
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!