Saturday, January 20, 2007

Mini data generator

Will Hitchcock proposed a PL/SQL approach for generating the 1000 rows:

declare
i number := 1;
begin
for i in 0..999 loop
insert into pivot values (i);
end loop;
end;
/

Friday, January 19, 2007

Oracle Menu (om) is only a shell script.

Oracle Menu is only a shell script.

What does it do?
It just helps with often performed tasks and navigating around the file system and can give you useful information quickly.
It can help you perform some of the more monotonous tasks a DBA has to perform without having to know too much.
It can help you if you work between many sites often as it can hide some of the underlying differences, such as filesystem layout etc.

Drupal + Oracle: Inside the OraDrup Project

In this case study, it is described the OraDrup Project, which has the goal of combining the popular open-source Drupal CMS with Oracle Database.

Link 1
Link 2



Saturday, January 06, 2007

Oracle RAC 10g on Oracle Enterprise Linux Using VMware Server

In this guide, you will learn how to install and configure two nodes on running Oracle RAC 10g Release 2 on Enterprise Linux and VMware Server. Note that this guide is intended for educational/evaluation purposes only; neither Oracle nor any other vendor will support this configuration.