Database Blog

Script to determine the high water mark of tables

TO CHECK THE HIGH WATER MARK LEVEL OF TABLES set verify off col table_name for a20; column owner format a10 column alcblks heading ‘Allocated|Blocks’ just c column usdblks heading ‘Used|Blocks’…

Read More

ORA-01741: illegal zero-length identifier

Posted by : Saravanan   Introduction This Post demonstrates about error ORA-01741 : illegal zero-length identifier Scenario While adding multiple schemas to a single workspace, we get the following error in…

Read More

Installing various Database Components

Posted by : Mahe This Post describes about Installing various Database Components   col COMP_ID for a20 col VERSION for a15 col STATUS for a10 col COMP_NAME for a40 select COMP_ID,…

Read More

Oracle Cloud Infrastructure New Feature – Block Volume user-defined backup policies

Oracle introduced new feature/functionality to Oracle cloud infrastructure Block Volume services scheduled backups feature – User defined Backup policies. Using this feature we can create our own/custom backup policies for…

Read More

Configuring APEX to use BI Publisher

Introduction           We will see about how to configuring apex to use bi publisher in Details with steps to follow.  Steps To Follow         To use BI Publisher as your…

Read More

Append the Data Base value to Tabular Form Read only Column

 Introduction           We can see about append the data base value to tabular form read only column. Steps To Follow              Get the interactive repot table id Example : var…

Read More

Hide the Report Column based on User Condition

Introduction The Interactive Reporting Region is an innovative new technology that allows end users to customize reports.In Interactive Reporting we can hide the report column based on user condition.  …

Read More

Apex Interactive Report Look and Feel

Introduction           In Apex Interactive Report design, look and feel is a term used with respect to a graphical user interface and comprises aspects of its design, including elements such…

Read More

Integrating With Fusion Application Using Services (APEX)

Introduction              Fusion Applications provides web services that allow external systems to integrate with Fusion Applications. There are two types of services: ADF services and composite services. ADF services are…

Read More

Multiple User Interface for Oracle APEX

Introduction         User Interfaces Within a single Application you can have Desktop and Mobile Pages with individual Themes each That means an Application can have multiple active Themes Pages and…

Read More