These are some DB syntax to automate date in your queries. SYSDATE()   - Today’s date FIRST_DAY_OF_MONTH() - First day of the current ...

Oracle is moving ahead with the ODI integration to the BI Package, in the words of Oracle, "With the 11.1.1.7.1 release of the Orac...

 This article is dealing only with BIP Standalone and reader should not get confused with OBIEE+BIPublisher Port setting. 1. Locate the ...

To clone your biserver in OBIEE 11G login to your Weblogic Admin Console, from bifoundation_domain select Environments and follow the steps...

Local temporary tables are valid within Modules/Schema and are bound to active SQL sessions. The syntax to create a Local Temporary table...

The basic syntax for Sub-String in oracle sql is "SUBSTR(string/column/field,start_position,length)" and this function is a...

This is an which usually occur during the installation of Siebel Client in XP/WIN Server 2003. While installing the client siebel Opens up ...