1 CREATE TABLE t1 (f1 number(4), f2 number(9) , f3 number(30) , f4 CHAR (10), f5 FLOAT , primary key (f1) );
2 INSERT INTO t1 VALUES(1, 1, 1, 'Govind', 100.111);
3 INSERT INTO t1 VALUES(2, 2, 2, 'Gopal', 200.222);
4 INSERT INTO t1 VALUES(3, 3, 3, 'kishor', 300.333);
5 INSERT INTO t1 VALUES(4, 4, 4, 'kiran', 400.444);
6 INSERT INTO t1 VALUES(5, 5, 5, 'ganesh', 500.555);