Create

drop table cities;
create table cities (id varchar2 (10), name varchar2 (20), population number (10), date_mod date);
quit;


Insert

insert into cities values ('t0131','函館',51742,'2001-7-12');
insert into cities values ('t0132','札幌',45391,'2001-8-5');
insert into cities values ('t0133','帯広',31548,'2001-10-23');
insert into cities values ('t0134','釧路',24179,'2001-3-14');
insert into cities values ('t0135','旭川',81276,'2001-11-8');
insert into cities values ('t0136','北見',78615,'2001-2-4');
insert into cities values ('t0137','室蘭',65491,'2001-8-6');
insert into cities values ('t0138','根室',42783,'2001-6-25');
insert into cities values ('t0139','稚内',35827,'2001-12-30');
quit;

Read

set heading off;
set linesize 160;
select id,name,population,date_mod from cities;
quit;