It is possible to create a batch of SQL statements that run on Microsoft SQL Server by separating each SQL statement with a semicolon (;). You can achieve similar results when you run Oracle with either the OLE-DB Oracle Provider or Oracle driver (provided with the Microsoft Visual Database Tools) i

(Michael Klaene) PL/SQL applications typically consist of SQL statements intermixed with procedural logic to process data retreived from the database. If compiled as a stored procedure, your PL/SQL code will reside on the server, an ideal place for programs that require intensive database interactio

(Laura Rohde) Oracle recently released its stand-alone Business Intelligence 10g product, which offers tools for queries, reporting and analysis, data integration and management, and application development.

(Casimir Santeros) The scenario: You receive an email with an attached Excel spreadsheet from your manager. Your task? Get the data in the spreadsheet loaded into the company Oracle 9i/10g database. How will you proceed? Will you write a custom application to load the data? Will you use the SQL*Load

(Arup Nanda) Users at Acme Bank were complaining that typical and repeated queries were taking too long to execute. Because these queries are executed over and over by many users, any improvement in response time is bound to help.

Efficient extraction, transformation and loading (ETL) of data into your data warehouse is a pre-requisite for successful business intelligence solutions. Oracle Warehouse Builder helps you turn data into quality information, managing the full life-cycle from data warehouse design to information acc

(Debu Panda) Many software projects fail to deliver a high-quality product due to a lack of testing. Often, testing is either an afterthought or gets cut back when the project delivery schedule becomes tight. Furthermore, developers think they’re responsible only for developing application modules a

(T.N.V.R.L.S Gupta) You can run this script on any Oracle version of database to find out the lock details. (script)

(James Koopmann) In the previous article, we looked at the terminology around globalization, mostly from outside Oracle. This article will take a look at the internal parameters available within Oracle that we will need to become familiar with.

(Ravi Nookala) This tip is useful for making a backup of a given table’s data database in a delimited format. The spool file generated can then be used for future data loads using a tool like SQL*Loader or any VB application. The script works on Oracle 7.x, 8.x and 9.x. (R)