People and Culture Blog

Query To Get Archive Log Apply Rate Speed of a Standby Database

Query To Get Archive Log Apply Rate Speed of a Standby Database   set linesize 180 col Values for a70 col Recovery_start for a21 select to_char(START_TIME,’dd.mm.yyyy hh24:mi:ss’) “Recovery_start”, to_char(item)||’ =…

Read More

Query to check user session statistics

Query to check user session statistics col pid format 9999 heading ‘PID’ col spid format a6 heading ‘SERVER|PID’ col sid format 9999 heading ‘SID’ col serial# format 99999 heading ‘SERIAL’…

Read More

Globalization

Globalization   The following are list of types under Globalization on the Shared Components page. Globalization Attributes Text Messages Translate Application   1.Globalization Attributes We can develop applications that can…

Read More

Application Logic

The application Logic is one of the module in Shared components,It consists of different types of features as below Application Definition Attributes Application Items Application Process Application Computations Application Settings…

Read More

Sending Email Using UTL SMTP

1.   Overview This document talks about the utl_smtp package is used to send e-mails from any database to a valid recipient/recipients with or without attachments. 2.  Technologies and Tools Used…

Read More

Oracle Apex Custom Tool Tip for Report Columns

1.          Overview This document talks about how to show the custom tooltip in report columns 2.          Technologies and Tools Used The following technology has been used to achieve Custom Notifications…

Read More

Oracle Apex Flexible Region Plugin

1.Overview This Flexible Region Plugin can be used for various business requirements to see the data in multiple dimensions. The user can able to dynamically choose the objects like tables…

Read More

Oracle Apex Custom Tool Tip for Report Columns

  1.Overview This document talks about how to show the custom tooltip in report columns 2.Technologies and Tools Used The following technology has been used to achieve Custom Notifications Oracle…

Read More

Oracle Apex Custom Notifications

1.Overview This document talks about how to use the apex error notifications & to manage into custom error messages. 2.Technologies and Tools Used The following technology has been used to…

Read More

Download Blob Files Using PLSQL

1.Overview This document talks about the utl_smtp package is used to download the BLOB Files in Oracle apex reports 2.Technologies and Tools Used The following technology has been used to…

Read More