Insert Records into Resort table in SQL


Question:

Insert Records into Resort table

Insert the following records into “Resort ” table based on schema below.

RESORTIDRESORTNAMESTREETTOWNNAMETOWNIDSTARRATINGMANAGERID
1001TREE OF LIFE RESORTKACHERAWALA KOOKASJAIPUR33.82
1002PALETTE RESORTSLAKE VIEW ROAD NALLVADU POSTPONDICHERRY24.32
1003GRAND GRTSIR THEAGARAYA RD THAGARCHENNAI14.41
1004GREEN COCONUTEAST COAST ROAD, MAHABALIPUR AMCHENNAI13.71




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

best dbms software |  software that is used to create | manipulate and maintain a relational database | database management system application

Tags:- rdbms programs with output | rdbms programs pdf  | dbms programs examples | rdbms lab programs | rdbms lab programs pdf | rdbms practical programs | rdbms practical programs pdf | rdbms sample programs | rdbms program | rdbms system| rdbms lab programs madras university | rdbms online programs | rdbms lab programs with output | rdbms procedure program | rdbms sql programs | code | solution | codechef | 2021

Previous
Next Post »