| Vinay Vishal | 5717147 | 2018-09-18 20:22:00 +0530 | [diff] [blame] | 1 | /* |
| 2 | * Copyright (c) 2012, 2018 Oracle and/or its affiliates. All rights reserved. |
| 3 | * |
| 4 | * This program and the accompanying materials are made available under the |
| 5 | * terms of the Eclipse Public License v. 2.0, which is available at |
| 6 | * http://www.eclipse.org/legal/epl-2.0. |
| 7 | * |
| 8 | * This Source Code may also be made available under the following Secondary |
| 9 | * Licenses when the conditions for such availability set forth in the |
| 10 | * Eclipse Public License v. 2.0 are satisfied: GNU General Public License, |
| 11 | * version 2 with the GNU Classpath Exception, which is available at |
| 12 | * https://www.gnu.org/software/classpath/license.html. |
| 13 | * |
| 14 | * SPDX-License-Identifier: EPL-2.0 OR GPL-2.0 WITH Classpath-exception-2.0 |
| 15 | */ |
| 16 | |
| 17 | CREATE TABLE SALARY ( |
| David Matějček | f4dc06a | 2021-05-17 12:10:57 +0200 | [diff] [blame^] | 18 | emp_id integer not null, |
| 19 | emp_sal float(7, 2) |
| Vinay Vishal | 5717147 | 2018-09-18 20:22:00 +0530 | [diff] [blame] | 20 | ); |
| 21 | |
| 22 | INSERT INTO SALARY VALUES(101, 11111.12); |
| 23 | INSERT INTO SALARY VALUES(102, 11221.15); |
| 24 | INSERT INTO SALARY VALUES(103, 31411.16); |
| 25 | INSERT INTO SALARY VALUES(104, 14135.72); |
| 26 | INSERT INTO SALARY VALUES(105, 61114.18); |
| 27 | |
