Write script that does the following: Turn off Autocommit Insert a new row into sec0502_departments Save this
Fantastic news! We've Found the answer you've been seeking!
Question:
Write script that does the following:
- Turn off Autocommit
- Insert a new row into sec0502_departments
- Save this change by issuing a commit command
- Insert another new row into sec0502_departments
- Undo this change by issuing a rollback command
- Display all the rows in sec0502_departments
Write script that does the following:
- Turn off Auto commit
- Insert new row into sec0503_savings_accounts with all of data from the sec0503_checking_accounts table for customer 'BOB WILKINS'
- Delete customer 'BOB WILKINS' data from the sec0503_checking_accounts table
- Commit these changes
Write script that does the following:
- Turn off Auto commit
- Update sec0503_savings_accounts to decrease the balance of customer 'FRED BOYD' by $20,000
- Update sec0503_checking_accounts to increase the balance of customer 'FRED BOYD' by $20,000
- Display all rows in sec0503_savings_accounts
- Display all rows in sec0503_checking_accounts
- Rollback these changes
Write script that does the following:
- Display all the data in sec0505_foods
- Create a view of the foods table, including all the columns and rows
- Insert a new row into the view
- Update the view, setting menu_item to 20 and description to 'CARROTS' where the description is currently 'BROCCOLI'
- Delete a row from the view
- Display all the data in the view
- Display all the data in sec0505_foods
List the names of all the tables you own.
List the names of all the views you own.
Use the Data Dictionary to find the names of all the columns of the L_EMPLOYEEStable.
Use the Data Dictionary to find the primary key of the L_EMPLOYEES table.
Related Book For
Database Systems Design Implementation and Management
ISBN: 978-1285196145
11th edition
Authors: Carlos Coronel, Steven Morris
Posted Date: