Archive for the ‘Databases’ Category

Creating scheduled jobs in ORACLE

Share

When you need to run an ORACLE DB task every day the best choice is to use the Scheduler. Scheduled Jobs can be used to run PL/SQL Blocks, Stored Procedures or even scripts. To setup the job, we need to fill in some mandatory fields:

Share


Liferay 6.2 – Installation Guide

Share

Hello! In this tutorial I will tell you how to install and configure Liferay 6.2 with Eclipse.

Share
Tags:        

ETL concepts

Share

Over the years large amounts of data have been stored for business purposes. To turn this data into consistent and accurate information for a specific use, it somehow needs to be transformed. And so we get to the ETL concept …

Share


SQL : Updating Oracle table with data using subquery

Share

In Oracle Database 11g , when you need to update values of certain records from one table,  and the value and the records to update are determined by a second table, you can use a subquery in the update statement to achieve the update. Using “EMPLOYEE”  and “EMPLOYEE_STAGING”  tables as an example , we want […]

Share


SQL Injection. How to prevent it from happening in PHP.

Share

SQL injection as a matter of security can be approached from multiple angles. One must first be sure that the targeted application has a confidential database structure, since this is the main thing that makes SQL injection possible. Also, it’s important to notice that SQL injection is not something that happens arbitrary or from time […]

Share


SQL : Concatenating multiple rows into a single string

Share

In some occasions it is necessary to concatenate data from a number of rows into a single row. Using HR.DEMO table as an example , we want to retrieve a list of employees for each department. Base Data :   Desired Output :  

Share


Oracle OpenWorld 2011

Share

October 2-6, Moscone Center, San Francisco. “Oracle OpenWorld is the most cost-effective and efficient way to stay ahead of the technology curve.” Why not believe it? When tens of thousands of people attend,  you have thousands of sessions to choose from, you can enjoy membership in a global community of Oracle technologists, customers and partners […]

Share
Tags:   

How to create a SQL Server Agent Job (Transact-SQL) – with only needed fields

Share

In this post you will see two major sections: I. Detailed description for every needed field in system stored procedures. II. Full working example related to above description. Here you need only to replace the names if the default configuration is suitable.

Share
Tags:  

Installing Oracle Business Intelligence Enterprise Edition (OBIEE) 11g prerequisites

Share

There are a few steps to complete before you can start with OBIEE 11g installation. This demo describes the steps required on a Windows system and requires

Share
Tags:    

The Repository Creation Utility (RCU)

Share

RCU is used to install certain schemas in a database that are required by Fusion Middleware products like Oracle Business Intelligence. Accepted database types are Oracle Database, IBM DB2 and Microsoft SQL Server. The steps required to run RCU

Share
Tags: