Day: February 17, 2022

Exercises – Database Operations

Exercises – Database Operations¶ Let’s create a table and perform database operations using direct SQL. Exercise 1 – Create Table¶ Create table – courses course_id – sequence generated integer and primary key course_name – which holds alpha numeric or string values up to 60 characters course_author – which holds the name of the author up …

Exercises – Database Operations Read More »

Overview of Transactions

Overview of Transactions¶ Let us go through the details related to Transactions.* We typically perform operations such as COMMIT and ROLLBACK via the applications. COMMIT will persist the changes in the database. ROLLBACK will revert the uncommitted changes in the database. We typically rollback the uncommitted changes in a transaction if there is any exception …

Overview of Transactions Read More »