1 CREATE TABLE t1 (f1 SMALLINT, f2 INT , f3 BIGINT , f4 CHAR (10), f5 FLOAT, primary key (f1) );
2 INSERT INTO t1 VALUES(1, 2011, 111111111, 'Govind', 113.141);
3 INSERT INTO t1 VALUES(2, 1978, 222222222, 'Gopal', 114.567);
4 INSERT INTO t1 VALUES(3, 2008, 333333333, 'kishor', 122.700);
5 INSERT INTO t1 VALUES(4, 1973, 444444444, 'kiran', 142.718);
6 INSERT INTO t1 VALUES(5, 2005, 555555555, 'ganesh', 152.718);
7 INSERT INTO t1 VALUES(6, 1962, 666666666, 'suresh', 162.718);
8 INSERT INTO t1 VALUES(7, 1965, 777777777, 'Praba', 172.718);
9 INSERT INTO t1 VALUES(8, 1942, 888888888, 'karan', 182.718);
10 INSERT INTO t1 VALUES(9, 1956, 999999999, 'sharan', 192.718);
11 INSERT INTO t1 VALUES(10, 1999,101010101, 'vijay', 102.718);