Tuesday, 28 January 2014


Virtual Column is one of the new features introduced in Oracle 11g.The syntax for defining a virtual column is:

Column_Name [Datatype] [GENERATED ALWAYS] AS [Expression] [VIRTUAL]

Here, Data type: Column’s Data Type and Expression: SQL Expression

Though Virtual Columns appear to be like normal table columns they are defined by an expression and they derive their value from the result of the expression. The values of these virtual columns are not stored in database; instead they are calculated at run time dynamically.

Wednesday, 22 January 2014

GROUPING Function In Oracle

The Grouping function can be used with either the cube or rollup operator.  Using this function we can find the basis on which the groups are formed and it’s subtotal. It accepts a single column as a parameter and returns numeric values to identify the column value in an aggregated row. It returns 1 if the column contains a null value generated as part of a subtotal by a ROLLUP or CUBE operation and zero if it is NOT NULL

Sunday, 19 January 2014

OBIEE New Features

OBIEE has been released by Oracle and they included more than two hundred enhancements, designed to add new functionality for improved performance and deliver an enhanced end user experience.
The major features and enhancements are listed down based on my reading and collection from various online portals and articles.
Check it out!!!

1. New UI Features:

a. New graphs: Performance Tile, Waterfall, and 100 percent stacked bar

  • A feature taken from Endeca
  • Breadcrumbs have been added to help users understand their current location within Oracle BI content and the path that they have used to navigate Oracle BI content.
  • Breadcrumbs display at the bottom of the page, and users can click a breadcrumb or the breadcrumb overflow button to navigate to a specific location on their breadcrumb trail.
c. Enhancement to Dashboards - This release provides the following enhancements to dashboards:
  • The ability to create custom print layouts for high-fidelity printing of dashboard pages (i.e. automatic creation BI Publisher reports or by integration with BI Publisher).
  • The new default style is FusionFX(instead of "BLAF : Browser Look and Feel")
  • The Freeze Column option under the Column Properties menu is newly added feature in OBIEE11.1.1.7. This option allows you to freeze a column at an edge (top or left) of a dashboard layout.
  • The newly added option listed down allow us to control the position and size of columns and sections: 
o    Size option in the Additional Formatting Options area of the "Section Properties dialog" and the "Column Properties dialog"
o    Page Size option in the "Dashboard Properties dialog

Thursday, 9 January 2014

Hierarchical Retrieval In ORACLE or Hierarchical Queries

There is provision to display the reporting pattern in an organization.  In the select query we can use the level (pseudocolumn), which returns 1 for a root row and 2 for a child of a root and so on.The start with clause specifies the root of the rows. Connect by specifies relationship between the parent and the child prior clause is required for a hierarchical query.


Tuesday, 7 January 2014


UNIX computer operating system (A command Line based OS) was developed in early 1970’s at Bell Laboratories in the USA.
Because of the High reliability, scalability and powerful features UNIX remains as popular operating system. Some of big companies like Sun Microsystems, Apple Inc., Hewlett-Packard and AT&T, which is the original (parent company) uses UNIX. 

Depending on the kind of use of UNIX  has both Advantages and Disadvantages. Talking about the Advantages:

Related Posts Plugin for WordPress, Blogger...