Question:
Purge Guest Table Content
The resort management wants to purge all the records from the “Guest “table. Write an SQL statement to purge all the records from the guest table without allowing rollback activity.
CODE:–
truncate table Guest;
Tags:
rdbms programs | rdbms programs with output | rdbms programming languages | rdbms database program
Related Post
Alter table payments program in SQL Question:Alter table paymentsWrite a query to rename a column from bd_id to booking_id in the
Insert Records Payments in SQL Question:Contains the run and evaluate script of Oracle DML. Can be used as exampleInsert the
Create SCHEDULE table program in SQL Question:Create SCHEDULE tableRefer the below schema and create the SCHEDULE.Column NameDatatUpdate Buses table in SQLQuestion:Update Buses tableContains the run and evaluate script of Oracle DML. Can be used as examp
ConversionConversion EmoticonEmoticon