github.com/yongjacky/phoenix-go-orm-builder@v0.3.5/testdata/oracle_fiddle_data.sql (about)

     1  create table table1 (
     2    id number(9) not null primary key,
     3    a  varchar2(40),
     4    b  varchar2(40),
     5    c  varchar2(40)
     6  );
     7  
     8  create table table2 (
     9    id     number(9) not null primary key,
    10    ref_id number(9),
    11    d      varchar2(40)
    12  );
    13  
    14  INSERT INTO table1 (id, a, b, c)
    15  VALUES (0, '0', '0', '0');
    16  INSERT INTO table1 (id, a, b, c)
    17  VALUES (1, '1', '1', '1');
    18  INSERT INTO table1 (id, a, b, c)
    19  VALUES (2, '2', '2', '2');
    20  INSERT INTO table1 (id, a, b, c)
    21  VALUES (3, '3', '3', '3');
    22  INSERT INTO table1 (id, a, b, c)
    23  VALUES (4, '4', '4', '4');
    24  INSERT INTO table1 (id, a, b, c)
    25  VALUES (5, '5', '5', '5');
    26  INSERT INTO table1 (id, a, b, c)
    27  VALUES (6, '6', '6', '6');
    28  INSERT INTO table1 (id, a, b, c)
    29  VALUES (7, '7', '7', '7');
    30  INSERT INTO table1 (id, a, b, c)
    31  VALUES (8, '8', '8', '8');
    32  INSERT INTO table1 (id, a, b, c)
    33  VALUES (9, '9', '9', '9');
    34  INSERT INTO table1 (id, a, b, c)
    35  VALUES (10, '10', '10', '10');
    36  INSERT INTO table1 (id, a, b, c)
    37  VALUES (11, '11', '11', '11');
    38  INSERT INTO table1 (id, a, b, c)
    39  VALUES (12, '12', '12', '12');
    40  INSERT INTO table1 (id, a, b, c)
    41  VALUES (13, '13', '13', '13');
    42  INSERT INTO table1 (id, a, b, c)
    43  VALUES (14, '14', '14', '14');
    44  INSERT INTO table1 (id, a, b, c)
    45  VALUES (15, '15', '15', '15');
    46  INSERT INTO table1 (id, a, b, c)
    47  VALUES (16, '16', '16', '16');
    48  INSERT INTO table1 (id, a, b, c)
    49  VALUES (17, '17', '17', '17');
    50  INSERT INTO table1 (id, a, b, c)
    51  VALUES (18, '18', '18', '18');
    52  INSERT INTO table1 (id, a, b, c)
    53  VALUES (19, '19', '19', '19');
    54  INSERT INTO table1 (id, a, b, c)
    55  VALUES (20, '20', '20', '20');
    56  INSERT INTO table1 (id, a, b, c)
    57  VALUES (21, '21', '21', '21');
    58  INSERT INTO table1 (id, a, b, c)
    59  VALUES (22, '22', '22', '22');
    60  INSERT INTO table1 (id, a, b, c)
    61  VALUES (23, '23', '23', '23');
    62  INSERT INTO table1 (id, a, b, c)
    63  VALUES (24, '24', '24', '24');
    64  INSERT INTO table1 (id, a, b, c)
    65  VALUES (25, '25', '25', '25');
    66  INSERT INTO table1 (id, a, b, c)
    67  VALUES (26, '26', '26', '26');
    68  INSERT INTO table1 (id, a, b, c)
    69  VALUES (27, '27', '27', '27');
    70  INSERT INTO table1 (id, a, b, c)
    71  VALUES (28, '28', '28', '28');
    72  INSERT INTO table1 (id, a, b, c)
    73  VALUES (29, '29', '29', '29');
    74  INSERT INTO table1 (id, a, b, c)
    75  VALUES (30, '30', '30', '30');
    76  INSERT INTO table1 (id, a, b, c)
    77  VALUES (31, '31', '31', '31');
    78  INSERT INTO table1 (id, a, b, c)
    79  VALUES (32, '32', '32', '32');
    80  INSERT INTO table1 (id, a, b, c)
    81  VALUES (33, '33', '33', '33');
    82  INSERT INTO table1 (id, a, b, c)
    83  VALUES (34, '34', '34', '34');
    84  INSERT INTO table1 (id, a, b, c)
    85  VALUES (35, '35', '35', '35');
    86  INSERT INTO table1 (id, a, b, c)
    87  VALUES (36, '36', '36', '36');
    88  INSERT INTO table1 (id, a, b, c)
    89  VALUES (37, '37', '37', '37');
    90  INSERT INTO table1 (id, a, b, c)
    91  VALUES (38, '38', '38', '38');
    92  INSERT INTO table1 (id, a, b, c)
    93  VALUES (39, '39', '39', '39');
    94  INSERT INTO table1 (id, a, b, c)
    95  VALUES (40, '40', '40', '40');
    96  INSERT INTO table1 (id, a, b, c)
    97  VALUES (41, '41', '41', '41');
    98  INSERT INTO table1 (id, a, b, c)
    99  VALUES (42, '42', '42', '42');
   100  INSERT INTO table1 (id, a, b, c)
   101  VALUES (43, '43', '43', '43');
   102  INSERT INTO table1 (id, a, b, c)
   103  VALUES (44, '44', '44', '44');
   104  INSERT INTO table1 (id, a, b, c)
   105  VALUES (45, '45', '45', '45');
   106  INSERT INTO table1 (id, a, b, c)
   107  VALUES (46, '46', '46', '46');
   108  INSERT INTO table1 (id, a, b, c)
   109  VALUES (47, '47', '47', '47');
   110  INSERT INTO table1 (id, a, b, c)
   111  VALUES (48, '48', '48', '48');
   112  INSERT INTO table1 (id, a, b, c)
   113  VALUES (49, '49', '49', '49');
   114  
   115  INSERT INTO table2 (id, ref_id, d)
   116  VALUES (0, '0', '0');
   117  INSERT INTO table2 (id, ref_id, d)
   118  VALUES (1, '1', '1');
   119  INSERT INTO table2 (id, ref_id, d)
   120  VALUES (2, '2', '2');
   121  INSERT INTO table2 (id, ref_id, d)
   122  VALUES (3, '3', '3');
   123  INSERT INTO table2 (id, ref_id, d)
   124  VALUES (4, '4', '4');
   125  INSERT INTO table2 (id, ref_id, d)
   126  VALUES (5, '5', '5');
   127  INSERT INTO table2 (id, ref_id, d)
   128  VALUES (6, '6', '6');
   129  INSERT INTO table2 (id, ref_id, d)
   130  VALUES (7, '7', '7');
   131  INSERT INTO table2 (id, ref_id, d)
   132  VALUES (8, '8', '8');
   133  INSERT INTO table2 (id, ref_id, d)
   134  VALUES (9, '9', '9');
   135  INSERT INTO table2 (id, ref_id, d)
   136  VALUES (10, '10', '10');
   137  INSERT INTO table2 (id, ref_id, d)
   138  VALUES (11, '11', '11');
   139  INSERT INTO table2 (id, ref_id, d)
   140  VALUES (12, '12', '12');
   141  INSERT INTO table2 (id, ref_id, d)
   142  VALUES (13, '13', '13');
   143  INSERT INTO table2 (id, ref_id, d)
   144  VALUES (14, '14', '14');
   145  INSERT INTO table2 (id, ref_id, d)
   146  VALUES (15, '15', '15');
   147  INSERT INTO table2 (id, ref_id, d)
   148  VALUES (16, '16', '16');
   149  INSERT INTO table2 (id, ref_id, d)
   150  VALUES (17, '17', '17');
   151  INSERT INTO table2 (id, ref_id, d)
   152  VALUES (18, '18', '18');
   153  INSERT INTO table2 (id, ref_id, d)
   154  VALUES (19, '19', '19');
   155  INSERT INTO table2 (id, ref_id, d)
   156  VALUES (20, '20', '20');
   157  INSERT INTO table2 (id, ref_id, d)
   158  VALUES (21, '21', '21');
   159  INSERT INTO table2 (id, ref_id, d)
   160  VALUES (22, '22', '22');
   161  INSERT INTO table2 (id, ref_id, d)
   162  VALUES (23, '23', '23');
   163  INSERT INTO table2 (id, ref_id, d)
   164  VALUES (24, '24', '24');
   165  INSERT INTO table2 (id, ref_id, d)
   166  VALUES (25, '25', '25');
   167  INSERT INTO table2 (id, ref_id, d)
   168  VALUES (26, '26', '26');
   169  INSERT INTO table2 (id, ref_id, d)
   170  VALUES (27, '27', '27');
   171  INSERT INTO table2 (id, ref_id, d)
   172  VALUES (28, '28', '28');
   173  INSERT INTO table2 (id, ref_id, d)
   174  VALUES (29, '29', '29');
   175  INSERT INTO table2 (id, ref_id, d)
   176  VALUES (30, '30', '30');
   177  INSERT INTO table2 (id, ref_id, d)
   178  VALUES (31, '31', '31');
   179  INSERT INTO table2 (id, ref_id, d)
   180  VALUES (32, '32', '32');
   181  INSERT INTO table2 (id, ref_id, d)
   182  VALUES (33, '33', '33');
   183  INSERT INTO table2 (id, ref_id, d)
   184  VALUES (34, '34', '34');
   185  INSERT INTO table2 (id, ref_id, d)
   186  VALUES (35, '35', '35');
   187  INSERT INTO table2 (id, ref_id, d)
   188  VALUES (36, '36', '36');
   189  INSERT INTO table2 (id, ref_id, d)
   190  VALUES (37, '37', '37');
   191  INSERT INTO table2 (id, ref_id, d)
   192  VALUES (38, '38', '38');
   193  INSERT INTO table2 (id, ref_id, d)
   194  VALUES (39, '39', '39');
   195  INSERT INTO table2 (id, ref_id, d)
   196  VALUES (40, '40', '40');
   197  INSERT INTO table2 (id, ref_id, d)
   198  VALUES (41, '41', '41');
   199  INSERT INTO table2 (id, ref_id, d)
   200  VALUES (42, '42', '42');
   201  INSERT INTO table2 (id, ref_id, d)
   202  VALUES (43, '43', '43');
   203  INSERT INTO table2 (id, ref_id, d)
   204  VALUES (44, '44', '44');
   205  INSERT INTO table2 (id, ref_id, d)
   206  VALUES (45, '45', '45');
   207  INSERT INTO table2 (id, ref_id, d)
   208  VALUES (46, '46', '46');
   209  INSERT INTO table2 (id, ref_id, d)
   210  VALUES (47, '47', '47');
   211  INSERT INTO table2 (id, ref_id, d)
   212  VALUES (48, '48', '48');
   213  INSERT INTO table2 (id, ref_id, d)
   214  VALUES (49, '49', '49');