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 […]
How to use Decode in Oracle Read More »
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
Active Dataguard in Oracle Read More »
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
How to use foreign key in oracle Read More »
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
Query to find object dependencies in oracle Read More »
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 »
AUD$ table is used in oracle to store the auditing information. Auditing can be enabled for CREATE SESSION, LOGON, LOGOFF, SELECT, INSERT, DELETE statement You can enable auditing only when the AUDIT_TRAIL parameter is set to either DB or DB_EXTENDED value. You can check the parameter value as sqlplus / as sysdbashow parameter AUDIT_TRAIL 11g
How to purge SYS.AUD$ table in Oracle Read More »
