Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts
Saturday, November 07, 2009
Monday, July 27, 2009
Tuesday, December 30, 2008
Creating Oracle Extended RAC on Oracle VM
Click here for details on Oracle Extended RAC on Oracle VM.
Wednesday, November 05, 2008
Apex Examples
Are you looking for Apex examples ?
Packaged Apps
Carl Backstrom's
Denes Kubicek's
Dimitri Gielis's
Mark Lancaster's
Vikas's
Packaged Apps
Carl Backstrom's
Denes Kubicek's
Dimitri Gielis's
Mark Lancaster's
Vikas's
Thursday, April 03, 2008
Connection to Oracle without using tnsnames
You can use the following syntax to connect
sqlplus user/password@//host:[port]/service_name
sqlplus user/password@//host:[port]/service_name as sysdba
This syntax (known as EZCONNECT) is only available with sqlplus >= v10.2
sqlplus user/password@//host:[port]/service_name
sqlplus user/password@//host:[port]/service_name as sysdba
This syntax (known as EZCONNECT) is only available with sqlplus >= v10.2
Monday, December 17, 2007
Great series about "Mining Information from the Listener Log" by Arup Nanda
In this article, you will learn how to build an infrastructure to process the listener log and to use it to unearth information on your database operations. The information can be used in different scenarios, as you will see later.
Monday, December 10, 2007
On-line tutorials Oracle 10g, Java, XML and Web Services
Advanced technical tutorials to help you learn Oracle 10g, Java, XML and Web Services.
These online Tutorials are self-paced, self-study lessons that contain numerous working examples and hands-on workshops.
These online Tutorials are self-paced, self-study lessons that contain numerous working examples and hands-on workshops.
Monday, November 19, 2007
Sunday, November 18, 2007
O-RSS Reader
O-RSS Reader - An Oracle PL/SQL API to enable persistent storage of RSS feeds within an Oracle DB.
1.1.0.1.0 version is now available on sourceforge. In that new version you will find a sample APEX application.
O-RSS can be used on Oracle Database 10g Express Edition
1.1.0.1.0 version is now available on sourceforge. In that new version you will find a sample APEX application.
O-RSS can be used on Oracle Database 10g Express Edition
Sunday, November 04, 2007
Better SQL*Plus
rlwrap - is a 'readline wrapper' that uses the GNU readline library to allow the editing of keyboard input for any other command. Now your's commands history is remembered :)
Saturday, October 13, 2007
How to install 10g on various Linux Distributions
# 10g Release 2 on Centos 5 (and hence on RHEL5 generally)
# 10g Release 2 64-bit on 64-bit Linux (the one exception to the above rule!)
# 10g Release 2 on Fedora 7 64-bit
# 10g Release 2 on Oracle Enterprise Linux
# 10g Release 2 on Solaris 10 (x86)
# 10g Release 2 on Centos 4.x (and hence RHEL4 generally)
# 10g Release 2 on Suse 10 (works unchanged for Suse 10.1 and 10.2, too)
# 10g Release 2 on Ubuntu (describes Ubuntu 5.10 and 6.06)
# 10g Release 2 on Fedora Core 5
# 10g Release 2 64-bit on 64-bit Linux (the one exception to the above rule!)
# 10g Release 2 on Fedora 7 64-bit
# 10g Release 2 on Oracle Enterprise Linux
# 10g Release 2 on Solaris 10 (x86)
# 10g Release 2 on Centos 4.x (and hence RHEL4 generally)
# 10g Release 2 on Suse 10 (works unchanged for Suse 10.1 and 10.2, too)
# 10g Release 2 on Ubuntu (describes Ubuntu 5.10 and 6.06)
# 10g Release 2 on Fedora Core 5
Tuesday, October 09, 2007
Installing Oracle 11g RAC on virtual servers using VMware
This post describes the installation of Oracle 11g RAC on virtual servers.
Thursday, September 20, 2007
Wednesday, September 19, 2007
Pivot in 11g
Pivoting is a key technique in data warehouses. In it, you transform multiple rows of input into fewer and generally wider rows in the data warehouse. When pivoting, an aggregation operator is applied for each item in the pivot column value list. The pivot column cannot contain an arbitrary expression. If you need to pivot on an expression, then you should alias the expression in a view before the PIVOT operation. The basic syntax is as follows:
SELECT ....
FROM
PIVOT
(
aggregate-function()
FOR IN (, ,..., )
) AS
WHERE .....
Example: Pivoting
The following statement illustrates a typical pivot on the channel column:
SELECT * FROM
(SELECT product, channel, amount_sold
FROM sales_view
) S PIVOT (SUM(amount_sold)
FOR CHANNEL IN (3 AS DIRECT_SALES, 4 AS INTERNET_SALES,
5 AS CATALOG_SALES, 9 AS TELESALES))
ORDER BY product;
PRODUCT DIRECT_SALES INTERNET_SALES CATALOG_SALES TELESALES
---------------------- ------------ -------------- ------------- ---------
...
Internal 6X CD-ROM 229512.97 26249.55
Internal 8X CD-ROM 286291.49 42809.44
Keyboard Wrist Rest 200959.84 38695.36 1522.73
Documentation here
SELECT ....
FROM
PIVOT
(
aggregate-function(
FOR
) AS
WHERE .....
Example: Pivoting
The following statement illustrates a typical pivot on the channel column:
SELECT * FROM
(SELECT product, channel, amount_sold
FROM sales_view
) S PIVOT (SUM(amount_sold)
FOR CHANNEL IN (3 AS DIRECT_SALES, 4 AS INTERNET_SALES,
5 AS CATALOG_SALES, 9 AS TELESALES))
ORDER BY product;
PRODUCT DIRECT_SALES INTERNET_SALES CATALOG_SALES TELESALES
---------------------- ------------ -------------- ------------- ---------
...
Internal 6X CD-ROM 229512.97 26249.55
Internal 8X CD-ROM 286291.49 42809.44
Keyboard Wrist Rest 200959.84 38695.36 1522.73
Documentation here
Tuesday, July 17, 2007
Building pages with APEX using spatial data
All about using Oracle Spatial with Google Maps.
- The Official Guide to using Oracle Spatial with Google Maps
- HTML DB and MapViewer: A Perfect Match
- Integrating APEX with Oracle AS 10g
- Oracle APEX/Spatial How to's
- Integration of Google Maps, Oracle Maps, ... into APEX
- Oracle Application Server MapViewer Sample Code and Demonstrations
-(Great tutorial) Google Maps in APEX on XE with spatial data
- The Official Guide to using Oracle Spatial with Google Maps
- HTML DB and MapViewer: A Perfect Match
- Integrating APEX with Oracle AS 10g
- Oracle APEX/Spatial How to's
- Integration of Google Maps, Oracle Maps, ... into APEX
- Oracle Application Server MapViewer Sample Code and Demonstrations
-(Great tutorial) Google Maps in APEX on XE with spatial data
Wednesday, July 11, 2007
Step by Step build RAC
Part 1 : Install VMWare and Linux
Part 2 : Install virtual disk and network card
Part 3 : Install Oracle Clusterware and Cluster Database
Oracle 10g RAC On Linux Using NFS
Oracle 10g RAC On Windows 2003 Using VMware Server
Oracle 10g RAC Series
Part 2 : Install virtual disk and network card
Part 3 : Install Oracle Clusterware and Cluster Database
Oracle 10g RAC On Linux Using NFS
Oracle 10g RAC On Windows 2003 Using VMware Server
Oracle 10g RAC Series
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.
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
Subscribe to:
Posts (Atom)