Table Create & Data insert & Query

create table institution
 (
 int_id number(10),
 name varchar(20),
 post varchar(10),
 city varchar(10),
 state varchar(15),
 country varchar(20)
 );

Table created.


insert into institution
values(21,'asian univarsity','uttara','dhaka','dhaka','bangladesh');



insert into institution
values(21,'rajshahiunivarsity','uttara','dhaka','dhaka','bangladesh');










select *from institution;

    INT_ID NAME                 POST       CITY       STATE
---------- -------------------- ---------- ---------- ---------------
COUNTRY
--------------------
        21 asian univarsity     uttara     dhaka      dhaka
bangladesh

        21 rajshahiunivarsity   uttara     dhaka      dhaka
bangladesh











insert into institution
values(21,'rajshahi collage','uttara','dhaka','dhaka','bangladesh');


1 row created.













select *from institution;

    INT_ID NAME                 POST       CITY       STATE
---------- -------------------- ---------- ---------- ---------------
COUNTRY
--------------------
        21 asian univarsity     uttara     dhaka      dhaka
bangladesh

        21 rajshahiunivarsity   uttara     dhaka      dhaka
bangladesh

        21 rajshahi collage     uttara     dhaka      dhaka
bangladesh