Q. Answer the questions based on the table Flight given below: [CBSE D 05 : 2marks]
Table: flight
Table: flight
| Column Name | Data type | Size | Constraint | Description |
| Flight_no | NUMBER | 4 | PRIMARY KEY | Flight number |
| Origin | VARCHAR2 | 30 | NOT NULL | Place of origin of flight |
| Destination | VARCHAR2 | 30 | NOT NULL | Destination of the flight |
| Seats | NUMBER | 3 | -- | No. of seats available |
| Flt_date | DATE | -- | -- | Date of flight |
| Rate | NUMBER | 7,2 | -- | Rate of a ticket on the flight |
Write a code/statements to increase the Rate of all the flights by 5%.
0 Comments