Advertisement
daniele2013

Inserimento in visualizza completo e corretto

Mar 27th, 2014
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 4.01 KB | None | 0 0
  1. BEGIN
  2.     INSERT INTO Visualizza VALUES (1, 1, NULL, 1, SYSDATE);
  3.     INSERT INTO Visualizza VALUES (2, 1, NULL, 2, SYSDATE);
  4.     INSERT INTO Visualizza VALUES (3, 1, NULL, 4, SYSDATE);
  5.     INSERT INTO Visualizza VALUES (4, 1, NULL, 16, SYSDATE);
  6.     INSERT INTO Visualizza VALUES (5, 2, NULL, 2, SYSDATE);
  7.     INSERT INTO Visualizza VALUES (6, 2, NULL, 3, SYSDATE);
  8.     INSERT INTO Visualizza VALUES (7, 2, NULL, 4, SYSDATE);
  9.     INSERT INTO Visualizza VALUES (8, 2, NULL, 5, SYSDATE);
  10.     INSERT INTO Visualizza VALUES (9, 2, NULL, 6, SYSDATE);
  11.     INSERT INTO Visualizza VALUES (10, 2, NULL, 12, SYSDATE);
  12.     INSERT INTO Visualizza VALUES (11, 2, NULL, 16, SYSDATE);
  13.     INSERT INTO Visualizza VALUES (12, 2, NULL, 17, SYSDATE);
  14.     INSERT INTO Visualizza VALUES (13, 2, 2, NULL, SYSDATE);
  15.     INSERT INTO Visualizza VALUES (14, 3, NULL, 1, SYSDATE);
  16.     INSERT INTO Visualizza VALUES (15, 3, NULL, 2, SYSDATE);
  17.     INSERT INTO Visualizza VALUES (16, 3, NULL, 5, SYSDATE);
  18.     INSERT INTO Visualizza VALUES (17, 3, NULL, 6, SYSDATE);
  19.     INSERT INTO Visualizza VALUES (18, 3, NULL, 10, SYSDATE);
  20.     INSERT INTO Visualizza VALUES (19, 3, NULL, 14, SYSDATE);
  21.     INSERT INTO Visualizza VALUES (20, 4, NULL, 7, SYSDATE);
  22.     INSERT INTO Visualizza VALUES (21, 4, NULL, 8, SYSDATE);
  23.     INSERT INTO Visualizza VALUES (22, 4, NULL, 10, SYSDATE);
  24.     INSERT INTO Visualizza VALUES (23, 4, NULL, 12, SYSDATE);
  25.     INSERT INTO Visualizza VALUES (24, 4, 1, NULL, SYSDATE);
  26.     INSERT INTO Visualizza VALUES (25, 5, NULL, 2, SYSDATE);
  27.     INSERT INTO Visualizza VALUES (26, 5, NULL, 4, SYSDATE);
  28.     INSERT INTO Visualizza VALUES (27, 5, NULL, 9, SYSDATE);
  29.     INSERT INTO Visualizza VALUES (28, 5, NULL, 10, SYSDATE);
  30.     INSERT INTO Visualizza VALUES (29, 5, NULL, 11, SYSDATE);
  31.     INSERT INTO Visualizza VALUES (30, 5, NULL, 12, SYSDATE);
  32.     INSERT INTO Visualizza VALUES (31, 5, NULL, 13, SYSDATE);
  33.     INSERT INTO Visualizza VALUES (32, 5, NULL, 16, SYSDATE);
  34.     INSERT INTO Visualizza VALUES (33, 5, NULL, 17, SYSDATE);
  35.     INSERT INTO Visualizza VALUES (34, 5, 1, NULL, SYSDATE);
  36.     INSERT INTO Visualizza VALUES (35, 6, NULL, 2, SYSDATE);
  37.     INSERT INTO Visualizza VALUES (36, 6, NULL, 4, SYSDATE);
  38.     INSERT INTO Visualizza VALUES (37, 6, NULL, 5, SYSDATE);
  39.     INSERT INTO Visualizza VALUES (38, 6, NULL, 12, SYSDATE);
  40.     INSERT INTO Visualizza VALUES (39, 6, NULL, 13, SYSDATE);
  41.     INSERT INTO Visualizza VALUES (40, 6, NULL, 14, SYSDATE);
  42.     INSERT INTO Visualizza VALUES (41, 6, NULL, 15, SYSDATE);
  43.     INSERT INTO Visualizza VALUES (42, 6, NULL, 16, SYSDATE);
  44.     INSERT INTO Visualizza VALUES (43, 6, 4, NULL, SYSDATE);
  45.     INSERT INTO Visualizza VALUES (44, 7, NULL, 1, SYSDATE);
  46.     INSERT INTO Visualizza VALUES (45, 7, NULL, 2, SYSDATE);
  47.     INSERT INTO Visualizza VALUES (46, 7, NULL, 10, SYSDATE);
  48.     INSERT INTO Visualizza VALUES (47, 7, NULL, 13, SYSDATE);
  49.     INSERT INTO Visualizza VALUES (48, 7, NULL, 17, SYSDATE);
  50.     INSERT INTO Visualizza VALUES (49, 7, NULL, 18, SYSDATE);
  51.     INSERT INTO Visualizza VALUES (50, 7, 3, NULL, SYSDATE);
  52.     INSERT INTO Visualizza VALUES (51, 8, NULL, 2, SYSDATE);
  53.     INSERT INTO Visualizza VALUES (52, 8, NULL, 5, SYSDATE);
  54.     INSERT INTO Visualizza VALUES (53, 8, NULL, 10, SYSDATE);
  55.     INSERT INTO Visualizza VALUES (54, 8, NULL, 16, SYSDATE);
  56.     INSERT INTO Visualizza VALUES (55, 8, NULL, 17, SYSDATE);
  57.     INSERT INTO Visualizza VALUES (56, 8, NULL, 19, SYSDATE);
  58.     INSERT INTO Visualizza VALUES (57, 8, NULL, 20, SYSDATE);
  59.     INSERT INTO Visualizza VALUES (58, 8, 4, NULL, SYSDATE);
  60.     INSERT INTO Visualizza VALUES (59, 9, NULL, 1, SYSDATE);
  61.     INSERT INTO Visualizza VALUES (60, 9, NULL, 4, SYSDATE);
  62.     INSERT INTO Visualizza VALUES (61, 9, NULL, 8, SYSDATE);
  63.     INSERT INTO Visualizza VALUES (62, 9, NULL, 12, SYSDATE);
  64.     INSERT INTO Visualizza VALUES (63, 9, NULL, 16, SYSDATE);
  65.     INSERT INTO Visualizza VALUES (64, 9, NULL, 18, SYSDATE);
  66.     INSERT INTO Visualizza VALUES (65, 9, NULL, 21, SYSDATE);
  67.     INSERT INTO Visualizza VALUES (66, 9, NULL, 22, SYSDATE);
  68.     INSERT INTO Visualizza VALUES (67, 9, NULL, 23, SYSDATE);
  69.     INSERT INTO Visualizza VALUES (68, 9, NULL, 24, SYSDATE);
  70.     INSERT INTO Visualizza VALUES (69, 9, 2, NULL, SYSDATE);
  71. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement