To create a database table using Create, Desc, Insert and select command.

Experiment-01

Object: To create a database table using Create, Desc, Insert and select command.

Requirement: windows XP, Oracle 9i.

Program Code:

SQL>Create table avneesh

     2 (stu_name   char(20),

     3 stu_id           number(15),

     4 stu_email     varchar2(20),

     5 stu_add        varchar2(30));

Table Create

SQL>Insert  into  avneesh  values(‘avneesh’,’1031030015’,’avneeshsrm@hotmail.com’,’varanasi’);

1.row created

SQL>Insert  into  avneesh  values(‘abhishek’,’1031030009’,’abhishekawasthi@gmail.com’,’lucknow’);

1.row created

SQL>Insert  into  avneesh  values(‘abhinav’,’1031030008’,’abhinav@gmail.com’,’ranchi’);

1.row created

Output:

SQL>desc avneesh;

Name                                                Null?    Type

--------- -------------------- --------------------

stu_name                                                   char(20)

stu_id                                                          number(15)

 stu_email                                                  varchar2(20)

 stu_add                                                      varchar2(30))

SQL> select * from avneesh

stu_name                 stu_id               stu_email                 stu_add                                                                                                                                                                    

--------- -------------------- ----------------------------------

Avneesh           1031030015     avneeshsrm@hotmail.com    Varanasi

Abhishek      1031030009     abhishekawasthi@gmail.com  lucknow

Abhinav        1031030008     abhinav@gmail.com               ranchi 

Result:The above program  was created executed successfully without any error.