Tag Archives: Oracle

Dynamic Version Controlling of Oracle Metadata using shell script

In this blog, we will see how we can automate the process of moving Oracle metadata to version control system, in my case I am using GIT using a simple shell script to avoid manual intervention. The general process of code movement to Higher environments During any development process for any organization, the critical part […]
Read More »

Cursor in Oracle

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the set of data returned by the SQL statement. In PLSQL a cursor is […]
Read More »