CREATE TABLE VEHICLES IN SQL

SQL> CREATE TABLE VEHICLES(VNUMBER NUMBER(10),VNAME CHAR(10));

Table created.

SQL> DESC VEHICLES;

 Name                                      Null?    Type

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

 VNUMBER                                            NUMBER(10)

 VNAME                                                 CHAR(10)

SQL> INSERT INTO VEHICLES VALUES(502,'JEEP');

1 row created.

SQL> INSERT INTO VEHICLES VALUES(&VNUMBER,'&VNAME');

Enter value for vnumber: 602

Enter value for vname: CAR

old   1: INSERT INTO VEHICLES VALUES(&VNUMBER,'&VNAME')

new   1: INSERT INTO VEHICLES VALUES(602,'CAR')

1 row created.

SQL> /

Enter value for vnumber: 702

Enter value for vname: BUS

old   1: INSERT INTO VEHICLES VALUES(&VNUMBER,'&VNAME')

new   1: INSERT INTO VEHICLES VALUES(702,'BUS')

1 row created.

SQL> /

Enter value for vnumber: 802

Enter value for vname: ACTIVA

old   1: INSERT INTO VEHICLES VALUES(&VNUMBER,'&VNAME')

new   1: INSERT INTO VEHICLES VALUES(802,'ACTIVA')

1 row created.

SQL> COMMIT;

Commit complete.

SQL> SELECT * FROM VEHICLES;

   VNUMBER   VNAME

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

       502             JEEP

       602             CAR

       702             BUS

       802             ACTIVA