14
July
Oracle Cloud
[embeddoc url="http://ids-sol.co.uk/wp-content/uploads/2017/07/Oracle-Cloud-Platform-1.pdf" download="all"]...
Read More
Oracle DB
04
May
Custom Sorting to OBIEE 11g
May 4, 2017
Custom Sorting to Column values in Pivot table Custom Sorting In Pivot Table: We have order status and the transactional amount. The requirement is to show the transactional amount across the three different order status: 1.Booked 2.Cancelled 3.Closed User wants the order status to be sorted in the report as below: 1.Closed 2.Cancelled 3.Booked By...
Read More
04
December
ORACLE DVD 12.2.2
December 4, 2016
ORACLE DATA VISUALIZER DESKTOP (DVD) Installation Oracle have recently released a desktop version of their Data Visualizer tool – which had until now just been a browser based tool available in an OBIEE 12c installation or the two BI Cloud or DV Cloud services. The current version...
Read More
27
November
Invisible Columns in Oracle Database 12c
November 27, 2016
In Oracle DB
In Oracle Database 12c, you can set a column in table as invisible either during CREATE TABLE or modifying existing table via ALTER TABLE command. By default, table columns are always visible. When you make it invisible, the COL# column in COL$ dictionary is updated...
Read More
22
November
ORACLE DB Upgrade
ORACLE Database Upgrade 11.2.0.1 to 11.2.0.4.0 download the software Oracle 11.2.0.1.0 from oracle support [root@oranode1 ~]# /u01/app/oracle/product/11.2.0/dbhome_2/root.sh Performing root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/11.2.0/dbhome_2 Enter the full pathname of the local bin directory: [/usr/local/bin]: y Creating y directory...
Read More