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.