Introduction To Latch in Oracle Database Latches are low-level serialization mechanisms used to protect shared data structures in the Oracle SGA. The implementation of latches is operating system-dependent, particularly in regard to whether a process will wait for a latch and for how long. A latch is a type of lock that can be very …
Latches and Mutex in Oracle database Read More »
Introduction to Oracle sql decode In this section, we will discuss about Oracle decode processing which is a very important aspect of Oracle sql statement Oracle decode is the method in the Oracle database to transform data values from one value to another which is better to understand. Oracle Decode transforms data values at retrieval time. It …
What is Active Dataguard in Oracle Operations which are Allowed On a Read-Only Database(Active Dataguard in Oracle) (1)Issue SELECT statements, including queries that require multiple sorts that leverage TEMP segments(2) Use ALTER SESSION and ALTER SYSTEM statements, Use SET ROLE(3)Call stored procedures(4) Use database links (dblinks) to write to remote databases(5) Use stored procedures to …
What is Foreign key Foreign key in Oracle is a way to relate multiple Tables. It is a cross-linking between the tables. A foreign key is a column or set of column which refers to the primary key or Unique key in the same table or another table Foreign key values are based on data …
Object dependency is important to understand in Oracle. It basically tells the parent-child relationship between the objects. Let’s understand with an example. We create one table CREATE TABLE DEPT_MASTER ( dept_nr NUMBER UNIQUE, dept_name varchar2(100) NOT NULL, dept_status NUMBER(1,0) NOT NULL, created_at date ); Right now this table is alone and it is not dependent …
Many times, we may need to check the data stored in the blob field in the table. If you just do select, it will not give you proper output. Here are some of the ways on How to select blob from table Using sqlplus select BLOB_FIELD from <table name> where ID = ‘<row id>’; SELECT …
How to select blob from table Read More »
