Question:
Insert Records into Resort table
Insert the following records into “Resort ” table based on schema below.
RESORTID | RESORTNAME | STREET | TOWNNAME | TOWNID | STARRATING | MANAGERID |
1001 | TREE OF LIFE RESORT | KACHERAWALA KOOKAS | JAIPUR | 3 | 3.8 | 2 |
1002 | PALETTE RESORTS | LAKE VIEW ROAD NALLVADU POST | PONDICHERRY | 2 | 4.3 | 2 |
1003 | GRAND GRT | SIR THEAGARAYA RD THAGAR | CHENNAI | 1 | 4.4 | 1 |
1004 | GREEN COCONUT | EAST COAST ROAD, MAHABALIPUR AM | CHENNAI | 1 | 3.7 | 1 |
CODE:–
insert into Resort values(1001, 'TREE OF LIFE RESORT', 'KACHERAWALA KOOKAS', 'JAIPUR', 3, 3.8, 2);
insert into Resort values(1002,'PALETTE RESORTS', 'LAKE VIEW ROAD NALLVADU POST', 'PONDICHERRY', 2, 4.3, 2);
insert into Resort values(1003, 'GRAND GRT', 'SIR THEAGARAYA RD TNAGAR', 'CHENNAI', 1, 4.4, 1);
insert into Resort values(1004, 'GREEN COCONUT', 'EAST COAST ROAD,MAHABALIPURAM', 'CHENNAI', 1, 3.7, 1);
rdbms programs | rdbms database program | relational database management system software | rdbms lab programs | rdbms lab programs pdf | dbms programs | database management software | database management system software | examples of database software| list of database applications | database system applications | examples of database | application database application software | database management application
ConversionConversion EmoticonEmoticon