Query to Find the Second highest salary of an Employee

How to find the employee whose salary is second highest. For example, in the EMP table, “JONES” has the second-highest salary as 3065.00. 

Let's check out few ways to find the second highest salary from the emp table.

Oracle SQL Performance Tuning Best Practices

 Before starting get a clear understanding and quantitative definition of the issue.

Below are some points to be considered for oracle SQL performance tuning   .

Explain XML Publisher Reports in Oracle Apps |Oracle E-Business Suite

XML Publisher Reports has two components.

• Data Definition
• Template

Data Definition:

Data definition is a component that pulls out data from a data source and generates the data file in an XML format with a user-defined structure.

Template:

The template is a layout that can be designed using Word or Excel.

How to Recover Dropped PACKAGE, PROCEDURE OR FUNCTION.

This might happen to anyone who are developing a code, there might be chances that you accidentally dropped your code or accidentally overwritten the code.

Oracle has provided various flashback features through which you can recover your code.

Now let us see how to recover your code.

I have created a sample function as shown below.

CREATE OR REPLACE FUNCTION APPS.FLASHTEST

RETURN DATE

IS

result DATE;

BEGIN

result:=NULL;

How to create a XMLTYPE data type in Oracle

XMLTYPE in Oracle

XMLTYPE is a data type in oracle. Oracle has made this data type for storing the XML message, this data type is made up of CLOB which can store XML data.

Let us check how to use XMLTYPE.

1)   Creating table column using XMLTYPE

CREATE TABLE XMLTEST2

(ID NUMBER,

XMLDATA XMLTYPE,

NAME VARCHAR2(50)

);

How to Find Last Query in Forms and OAF |Oracle E-Business Suite

Find Last Query executed in form and OAF Page.

Let us check in Forms

The data presented in forms and Oaf page is through database query only, so if you want to find the database query which was executed to get the data then you need to follow the below steps.  

è Open the form and query the record.

è Then go to HELPà DiagnosticsàExamine.

Enable Diagnostics, Personalization and Profile Options in OAF and FORMS

Enable Diagnostics and Personalization.

How to enable Diagnostics and Personalization link in Form and OAF page.

First let us check for OAF pages.

As a normal user the “Personalization”, “About this Page” and “Diagnostics” links are disabled and these can be managed with the below profile options.