Installing RHEL 7.1 (Maipo) on Oracle VM VirtualBox - Part 2

InstallingRHEL01
InstallingRHEL02
InstallingRHEL03
InstallingRHEL04
InstallingRHEL05
InstallingRHEL0601
InstallingRHEL0602
InstallingRHEL0603
InstallingRHEL0604
InstallingRHEL0605
InstallingRHEL06
InstallingRHEL07
InstallingRHEL08
InstallingRHEL09
InstallingRHEL10

On this blog I will go through the steps required to boot the RHEL 7.1 installation media and complete an installation of a typical WEB server.

If you need help setting up your Oracle VirtualBox VM before starting the install, please che out this other post: Installing RHEL 7.1 (Maipo) on Oracle VM VirtualBox

Continue reading
  0 Comments

Records and Pseudo Records in PL/SQL

How about this.. you can create a composite data structure in pl/sql which can hold an entire row's data. Records are made up of one or more fields of same or different datatypes, same as a row in a table.

Example:

Continue reading
  0 Comments

Installing RHEL 7.1 (Maipo) on Oracle VM VirtualBox

InstallingRHEL01
InstallingRHEL02
InstallingRHEL03
InstallingRHEL04
InstallingRHEL05
InstallingRHEL06
InstallingRHEL07
InstallingRHEL08
InstallingRHEL09
InstallingRHEL10
InstallingRHEL11
InstallingRHEL12

The purpose of the following guide will be to provide a simple step by step guide on how to install RedHat Enterprise Linux 7.1 over an Oracle VirtualBox VM.

You will need to meet the following pre requisites before you can folow this guide.

Continue reading
  0 Comments

Hyperion Planning Performance Tunning Automate

Performance Tuning Process Description thru a bat using mxl scripts:Process steps of “Name_as_desire.bat”The batch will run the “Name_as_desire.mxl” this will export the data of the cube at level 0.The batch will run the another batch “Name_as_desire.bat” if the export runs correctly, then this batch will be excecuted.The batch will run the “Name_as_desire.mxl” this will defrag the application and import the data, and will execute 3 calcscripts that will......

                                                    Code at the first batch

1. Variables configuration that will be used at the rest of the code:

Continue reading
  0 Comments

Difference between DETETE, DROP and TRUNCATE Commands in SQL

I had some difficulty working with these 3 commands back when I was learning SQL particularly when deciding which one to use. SO, I've dedicated this blog to differentiating the three of them.

DELETE: used to remove rows selectively from a table. Delete is a DML command, so it will cause any delete triggers on the table to fire. You may need to explicitly commit after deleting from a table to make changes permanent.

Continue reading
  0 Comments