CREATE TABLE STUDENT DATABASE IN SQL

SQL> CREATE TABLE STUDENT18(ROLLNO INT,NAME CHAR(30),SUBJECT CHAR(20),SEMESTER INT );

Table created.

SQL> DESC STUDENT18;

 Name                                      Null?    Type

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

 ROLLNO                                             NUMBER(38)

 NAME                                                CHAR(30)

 SUBJECT                                            CHAR(20)

 SEMESTER                                         NUMBER(38)

SQL> INSERT INTO STUDENT18 VALUES(2,'SANKET2','WDP',2);

1 row created.

SQL> INSERT INTO STUDENT18 VALUES(&ROLLNO,'&NAME','&SUBJECT',&SEMESTER);

Enter value for rollno: 3

Enter value for name: SANKET3

Enter value for subject: DCN

Enter value for semester: 2

old   1: INSERT INTO STUDENT18 VALUES(&ROLLNO,'&NAME','&SUBJECT',&SEMESTER)

new   1: INSERT INTO STUDENT18 VALUES(3,'SANKET3','DCN',2)

1 row created.

SQL> /

Enter value for rollno: 4

Enter value for name: SANKET4

Enter value for subject: MMC

Enter value for semester: 2

old   1: INSERT INTO STUDENT18 VALUES(&ROLLNO,'&NAME','&SUBJECT',&SEMESTER)

new   1: INSERT INTO STUDENT18 VALUES(4,'SANKET4','MMC',2)

1 row created.

SQL> COMMIT;

Commit complete.

SQL> SELECT * FROM STUDENT18;

    ROLLNO NAME                   SUBJECT                SEMESTER

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

         2 SANKET2                        WDP                            2

         3 SANKET3                        DCN                             2

         4 SANKET4                        MMC                           2