CREATE TABLE RESULT IN SQL

SQL> CREATE TABLE RESULT(ROLLNO INT,NAME CHAR(30),MARKS INT);

Table created.

SQL> DESC RESULT;

 Name                                      Null?    Type

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

 ROLLNO                                             NUMBER(38)

 NAME                                                CHAR(30)

 MARKS                                              NUMBER(38)

SQL> COMMIT;

Commit complete.

SQL> SELECT * FROM RESULT;

no rows selected

SQL> INSERT INTO RESULT VALUES(1,'SANKET',999);

1 row created.

SQL> INSERT INTO RESULT VALUES(&ROLLNO,'&NAME',&MARKS)

  2  ;

Enter value for rollno: 2

Enter value for name: SANKET2

Enter value for marks: 888

old   1: INSERT INTO RESULT VALUES(&ROLLNO,'&NAME',&MARKS)

new   1: INSERT INTO RESULT VALUES(2,'SANKET2',888)

1 row created.

SQL> /

Enter value for rollno: 3

Enter value for name: SANKET3

Enter value for marks: 777

old   1: INSERT INTO RESULT VALUES(&ROLLNO,'&NAME',&MARKS)

new   1: INSERT INTO RESULT VALUES(3,'SANKET3',777)

1 row created.

SQL> /

Enter value for rollno: 4

Enter value for name: SANKET4

Enter value for marks: 888

old   1: INSERT INTO RESULT VALUES(&ROLLNO,'&NAME',&MARKS)

new   1: INSERT INTO RESULT VALUES(4,'SANKET4',888)

1 row created.

SQL> COMMIT;

Commit complete.

SQL> SELECT * FROM RESULT;

    ROLLNO NAME                              MARKS

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

         1        SANKET                            999

         2        SANKET2                          888

         3        SANKET3                          777

         4         SANKET4                           888