Sql queries for create table and insert elements into table and display table

Create:

        Queries 

        SQL query 

           Create table smobile1(emino varchar2(20),name varchar2(20) not null,os varchar2(10) not null,ram varchar2 (20) not null,I memory varchar2(20) not null,coast number(30),primary key (emino) , CHECK (emino like 'e%'));

Table created.

Insert:

    Queries

             insert into smobile1 values('emi435','gs5','android','1gb','4gb',40000);

             insert into smobile1 values ('emi435','gs5','android','1gb','16gb',40000);

             insert into smobile1 values
                    ('emi436','gs4','android','4gb','16gb',40000);

             insert into smobile1 values
                    ('emi5431','gs4','android','2gb','16gb',30000);
         
             insert into smobile1 values
                   ('emi541','gs4','android','android','2gb','16gb',3000);
........,.......
..........

Display:

     Query

          Select *from smobile;

How to create a website
Click www.lapcode.blogspot.com
      http://www.YouTube.com/OurLifeStyle