Farshid ShekariMulti Table InsertionWhen working with relational databases, inserting data into multiple tables can be a challenging task that requires several SQL statements…Jun 28, 20232Jun 28, 20232
Farshid ShekariDML Error LoggingSuppose, you're going to insert/update data from an old version of the working table or some join from related tables into the currently…Apr 20, 2023Apr 20, 2023
Farshid ShekariAutonomous TransactionAs you know about transactions in database systems, the transaction is an atomic unit of work and should be done or terminated and rolled…Mar 3, 2023Mar 3, 2023
Farshid ShekariHow can I create a column with auto increment in the Oracle database?In this essay, I’m going to introduce ways to outsource the filling of the table’s column value.Feb 10, 2023Feb 10, 2023