|
 SQL Tutorial - Learn SQL |
|
|
|
|
SQL HAVING
The SQL HAVING clause is used to restrict conditionally the output of a SQL statement, by a SQL aggregate function used in your SELECT list of columns.
You can't specify criteria in a SQL WHERE clause against a column in the SELECT list for which SQL aggregate function is used. For example the following SQL statement will generate an error:
SELECT Employee, SUM (Hours)
FROM EmployeeHours
WHERE SUM (Hours) > 24
GROUP BY Employee
|
The SQL HAVING clause is used to do exactly this, to specify a condition for an aggregate function which is used in your query:
SELECT Employee, SUM (Hours)
FROM EmployeeHours
GROUP BY Employee
HAVING SUM (Hours) > 24
|
The above SQL statement will select all employees and the sum of their respective hours, as long as this sum is greater than 24. The result of the SQL HAVING clause can be seen below:
| Employee |
Hours |
| John Smith |
25 |
| Tina Crown |
27 |
|
|
|
|
|
|
| |
© OracleSource.net. 2000-2006 |
|
1Z0 122 1Z0 007
install 9i starting 10g
Oracle Database Operator oracle information
oracle 9i sql uninstalling 10g
oracle 10g performance starting 10g
oracle 10g developer oracle 9i export
10g developer suite 10g application server
9i personal oracle news
oracle database 10g start oracle 9i
10g slow oracle sql training
oracle 10g solaris 10 oracle jobs
financials jobs oracle 9i java
oracle applications training oracle consultant
oracle 9i xp oracle 9i database
oracle 10g new features 10g client
OracleAS 10g Web Administrator oracle 9i on linux
oracle 9i odbc oracle utilities
9i driver 9i client linux
Hands on IT Training oracle training
10g on linux starting oracle 10g
sybase to migration what is oracle 10g
oracle forms 9i oracle 10g grid
consultants 9i features
linux oracle 10g sqlplus
10g 9i oracle financials jobs
and sql server oracle 10g system requirements
oracle 10g client download 9i client installation
10g database 9i pl sql
oracle 10g administration oracle pl sql
oracle jobs oracle 9i date
financials jobs what is oracle 9i
oracle database administrator oracle workflow
database tuning 10g system requirements
sybase to oracle migration oracle 9i dynamic performance views select from exam certification
database tuning Oracle Certified Professional
9i on fedora 1Z0 025
9i functions introduction to oracle 9i
9i export 9i xml
10g release 1 9i personal
oracle 10g redhat 9i java
oracle 9i client linux download oracle 9i
oracle jobs Oracle10g New Features
9i xml 10g jdbc
oracle financials jobs oracle 9i reference
1Z0 041 9i oem
install 10g 10g solaris
oracle 10g replication oracle certification training
9i insert oracle 10g release
10g application server oracle 9i books
Oracle grid control installing 10g on windows
installing 10g application server 10g release 2
9i date 9i sql reference
oracle 10g system requirements application server 9i
1Z0 043 oracle 10g exam
10g forms oracle 10g personal edition
oracle 10g system requirements oracle 10g aix
uninstalling oracle 10g download 9i
oracle 10g install sybase to oracle migration
oracle workflow how to install 9i
sample questions installing oracle 10g on windows
oracle oci oracle consultant
9i white paper 10g sqlplus
oracle 9i books oracle 9i performance tuning
10g start 1Z0 035
oracle consultants oracle 9i tutorial
10g sqlplus 10g personal
oracle 10g books oracle 10g sqlplus
download 9i oracle 9i installation guide
10g standard 10g redhat
oracle 9i merge OCM
sybase to oracle migration oracle 10g installation
10g sql 9i exam
uninstalling oracle 10g jdbc oracle
Oracle11i UNIX Oracle Administration
oracle consultant oracle 10g xml
oracle cbt 10g aix
developer jobs 10g slow
oracle 8i to oracle 9i 9i database
oracle certification oracle 9i downloads
10g database oracle 10g jdbc driver
what is oracle 10g 9i insert
10g administration 10g em
oracle 10g startup 10g download
oracle 10g upgrade database administrator
discoverer 10g oracle pl sql
oracle financials jobs oracle 10g em
9i complete reference oracle 9i as
oracle 9i sql reference oracle 9i features
installing 9i oracle 10g patch
and sql server jdbc
pl sql as 10g
Computer Based Training 9i documentation
1Z0 043 install 9i client
8i to 9i what is 9i
10g system requirements 10g client download
9i architecture oracle 10g on suse
faq 9i rman
guide to 9i oracle application server 9i
10g upgrade orafaq
10g grid databases
9i downloads oracle 9i sql reference
sybase to migration oracle 10g personal
oracle 9i 10g installing oracle 10g on linux
9i patch oracle 10g performance
9i olap join in 9i
Oracle 11i E Business Suite installing oracle 10g
1Z0 035 9i lite
9i xp 9i dynamic performance views select from exam
Oracle Certified Professional 10g backup
oracle 10g uninstall 10g app server
9i dynamic performance views oracle adapter
and sql server Oracle Database Operator
application server 10g release 2 start 9i
oracle 9i driver oracle database 10g insider solutions
1Z0 122 oracle 9i features
10g exam guide to oracle 9i
start 10g 10g jdbc driver
Oracle Certified Associate oracle 9i downloads
1Z0 026 10g new features
financials jobs 10g oem
oracle 9i standby database oracle forms training
uninstalling 10g install 9i
oracle 10g ocp 9i database
oracle developer suite 10g oracle 9i merge
oracle 10g application server 9i performance tuning
start 9i 9i pl sql
oracle 9i reports oracle 9i documentation
oracle database 10g insider solutions 10g books
1Z0 140 oracle 10g export
oracle 9i installation erp
start 9i peoplesoft oracle
1Z0 141 join in 9i
Oracle10g oracle application server 10g release 2
9i downloads 9i
application server 10g release 2 cbt oracle
oracle apps jobs oracle jobs
oracle consultant 9i sql
oracle 9i xp Oracle Certified Associate
9i database administrator oracle information
oracle 9i lite oracle 9i olap
10g app server Oracle 10g ADF J2EE Developer
oracle 9i xml oracle 9i odbc driver
oracle jobs in Oracle9i J2EE
9i complete reference 10g data types
9i installation guide jobs oracle
sybase to migration 9i tutorial
10g new features oracle 10g replication
10g backup oracle 9i listener
oracle 9i download oracle financials jobs
9i xml 9i lite
oracle jobs 1Z0 123
indexes in oracle 9i oracle 10g create user
10g suse oracle 9i dynamic performance views
starting 10g erp oracle
oracle 10g backup installing 10g on linux
8i to 9i oracle 10g certification
oracle 9i insert sybase to migration
oracle 10g new features 1Z0 030
oracle 9i programming oracle 9i xml
oracle conversion 10g replication
oracle database 10g release 2 oracle linux
oracle 10g installation oracle 10g uninstall
oracle 9i install reports 10g
Oracle 11i Applications DBA oracle interface
Oracle 11i Applications Developer download 10g
10g release 1 oracle application server 9i
oracle 9i application server oracle database 10g insider solutions
oracle 9i database administrator oracle software
oracle pl sql 9i new features
oracle 9i new features installing oracle 9i
oracle 10g hardware requirements 10g new features
9i database administrator 10g upgrade
oracle 10g replication 9i 10g
oracle 10g 9i 10g windows
oracle 10g install oracle 9i patch
oracle news oracle 10g backup
oracle 10g developer suite oracle 9i listener
select from exam certification join in 9i
oracle 8i to oracle 9i install oracle 9i
oracle 10g sqlplus oracle 10g oem
10g install install 9i client
8i to 9i oracle consultant
oracle adapter oracle forms 9i
oracle 9i features oracle adapter
10g em oracle 8i to oracle 9i
oracle 10g jdbc driver 10g hardware requirements
oracle 10g release starting oracle 10g
10g oem install oracle 9i on linux
Oracle 11i E Business Suite oracle 9i sql reference
oracle 9i patches 8i to 9i
install 9i on linux 9i on fedora
start 9i 9i client download
9i tuning 10g
10g on linux oracle 10g performance
10g fedora 10g personal
10g export 10g migration
oracle 9i windows xp oracle 9i xml
9i data guard oracle 10g system requirements
Oracle DBA Advanced Topics 9i date
oracle 9i date introduction to 9i
oracle 9i standby database client 9i
oracle 9i release oracle contract jobs
oracle 10g create user application server 9i
news oracle interface
oracle application server 10g release 2 oracle conversion
9i database administrator 9i performance tuning
oracle 9i white paper oracle database 10g insider solutions
9i exam guide to oracle 9i
oracle 9i application server database tuning
oracle 9i white paper 10g personal edition
oracle 10g download Oracle DBA Advanced Topics
developer jobs oracle 10g sqlplus
9i complete reference oracle 10g suse
1Z0 007 oracle development
and sql server oracle 9i features
10g certification 10g aix
Oracle9i JDeveloper oracle 9i downloads
9i books oracle contract jobs
10g create database 9i performance tuning
oracle 9i pl sql oracle interface
oracle 9i on fedora 10g redhat
oracle 9i exam oracle online training
oracle financials jobs uninstall 10g
10g xml 10g install
oracle 10g personal edition 10g database
oracle 9i rman sybase to migration
install 9i oracle forms training
oracle certification training 9i odbc
9i odbc driver 8i to 9i
Oracle 11i Applications DBA introduction to oracle 9i
start 10g oracle 9i xp
10g lite oracle contract jobs
client 10g 9i books
faq Oracle10g
oracle 9i sql oracle 9i personal
oracle 10g start 1Z0 301
oracle news oracle 10g performance
oracle certification training database 10g
1Z0 040 oracle 10g on suse
10g grid oracle 10g replication
oracle jobs oracle certification training
developer jobs installing 10g on windows
9i driver indexes in oracle 9i
database 10g release 2 9i client download
10g import oracle 10g start
oracle 9i jdbc driver introduction to oracle 9i
10g oem oracle 9i date
oracle 10g oca erp oracle
linux ado net oracle
9i as oracle 9i installation guide
uninstall 9i oracle 9i sql
introduction to oracle 9i 9i dynamic performance views
Oracle9i JDeveloper oracle 9i client download
oracle 9i programming 10g system requirements
oracle 10g solaris 10 9i features
1Z0 042 oracle certification
9i insert 10g mac
8i to 9i Oracle Certified Associate
oci oracle 10g migration
1Z0 040 1Z0 025
oracle 9i download oracle 9i patches
9i functions orafaq
oracle 10g export oracle information
1Z0 121 oracle 10g app server
10g release 2 starting oracle 10g
installing oracle 9i as 10g
oracle performance 1Z0 501
database 10g insider solutions oracle software
oracle 9i olap oracle 10g certification
oracle adapter 10g release
10g fedora oracle 10g client
1Z0 301 9i forms
oracle database 10g oracle client 9i
oracle 9i database oracle developer jobs
erp oracle 10g release 2
9i architecture oracle 10g forms
9i on fedora 10g system requirements
9i functions 9i client linux
oracle apps jobs oracle administration
oracle 10g features ado net oracle
oracle developer jobs in 9i sql
oracle 10g asm oracle 10g installation
oracle 9i olap 1Z0 032
9i patch oracle 9i case
oracle 10g certification utilities
start oracle 9i 1Z0 131
pl sql 9i installation
oracle 9i rman 9i documentation
oracle database 10g insider solutions oracle 9i sqlplus
oracle 9i architecture oracle 10g on suse
oracle financials jobs oracle 9i replication
install oracle 9i client 1Z0 041
9i backup 10g exam
10g developer 10g driver
9i java oracle apps jobs
oracle conversion 9i client download
9i dynamic performance views select from exam oracle developer 10g
oracle 10g on solaris oracle 9i jdbc driver
application oracle 9i pl sql
oracle 9i backup 1Z0 042
10g system requirements 1Z0 041
oracle 9i xml 10g patch
Oracle 10g Grid Training 10g oem
oracle 10g em client 9i
Oracle Real Application Clusters RAC Training oracle 9i complete reference
oracle 8i to oracle 9i oracle consulting
10g backup Advanced Oracle SQL Tuning
oracle 10g patch 9i downloads
oracle 10g training oracle 10g standard
oracle 10g mac oracle 9i 10g
oracle 9i sql 10g jdbc
database 10g 9i features
Oracle 11i Applications Developer oracle information
download 10g oracle 10g forms
databases installing 10g
10g uninstall 1Z0 141
join in oracle 9i oracle 9i database
1Z0 040 Oracle grid control
Oracle Certified Master 1Z0 024
oracle jobs developer jobs
Oracle10g New Features oracle database 10g insider solutions
oracle 9i white paper 9i patch
oracle workflow uninstall oracle 9i
oracle 10g start oracle 10g documentation
oracle 9i client download oracle 10g download
oracle replication peoplesoft
oracle financials jobs 9i merge
OracleAS 10g Web Administrator 9i backup
installing oracle 9i oracle 10g windows
odbc driver join in 9i
9i install oracle 10g personal edition
oracle performance installing oracle 9i
oracle 10g oca oracle 9i insert
9i forms oracle 10g data types
oracle 9i odbc sample questions
10g create user oracle 9i data types
oracle 9i installation start 10g
sample questions 9i features
application server 9i oracle 9i installation
indexes in oracle 9i 10g database
Oracle 11i E Business Suite installing 10g on windows
install oracle 9i oracle financials jobs
oracle jobs oracle database tool
10g system requirements oracle 10g asm
oracle 10g start 10g release 2
erp oracle 9i client installation
online training oracle 10g 9i
financials jobs Internet Application Developer
9i application server oracle 9i linux
oracle 10g sql oracle 9i new features
9i reports oracle database tuning
1Z0 024 9i book
oracle jobs oracle software
news database tuning
ado net oracle forms 9i
oracle 10g on solaris what is 10g
Oracle 10g Grid Training 9i xml
jobs oracle oracle 10g exam
10g training oracle workflow
oracle database tuning oracle 10g database
Oracle8i installing 10g on linux
Oracle10g New Features oracle 9i lite
9i server oracle jobs
oracle 9i personal 9i forms
oracle 10g on solaris oracle 9i dynamic performance views
oracle 9i application server 9i rman
developer jobs 1Z0 041
replication oracle 9i forms
10g create user oracle 10g solaris 10
uninstalling oracle 10g jdbc
oracle news oracle 9i sql
10g em 9i tutorial
1Z0 132 odbc driver
cbt oracle 8i to 9i
oracle 10g release 1 10g ocp
oracle 10g exam oracle 9i server
1Z0 141 10g ocp
install oracle 10g oracle database 10g release 2
9i sqlplus 1Z0 132
client 10g oracle 9i olap
10g sqlplus Oracle OCP Certification Exam
oracle developer suite 10g oracle 9i sql
oracle client 10g oracle software
9i data guard oracle jobs
9i tuning 9i windows xp
oracle database tuning oracle 10g solaris
9i tuning uninstall oracle 10g
1Z0 027 oracle 10g fedora
oracle 9i standby database OCp
difference between 9i and 10g installing oracle 10g
9i sql how to install oracle 9i
oracle certification oracle workflow
Oracle10g New Features oracle 9i tutorial
and sql server Oracle 11i System Administrator
10g training what is 9i
pl sql consulting
10g on solaris oracle database 10g insider solutions
9i client download installing oracle 10g on linux
9i upgrade 9i programming
oracle certification 9i documentation
client 9i 9i 10g
oracle application oracle 10g jdbc driver
9i client install oracle reports 10g
1Z0 025 oracle 9i windows xp
oracle adapter oracle 9i forms
Oracle DBA Advanced Topics oracle jobs
oracle 10g on suse 9i import
9i xp 10g client
oracle 9i client installation 9i sqlplus
1Z0 030 oracle 9i client install
oracle 10g startup 9i documentation
database administrator oracle financials jobs
Oracle9i JDeveloper oracle developer 10g
oracle 10g 9i erp oracle
10g patch oracle 10g lite
10g export 9i documentation
10g certification oracle 10g release 1
oracle discoverer 10g oracle 9i reports
oracle 10g release 2 oracle applications training
oracle 9i case consulting
oracle application oracle 9i as
oracle 10g certification oracle 10g export
oracle consultant 9i install
oracle 9i merge guide to oracle 9i
9i 10g client
oracle 9i features 10g performance
oracle software 9i database administrator
9i rman oracle 9i books
9i odbc driver download 10g
developer jobs Oracle10g New Features
10g standard oracle 9i data types
1Z0 121 1Z0 030
10g slow OCA
oracle 9i export oracle oci
oracle databases Hands on IT Training
certification 9i database
9i import oracle 10g app server
oracle implementation 1Z0 045
oracle consultants what is oracle 9i
10g jdbc 9i reference
start oracle 9i oracle consulting jobs
9i book 9i patch
install 9i 10g new features
oracle jobs in 1Z0 122
oracle 10g oem oracle 9i dynamic performance views select from exam
10g oca financials jobs
oracle forms 9i oracle training
oracle interface guide to oracle 9i
start oracle 10g 10g 9i
9i books oracle 9i database
oracle 10g sqlplus oracle 9i database administrator
9i on fedora 9i book
Oracle Database Operator 9i reports
oracle 9i programming oracle 9i as
Oracle9i J2EE 1Z0 035
oracle certification training oracle implementation
uninstall 9i oracle 9i on linux
9i odbc installing 10g
10g OCp
oracle database 10g insider solutions 10g fedora
oracle 10g on solaris oracle 9i date
9i tutorial oracle 10g data types
oracle 9i merge starting 10g
Computer Based Training 10g developer suite
oracle adapter oracle 9i architecture
10g release 1 orafaq
erp oracle oracle 10g import
9i xp 9i client installation
install oracle 9i 10g grid
9i backup oracle 9i sqlplus
install 9i oracle 9i replication
10g certification how to install oracle 9i
10g installation oracle 9i exam
as 10g oracle 10g application server
oracle replication oracle 10g create user
difference between oracle 9i and 10g 9i replication
guide to 9i oracle 10g database
installing oracle 10g on linux oracle consultant
oracle news 10g slow
oracle 10g migration difference between oracle 9i and 10g
OCA oracle 9i sql
oracle 10g administration orafaq
application server 10g release 2 uninstalling oracle 10g
oracle database tuning oracle consultant
Oracle Database Operator 10g upgrade
9i pl sql oracle 10g oem
9i dynamic performance views and sql server
10g forms 9i lite
oracle 10g system requirements oracle utilities
10g performance oracle 10g windows
oracle 10g app server 9i download
odbc driver 10g forms
jobs in oracle installing oracle 10g on windows
oracle 10g application server oracle 9i windows xp
oracle 10g on solaris oracle 9i as
oracle forms 9i oracle administration
9i server oracle jobs in
oracle database tuning installing oracle 10g on linux
10g export 9i install
oracle 10g redhat oracle 9i export
9i database administrator Oracle RMAN Backup & Recovery Training
9i download oracle consultant
10g forms developer jobs
10g jdbc driver Oracle Auditing
oracle 9i application server utilities
oracle 10g asm oracle 10g certification
reports 10g 9i server
jobs oracle 9i xml
oracle 10g jdbc driver start oracle 9i
financials jobs 9i server
10g import oracle as 10g
oracle forms training oracle 9i downloads
oracle jobs 9i documentation
oracle software Oracle 11i System Administrator
9i reference certification
9i xp 9i sql
Oracle11i oracle 9i merge
1Z0 147 9i download
10g import client 9i
jobs oracle jdbc
Upgrading to Oracle10g 10g system requirements
9i sql oracle certification
oracle database 10g release 2 10g sqlplus
oracle 10g create database developer jobs
9i installation 1Z0 031
uninstall 9i sample questions
oracle 10g release oracle consultant
oracle 10g oem oracle 9i application server
10g forms oracle 10g as
oracle 10g lite oracle 10g app server
oracle 10g oca oracle 10g system requirements
erp oracle 9i lite
9i data guard 1Z0 041
10g database installing 10g on windows
oracle accounting oracle 10g performance
1Z0 001 oracle 10g client download
developer jobs 9i forms
oracle workflow 10g create database
indexes in 9i download 10g
10g on solaris 10g driver
oracle 10g developer oracle 9i tuning
indexes in oracle 9i 9i architecture
oracle 9i application server oracle apps jobs
oracle implementation 9i listener
oracle pl sql 10g
oracle 9i dataguard oracle 10g download
9i oracle online training
database 10g release 2 sample questions
oracle 9i dynamic performance views application
oracle forms training oracle 9i dynamic performance views select from exam
1Z0 045 oracle 9i dynamic performance views select from exam
Oracle RMAN Backup & Recovery Training 9i white paper
oracle 10g import how to install 9i
10g fedora 10g on suse
jdbc client 9i
oracle 9i personal start 10g
10g personal 9i book
oracle 9i dynamic performance views select from exam certification 10g slow
9i forms sybase to migration
oracle 9i features 9i downloads
10g certification 9i features
9i features Oracle Certified Associate
oracle 10g release 2 9i data types
9i release oracle 10g standard
10g xml 9i client installation
oracle 10g client download 9i case
10g install oracle 10g slow
oracle cbt oracle adapter
10g on suse oracle 10g redhat
oracle 9i data guard 10g start
download 10g Oracle10g New Features
oracle 10g training oracle online training
1Z0 007 online training
installing 10g on linux oracle 9i driver
download 10g oracle 9i downloads
oracle 8i to oracle 9i jdbc
uninstall oracle 9i oracle online training
cbt oracle oracle 10g administration
download oracle 9i OCp
news and sql server
oracle 10g sql oracle developer jobs
9i installation guide oracle 9i on fedora
8i to 9i jdbc
10g release 2 oracle 9i documentation
10g release 1 10g 9i
oracle workflow oracle 9i dynamic performance views
10g documentation oracle 9i reports
introduction to oracle 9i Oracle Certified Master
OCA oracle conversion
9i database 9i new features
Computer Based Training oracle replication
9i oracle client 10g
10g forms oracle news
oracle 10g jdbc driver oracle 10g lite
oracle 9i xml oracle 9i 10g
10g client developer jobs
oci start 10g
oracle 9i book Oracle Database Operator
forms 9i database tool
reports 10g consultants
jobs in oracle oracle 9i on fedora
9i dataguard 9i java
9i listener oracle 10g standard
Oracle Developer 6i Forms oracle 10g export
indexes in oracle 9i oracle 10g as
9i install oracle 9i on linux
10g import oracle 10g create database
download oracle 10g application server 10g release 2
oracle 10g installation oracle 10g solaris
oracle cbt oracle 10g patch
oracle 10g solaris 10g developer
10g 10g solaris 10
9i oem 1Z0 042
orafaq oracle 10g mac
10g release 1 1Z0 147
10g grid oracle conversion
9i patches OracleAS 10g Web Administrator
installing oracle 10g on windows 9i sqlplus
oracle 9i programming 1Z0 025
oracle 10g backup 1Z0 040
1Z0 040 oracle 10g slow
10g driver difference between 9i and 10g
financials jobs installing 10g on windows
difference between 9i and 10g oracle 9i system requirements
Oracle 11i Applications Developer oracle 9i release
1Z0 140 oracle 10g grid
oracle 9i downloads 9i xp
oracle administration oracle consulting jobs
oracle 9i odbc oracle 10g certification
database 10g release 2 1Z0 040
oracle client 9i oracle 9i replication
9i reports 10g windows
9i reports oracle 9i standby database
9i 10g 1Z0 026
9i lite 9i database
utilities 10g mac
Oracle 11i Applications DBA 1Z0 020
oracle 10g system requirements download 10g
9i sql 10g windows
9i dataguard oracle 9i server
9i features 9i listener
uninstall oracle 9i oracle 10g standard
oracle conversion 9i books
Oracle Administration & Management how to install 9i
oracle 9i server install oracle 9i on linux
9i exam 9i standby database
oracle news oracle faq
10g patch oracle 9i java
sybase to migration oracle 10g personal edition
oracle 10g database oracle 9i listener
oracle administration oracle 9i client download
10g create user 9i release
9i sql oracle 9i book
10g on linux pl sql
indexes in 9i oracle administration
10g slow jobs oracle
Oracle Certified Professional oracle 9i performance tuning
jobs oracle oracle 9i personal
install oracle 10g 10g application server
sybase to oracle migration 10g solaris
10g developer certification training
oracle 9i rman oracle 9i system requirements
9i programming 1Z0 501
oracle 9i tuning oracle 9i backup
oracle 9i upgrade 10g documentation
Oracle 11i Applications Developer 1Z0 020
oracle 10g asm 9i standby database
oracle 10g aix OracleAS 10g Web Administrator
Oracle PL/SQL Programming & Tuning databases
1Z0 140 oracle 9i reports
financials jobs 9i database
oracle developer jobs in 9i jdbc driver
oracle 10g create database oracle 10g client download
1Z0 030 oracle 9i odbc
guide to 9i 10g export
8i to 9i oracle developer jobs in
oracle 9i install oracle 9i architecture
oracle 10g system requirements 10g backup
oracle 9i sql reference oracle 9i installation
oracle development 9i database administrator
oracle 10g certification 9i dataguard
install 9i on linux oracle development
1Z0 141 sybase to oracle migration
9i pl sql 10g backup
oracle workflow oracle 9i server
9i system requirements 9i merge
oracle 9i oem 9i complete reference
join in oracle 9i oracle 10g ocp
oracle 10g xml installing oracle 10g on linux
9i programming oracle jobs
10g features oracle 9i client download
10g start 10g migration
10g backup 1Z0 132
oracle application server 10g release 2 oracle jobs
9i xp 9i rman
oracle client 10g 9i upgrade
oracle 9i data guard oracle interface
oracle 10g application server oracle 10g documentation
oracle 10g personal oracle consulting
oracle software oracle and sql server
oracle 9i reports oracle 9i as
oracle apps jobs Oracle Real Application Clusters RAC Training
ado net jobs at oracle
oracle 9i features ado net
oracle 9i system requirements select from exam certification
10g developer suite 9i odbc
oracle 9i client download start 10g
what is 9i oracle 9i sqlplus
oracle 9i upgrade 1Z0 031
10g sqlplus oracle 10g certification
10g performance 9i on fedora
and sql server oracle as 10g
oracle implementation 10g create user
uninstall 9i oracle sql training
oracle developer 10g oracle 9i pl sql
oracle adapter oracle adapter
installing 10g on windows oracle 9i documentation
oracle reports 10g oracle 10g asm
10g fedora 9i client installation
oracle developer suite 10g oracle 10g application server
9i programming Upgrading to Oracle10g
9i on linux 9i personal
10g system requirements oracle developer suite 10g
oracle 10g application server jdbc
oracle 9i downloads oracle 10g suse
oracle 10g application server oracle development
linux Oracle10g New Features
1Z0 141 oracle 9i driver
9i backup 1Z0 121
oracle linux oracle 10g fedora
oracle 10g lite 9i exam
oracle discoverer 10g oracle application server 9i
1Z0 122 1Z0 023
1Z0 042 9i listener
oracle consulting oracle 10g performance
oracle developer suite 10g 9i on linux
10g performance UNIX Oracle Administration
select from exam certification oracle 10g mac
guide to 9i online training
oracle 9i database administrator oracle 9i backup
Oracle Real Application Clusters RAC Training 9i client installation
oracle 10g developer 9i date
certification training oracle 10g windows
oracle 10g performance oracle 9i patch
uninstall 9i 9i architecture
1Z0 132 1Z0 041
what is oracle 9i 9i functions
oracle accounting Oracle Real Application Clusters RAC Training
9i standby database 1Z0 007
jobs oracle 10g aix
Education and certification programs for Oracle's database, tools, and applications products. IT training for Oracle DBA, Developer, and Java programming topics. Learn more about Oracle certification at Education Online Search. Search our Oracle exam guides. Oracle9i DBA Certification Boot Camps - $40 includes Oracle 10g. Stimulate your Oracle training with extremely realistic Transcender exams. The Training Camp offers Oracle DBA certification training camps for networking. Increase your earning power. TechSkills' flexible, self-paced Oracle training. Complete oracle DBA certification training package. 24/7 Oracle, DB2, SQL support. A flexible answer to database needs. OCP: Oracle Certification - Ensure your success in OCP (Oracle certification) exam. Get information and links for Oracle certification tracks, including exam preparation, books, practice tests, and links. ... Guide to Oracle Certification.
Oracle8i training from Oracle experts who have real-life experience using Oracle Database products. We can train you for Oracle's certification exams: Oracle10g, Oracle9i. Training BootCamp Exam Questions. training tools for Oracle exams are your ticket to certification success. Oracle study guides, exam questions, Oracle prep materials. Try our Oracle ... will prepare you for the questions asked when seeking your Oracle Certification. code, utilities and a user forum. Covers Oracle 8i, 9i and 10G. ... Oracle Certification. Forums. Blog. Blog Aggregator. Industry News. Book Store. Questions and answers about the available Oracle Certification Exams and Tests. ...
What official Oracle certification tracks are available? Oracle Certification Training BootCamp Exam Questions ... training tools for Oracle exams are your ticket to certification success. Oracle Braindumps for Certification Training at Blue Braindumps ... Prepare for your Oracle certification today! ... part of more than one Oracle certification. ORACLE DBA Certification Exam - Book Page. ... Oracle Exam & Certification Page. Oracle Certified Professional/DBA .Oracle Certification Training Boot Camp Classes and Courses on Videos and CDS. Learn Oracle with our training curriculum for 8i and 9i for Administration and Developer. Pass Oracle certification exam in first attempt. ... The Oracle Certified Professional (OCP) certification is given by one of the. Oracle Architecture. Startup and Shutdown Instance. Create a Database. Access and Update Data ... Oracle and Oracle Certification Training. Oracle8i training from Oracle experts who have real-life experience using Oracle Database products. We can train you for Oracle's certification exams: Oracle10g, Oracle9i. Assisting Oracle customers and professionals by providing technical discussion, an integrated Oracle directory, job postings, news, and much more. A student entering the Oracle Certification Program must start with this course. ... prepared to take the Oracle Certification exam for the completed track. Oracle Certification Training for Oracle exams buy Exact Questions. Gauranteed Certification with 100% Exact Questions. New Oracle certification being offered. Oracle Training Videos and CD-ROMS Certification... Cisco,Unix,MCSE,Linux, Certification ... The complete Oracle Certification for 8 Certified Database Administration.
Oracle 10g Automatic Storage Management, Part 1: Overview : Oracle 10g's new Automatic Storage Management (ASM) features allow an Oracle DBA to take advantage of a robust, flexible, scalable file storage system that any Oracle database instance can access. This article - the first in this series -- provides a high-level overview of the ASM architecture, and should be helpful to any DBA contemplating the adoption of ASM for storing Oracle database files as part of a high-volume storage solution.
Database Security and Patches – Part 2 : Part 2 of this series covers the mechanics of installing a patch.
RACing ahead with Oracle on VMware - Part 3: Installing Oracle 10g Release 2 Clusterware on a 2-node Windows 2003 Enterprise Edition Server : Part 3 of this series discusses the installation of Clusterware on a 2-node windows 2003 server with VMware.
Database Security and Patches – Part 1 : Part 1 of this series provides a review of database security and looks at a well-known security hole in Oracle 9.2.0.1.
"RACing ahead with Oracle on VMware Series" - Part II: Oracle RAC and RAW disk setup on Windows 2003 Enterprise Server : Part two of this series continues the discussion of Oracle RAC, how to install the VMware tools and set up RAW disks on Windows 2003 Enterprise Server.
"RACing ahead with Oracle on VMware Series" - Part 1: Setting up VMware for Oracle/Intro to Virtualization/Server Consolidation : Part l of this series offers a brief introduction to setting up VMware and the importance of other tools such as VNC, freeNX or NoMachine, PuTTY, etc.
Super-Sizing A Database: Oracle 10g Tablespace Enhancements : Oracle 10g's daunting array of new features like extended FLASHBACK technology, Automated Storage Management, and Grid Computing sometimes overshadow the more mundane -- yet no less impressive! - improvements to its logical storage capabilities. This article illustrates several enhancements to Oracle's already robust logical storage structures, including the SYSAUX tablespace, BIGFILE tablespaces, tablespace groups, and tablespace renaming.
Reviewing Views : Views are extremely useful for DBAs, developers, and users alike, but are you getting all you can out of what views have to offer?
Oracle Performance Tuning – Part 3 : Part 3 of this series focuses on generating bulk data using DataFactory from Quest Software.
Just SQL Part VII – Hierarchical Queries : Whether they are called hierarchical structures, trees, or self-referencing tables they often pose quite a challenge to traverse in any simple manner. But Oracle has a solution.
Oracle Performance Tuning – Part 2 : There are several relatively easy steps you can take to improve performance. From the user's perspective, one of the most frequently used interfaces with a database involves SQL statements, so getting a handle on them is a good place to start, in terms of being able to see an immediate improvement.
Playing With MODELs: Oracle 10g SQL Enhancements, Part 3 : Oracle 10g has extended the already robust features of Structured Query Language (SQL) with a plethora of intriguing new capabilities. This article – the final in this series – reviews the new features that Oracle 10g provides for advanced data modeling and inter-row calculations via the new MODEL clause.
Just SQL Part VI – Two Famous Pseudocolumns : A pseudocolumn is a column that looks like a column but really is not a column. What?! Stick around and find out what a pseudocolumn really is. James Koopmann explores two popular pseudocolumns, ROWID and ROWNUM, and their use.
Oracle Performance Tuning – Part 1 : Oracle's Tuning Methodology changed when Oracle 9i was released. The approach went from top-down in 8i to that of following principles in 9i/10g. Neither methodology is absolute as each has its advantages and disadvantages. Read on to learn more.
Just SQL Part V – Counting with SQL : How many do I have? Do I have at least one? What is the greatest? What is the least? Give me the top 5 rows. These are just some of the types of questions that are often asked when trying to evaluate table data. This article explores how to translate these counting questions into SQL statements.
Data Densification, Demystified: Oracle 10g SQL Enhancements, Part 2 : Oracle 10g extends many of the already robust features of Structured Query Language (SQL). This article the first of a series illustrates some of the more intriguing new features of SQL within Oracle, including upgrades to the MERGE command, enhancements to hierarchical query capabilities, and improvements to query and access methods for nested tables.
Database Modeling Using Visio : One of Visio's key features is its ability to reverse engineer a database. Part 2 of this series looks at doing exactly that, using the sample schemas Oracle provides.
Just SQL Part IV – Joining Tables : As your database grows so will the need to get information from more than one table. This article shows you the different join options and offers some simple examples to raise your familiarity.
Making the Case for CASE Tools : Many DBAs find themselves working with someone else's database design. Unless you are involved with building or designing a new application or database from scratch, when else would you have the opportunity to use a CASE tool? One of the points to take away from having read this article is that a CASE tool can also be used after the fact. CASE tools are an invaluable resource for a DBA and knowing how to use one (or more) of them can make your job easier.
Just SQL Part III – Where is it? : We do not always want to SELECT everything from a table. The matter of finding the information required is a function of implementing the optional WHERE clause of the SELECT statement.
Strong SQL Made Even Stronger: Oracle 10g SQL Enhancements, Part 1 : Oracle 10g extends many of the already robust features of Structured Query Language (SQL). This article the first of a series illustrates some of the more intriguing new features of SQL within Oracle, including upgrades to the MERGE command, enhancements to hierarchical query capabilities, and improvements to query and access methods for nested tables.
Oracle on the Web Part 5 – More on HTML DB : The final part of this series looks at some free resources for HTML DB, include training documentation, blogs and news feeds, a free workspace (hosted by Oracle), and a user forum.
Just SQL Part II – The Simple SELECT : At the core of most queries is an underlying table structure. Part II of this series discusses how we can issue the most basic of SELECT statements to extract information from a database table.
Where Did Oracle Come From? : Often times, we take for granted the functions an RDBMS performs. But where, exactly, did the concept of the relational model come from? Read on to learn the origins of the RDBMS model in general and where and how Oracle came into being.
Just SQL Part I : How many of you have asked yourself what is SQL all about? Join James Koopmann as he ventures down the road of understanding SQL and how to take advantage of the language.
Oracle 10g PL/SQL Enhancements, Part 2: Utility Players : Oracle 10g has added over fifty new PL/SQL packages and enhanced many of the existing packages, thus expanding the Oracle DBA's toolkit once again. New capabilities include the ability to transfer files between servers, more robust e-mail features, improved compilation utilities, and character conversion utilities. This article - the final one in this series - delves into several new features presented in new and improved versions of Oracle's utility modules and illustrates their usefulness in some real-world situations.
Oracle on the Web, Part 4 – Upgrading HTML DB : Hidden away in the depths of your Oracle installation is a valuable resource you can use to get a jump-start on learning how to combine Oracle's strength as a relational database management system and the power of the Internet. Part 4 of this series covers the steps of upgrading to version 1.6 and creating a simple Web service.
Education and certification programs for Oracle's database, tools, and applications products. IT training for Cisco, Microsoft, Sun Solaris, Oracle DBA, and Java programming topics. Learn more about Oracle certification at Education Online Search. Search our Oracle exam guides. Oracle9i DBA Certification Boot Camps - $40 includes Oracle 10g. Stimulate your Oracle training with extremely realistic Transcender exams. The Training Camp offers Oracle DBA certification training camps for networking. Increase your earning power. TechSkills' flexible, self-paced Oracle training. Complete oracle DBA certification training package. 24/7 Oracle, DB2, SQL support. A flexible answer to database needs. OCP: Oracle Certification - Ensure your success in OCP (Oracle certification) exam. Get information and links for Oracle certification tracks, including exam preparation, books, practice tests, and links. ... Guide to Oracle Certification.
Oracle8i training from Oracle experts who have real-life experience using Oracle Database products. We can train you for Oracle's certification exams: Oracle10g, Oracle9i. Training BootCamp Exam Questions. training tools for Oracle exams are your ticket to certification success. Oracle study guides, exam questions, Oracle prep materials. Try our Oracle ... will prepare you for the questions asked when seeking your Oracle Certification. code, utilities and a user forum. Covers Oracle 8i, 9i and 10G. ... Oracle Certification. Forums. Blog. Blog Aggregator. Industry News. Book Store. Questions and answers about the available Oracle Certification Exams and Tests. ...
What official Oracle certification tracks are available? Oracle Certification Training BootCamp Exam Questions ... training tools for Oracle exams are your ticket to certification success. Oracle Braindumps for Certification Training at Blue Braindumps ... Prepare for your Oracle certification today! ... part of more than one Oracle certification. ORACLE DBA Certification Exam - Book Page. ... Oracle Exam & Certification Page. Oracle Certified Professional/DBA .Oracle Certification Training Boot Camp Classes and Courses on Videos and CDS. Learn Oracle with our training curriculum for 8i and 9i for Administration and Developer. Pass Oracle certification exam in first attempt. ... The Oracle Certified Professional (OCP) certification is given by one of the. Oracle Architecture. Startup and Shutdown Instance. Create a Database. Access and Update Data ... Oracle and Oracle Certification Training. Oracle8i training from Oracle experts who have real-life experience using Oracle Database products. We can train you for Oracle's certification exams: Oracle10g, Oracle9i. Assisting Oracle customers and professionals by providing technical discussion, an integrated Oracle directory, job postings, news, and much more. A student entering the Oracle Certification Program must start with this course. ... prepared to take the Oracle Certification exam for the completed track. Oracle Certification Training for Oracle exams buy Exact Questions. Gauranteed Certification with 100% Exact Questions. New Oracle certification being offered. Oracle Training Videos and CD-ROMS Certification... Cisco,Unix,MCSE,Linux, Certification ... The complete Oracle Certification for 8 Certified Database Administration.
A View of Creating an Oracle User - Part II : After an Oracle user has been created and schema objects have been built, best practices dictate that you should not run your applications as the schema owner. Here is a shell procedure and methodology to assist you in maintaining this segregation of application user from database schema owner.
Oracle on the Web - Part 3 - Using Applications in HTML DB : Continuing our series on Oracle 10g's HTTP Server and HTML DB, part two looks at how the HTTP server has changed with respect to how you get it and how you use it. Part of the process is very easy, and other parts are somewhat confusing. If you were hoping for a clean, "one CD type of install and there it is" situation, the result is a mixed bag.
A View of Creating an Oracle User - Part I : Before any schema objects can be created, you must first create a user that will own these objects. This somewhat simple procedure is often overlooked and it can open wide holes in security and portability.
Oracle 10g PL/SQL Enhancements, Part 1: DBMS_CRYPTO, DBMS_MONITOR, and DBMS_SERVER_ALERT : With the addition of over fifty new PL/SQL packages as well as enhancements to a majority of existing DBMS packages, Oracle 10g has added a plethora of new tools to every Oracle DBA's tool belt. This article - the first is a series -- explores some of the more intriguing packages and illustrates their usefulness in real-world situations.
Oracle on the Web, Part 2 – Oracle 10g's HTTP Server and HTML DB : Continuing our series on Oracle 10g's HTTP Server and HTML DB, part two looks at how the HTTP server has changed with respect to how you get it and how you use it. Part of the process is very easy, and other parts are somewhat confusing. If you were hoping for a clean, "one CD type of install and there it is" situation, the result is a mixed bag.
The Globalization of Language in Oracle - Index Requirements : James Koopmann takes a look at indexing requirements when using NLS_SORT <> BINARY and an ORDER BY clause.
Using LogMiner - Part 2 - Striking Out : Steve Callan investigates a scenario in which LogMiner may or may not be able to recover data lost through user error.
Oracle and Regular Expressions : UNIX comes to Oracle in the form of regular expressions to increase the power of searching.
Oracle 10g DataPump, Part 2: Implementation : Oracle 10g's new DataPump is designed as the eventual replacement for the Oracle Import and Export utilities. This article - the second and final in this series - focuses on using the DataPump's features in real-world scenarios, including creation of custom DataPump jobs with DBMS_DATAPUMP.
The Globalization of Language in Oracle - And Case-Insensitivity : Learn how to take advantage of globalization techniques to perform case insensitivity in Oracle.
Oracle on the Web Part 1 - Exploring Oracle's HTTP Server : Hidden away in the depths of your Oracle installation is a valuable resource you can use to get a jump-start on learning how to combine Oracle's strength as a relational database management system and the power of the Internet. Join Steve Callan as he delves into the Oracle HTTP Server (OHS).
The Globalization of Language in Oracle - The NLS_LANG variable : James Koopmann zeros in on the most important variable for implementing a global database in Oracle and some lessons learned.
Automatic SQL Tuning using SQL Tuning Advisor : Oracle Database 10g introduces many useful and easy-to-use tuning tools and methodologies. In this article, we will examine one of these new and improved features - SQL Tuning Advisor.
Oracle 10g DataPump, Part 1: Overview : Oracle 10g's new DataPump utility is designed as the eventual replacement for the original Oracle Import and Export utilities. This article - the first in a series - provides an overview of the DataPump's suite of tools for extracting, transforming, and loading data within an Oracle database.
Doing Data Guard - Part 2 : Part two of this series picks up with step-by-step coverage of preparing your environment for Data Guard.
The Globalization of Language in Oracle - The NLS_COMP and NLS_SORT variables : How does Oracle compare and sort data. There is more to it than meets the eye.
Collecting Real Time Wait Events : There are two common ways of collecting wait event information: the Oracle extended trace (10046 event) and using V$ views. Learn how to collect wait event information using V$ views.
Oracle and Pro*C - Part 1 : Pro*C is another one of those tools or features from Oracle that keeps a low profile, quietly waiting its turn for you to use it when the need arises. Learn where to get Pro*C, and how to configure the environment.
The Globalization of Language in Oracle - National Language Support : The previous article of this series looked at external terminology around globalization. This article covers the internal parameters that we will need to become familiar with.
Oracle 10g Availability Enhancements, Part 4: LogMiner and Data Guard : Oracle 10g offers significant enhancements that help insure the high availability of any Oracle database, as well as improvements in the database disaster recovery arena. This article - part three of a series - concentrates on the expanded capabilities of the logical Flashback command set.
Connecting with Oracle - Ensuring Sufficient Privileges : Be honest now, how many times have you encountered the ORA-01031 error? Without a deeper understanding of the "how do I authenticate thee, let me count the ways?" relationship between the operating system and Oracle, you are doomed to encounter this error time and time again.
The Globalization of Language in Oracle - Terminology : With today's exploding world economy, multi-national communication is essential. Databases must not only store different character sets but also present information in a comfortable format and order for individuals from every locale. This series explores how to globalize your databases and communicate effectively across the globe.
Collecting Oracle Extended Trace (10046 event) : The most importing thing in collecting trace data is collecting properly scoped data. Learn the pitfalls of doing it wrong and the rewards of doing it right.
Doing Data Guard - Part 1 : Oracle Data Guard is a very useful tool to help maintain high availability and to protect your data. It is not uncommon to see 'must have experience with RAC and Data Guard' in job postings. The purpose of this series is to give you a little push to get up and running with Data Guard.
Oracle Session Tracing Part VI : Part six of this series discribes how to access and generate reports off of the trace files we generated in Part five, through the use of the TKPROF and trcsess utilities.
Oracle 10g Availability Enhancements, Part 3: FLASHBACK Enhancements : Oracle 10g offers significant enhancements that help insure the high availability of any Oracle database, as well as improvements in the database disaster recovery arena. This article - part three of a series - concentrates on the expanded capabilities of the logical Flashback command set.
Database Benchmarking : Steve Callan introduces you to what the benchmark tests are, who controls or regulates them, and shows how Oracle compares to other database systems.
Oracle Session Tracing Part V : Part five of this series will re-acquaint you with Oracle's tracing mechanism. Read on to learn about creating trace files for TKPROF.
Describing Oracle Syntax : Steve Callan offers a brief history on Oracle's syntax.
Oracle Session Tracing Part IV : Part 3 of this series examined how to enable tracing of statistics through the DBMS_MONITOR package. This installment focuses on determining which internal Oracle views hold the information to our enabled statistical gathering.
Oracle 10g Availability Enhancements, Part 2: Flashback Database : Oracle 10g offers significant enhancements that help insure the high availability of any Oracle database, as well as improvements in the database disaster recovery arena. This article - part two of a series - explores one of the most intriguing new features of Oracle 10g: Flashback Backup and Recovery.
Oracle Migration Workbench - Part 5 : Part five of this series looks at issues related to the SQL Server to Oracle migration process.
Oracle Session Tracing Part III : Explore how to enable and disable Oracle tracing with the DBMS_MONITOR package in 10g.
Oracle Migration Workbench - Part 4 : Part four of this series goes into more detail about SQL Server and how it compares to Oracle. This part of the series also covers the setup and preparation to use Oracle Migration Workbench to migrate the Northwind database from SQL Server to Oracle.
Making a Connection from Oracle to SQL Server : SQL Server is gaining popularity and there are many shops that I know of that have this database system within their walls. Learn how to make a connection from Oracle to SQL Server using Oracles heterogeneous Services ODBC agent.
Oracle Session Tracing Part II : Part two of this series shows how to set two more very important session environment variables to make tracing more effective. Read on and learn how to set the module and action names.
Oracle 10g Availability Enhancements, Part 1: Backup and Recovery Improvements : Oracle 10g offers significant enhancements that help insure the high availability of any Oracle database, especially in the arena of disaster recovery. This article - the first in a series - concentrates on several new features available for backup, restoration, and recovery of Oracle databases, especially when using Oracle Recovery Manager (RMAN).
Oracle Migration Workbench – Part Three : The end of Part Two of this series, finished with loading data from the MySQL database into the Oracle database/repository. Part Three will go into more detail about the Migration Workbench console and learn how to configure some options.
Oracle Session Tracing Part I : This is the first in a series introducing some of the new tracing concepts and options within Oracle. This installment focuses on the new CLIENT_IDENTIFIER environment variable that can be assigned to sessions.
Oracle Migration Workbench - Part Two : At the end of Part One, we were at the point where MySQL was ready to be installed. In part two of this series, we will go through some quick setup steps, create a user with some privileges, and load data - using several methods - into a MySQL database. Once the setup of the MySQL database is complete, we will be ready to start using Migration Workbench.
Clustering for Indexes : Indexes hold the key for speed when accessing data. To ensure that you are getting to the data as fast as possible you should check to make sure the clustering is suitable for the query type.
The Oracle 10g Scheduler, Part 3: Advanced Features : Oracle 10g's new DBMS_SCHEDULER package offers significant advanced features over its predecessor, DBMS_JOB, that any reasonably skilled Oracle DBA can use to insure that sufficient resources will always be available for processing complex business requirements. This article - the final in a three-part series - provides some practical examples of how the new Scheduler can help a DBA to manage and overcome these challenges.
Oracle Migration Workbench - Part 1 : By the end of this series, not only will you be familiar with two other widely used and popular database systems, but you will also know how to migrate data from these systems into an Oracle database.
Sending e-mail from within Oracle : Sending e-mail from within Oracle can be of great benefit. This article gives you a quick start at sending simple e-mails.
Oracle Response Files – Part 2 : Part One of Oracle Response Files covered the basics of using a response file and provided an example of how to install Developer Suite on a Windows PC. In Part Two, we will go into more detail about the components of response files. This part will also discuss some related topics as they pertain to the Oracle Universal Installer and some Windows-analogous installation concepts.
Oracle 10g's Undo Advisor : Oracle 10g simplifies the creation of undo records with Undo Advisor.
Installation Cookbooks: Deploying Reports on the Web : Last week we discussed making the move from the client-server model of Forms to the 9i/10g Application Server Web-based architecture. This week Steve Callan covers the steps to use Reports-related built-in's in your forms, how to "tell" your forms the name of your report server, how to toss in some JavaScript so an "Exit" button will exit a form and close the browser window, and how to use and configure the in-process report server.
The Oracle 10g Scheduler, Part 2: Implementation : Oracle 10g's new DBMS_SCHEDULER package offers significant improvements over DBMS_JOB for scheduling jobs and tasks. This article – the second in a series – provides practical examples of using the Oracle Scheduler's new functionalities, including a discussion of transitioning from DBMS_JOB to DBMS_SCHEDULER.
Installation Cookbooks: Deploying Forms on the Web : This installment of the Installation Cookbooks series lays out a deployment framework to address the 'now that I have these things installed, what do I do next?' questions that are appearing with greater frequency on Oracle-related websites, including Oracle's own MetaLink site.
DBA Call to Action: Get up and GO : If you aren't moving you will never go anywhere. It is time to dust off your DBA shoes, and start thinking about your future.
Oracle Response Files – Part 1 : Oracle's response files can be harnessed and used to your advantage. Learn how to use this untapped resource that can save you time and standardize installation of your Oracle products.
Oracle's SPFILE - Part 2 : In part two of this series, Amar Padhi examines practical example of working with the SPFILE.
Automate the Sizing of your SGA in Oracle 10g : There are plenty of options available for tweaking the SGA. However, without a complete understanding of what our applications are doing in the background, our ability to guess the appropriate amount of memory to give each of these individual components is not always optimal. Oracle now has methods to determine most of the major parameters all on its own.
The Oracle 10g Scheduler, Part 1: Overview : Oracle 10g's new DBMS_SCHEDULER package offers significant improvements over DBMS_JOB for scheduling jobs and tasks. This article - the first in a series - provides an overview of the new functionalities that the Oracle Scheduler provides for DBAs.
Connecting with Oracle: The Password Game : Steve Callan reviews the use of Oracle's internal password function and the use of a SQL script for verifying password complexity.
Oracle 10g's Redo Logfile Sizing Advisor : Improperly sized redo logs can impede the performance of your database and hamper recovery time in the event of a database crash. Oracle has given us yet another advisory that helps us to properly size redo logs, taking yet another tedious task from us.
Oracle Administration - Part 2 : Part one of this series covered some important aspects of Oracle administration (MetaLink and licensing). Part two of this mini-series highlights the Oracle PartnerNetwork (OPN) and Oracle sales/reselling.
Oracle's SPFILE - Part 1 : Server Parameter File (SPFILE) is an extension of the initialization parameter storage mechanism, which allows some additional advantages as compared to the simple text based init.ora file. Learn which parameters can be dynamically modified to affect the present instance, and which require the instance to be brought down so that changes can take affect.
Introduction to Oracle 10g's New SQLAccess Advisor : If you have ever had a difficult time tuning applications because you can never find the SQL or code behind these applications, Oracle 10g's new SQLAccess Advisor, a new tool from Oracle, is a must.
Oracle Administration - Part 1 : This two-part series provides an overview of Oracle administration, including the use and licensing of Oracle's software.
True Session Wait Activity in Oracle 10g : Catching a session waiting on a resource used to be hit or miss. James Koopmann examines how Oracle 10g expedites this process.
Introduction to Oracle 10g's New SQL Tuning Advisor : Join James Koopmann to learn how Oracle has helped us to alleviate the pain associated with tuning SQL.
Watching SQL Execute on Oracle – Part II : Do you have SQL running within your database? Of course you do. This article is the second in a series introducing how to extract more information about the SQL that is executing in your Oracle databases.
Watching SQL Execute on Oracle – Part I : Do you have SQL running within your database? Of course you do. This article, first in a series, introduces a method of finding information about the SQL your users are executing in your Oracle databases.
Instant Client in Oracle 10g : Wouldn't it be nice if you didn't have to install the full Oracle client software just to get connectivity to an Oracle instance? Well, it's now reality with Oracle's new Instant Client software offering.
Executing External Programs From Within Oracle : Finally, Oracle 10g has given us the ability to execute external programs from within Oracle. James Koopmann takes a look at what needs to be done to expose this new feature.
Oracle's Sample Schemas: Saying Goodbye to Scott : Did you know that Oracle's "Scott" schema is slated for the bone yard? How many thousands of people have learned SQL, SQL*Plus, and PL/SQL on the back of poor old Scott? Steve Callan introduces the new 'crew'--HR, OE, PM, QS and SH.
New Features in Oracle 10g for SQL*Plus and iSQL*Plus : Don't wait for your shop to get an Oracle 10g database up and running. Download the client software and start using these great new features!
Decrypting Oracle's DBMS_OBFUSCATION_TOOLKIT : To secure sensitive data, Oracle provides developers with the DBMS_OBFUSCATION_TOOLKIT, an industrial strength version of the DBMS_RANDOM package. You may feel the need of a decoder just to keep track of all the acronyms and to decrypt the errors in Oracle's sample code, but once you see how easy it is to use, you'll be able to take Oracle's code example and modify it for your own use.
Connecting with Oracle: Accessing Oracle via Access and Excel : Giving your users the ability to access an Oracle database using either Access or Excel is easy to do. It takes all of three minutes to set up the link or connection. Learn how in Connecting with Oracle, Part 4.
Multiple Temporary Tablespaces in Oracle10g : The creation and use of temporary tablespaces has just taken another leap in performance and manageability, which should make us all re-think how we have created and assigned our users to temporary tablespaces.
Education and certification programs for Oracle's database, tools, and applications products. IT training for Cisco, Microsoft, Sun Solaris, Oracle DBA, and Java programming topics. Learn more about Oracle certification at Education Online Search. Search our Oracle exam guides. Oracle9i DBA Certification Boot Camps - $40 includes Oracle 10g. Stimulate your Oracle training with extremely realistic Transcender exams. The Training Camp offers Oracle DBA certification training camps for networking. Increase your earning power. TechSkills' flexible, self-paced Oracle training. Complete oracle DBA certification training package. 24/7 Oracle, DB2, SQL support. A flexible answer to database needs. OCP: Oracle Certification - Ensure your success in OCP (Oracle certification) exam. Get information and links for Oracle certification tracks, including exam preparation, books, practice tests, and links. ... Guide to Oracle Certification.
Oracle8i training from Oracle experts who have real-life experience using Oracle Database products. We can train you for Oracle's certification exams: Oracle10g, Oracle9i. Training BootCamp Exam Questions. training tools for Oracle exams are your ticket to certification success. Oracle study guides, exam questions, Oracle prep materials. Try our Oracle ... will prepare you for the questions asked when seeking your Oracle Certification. code, utilities and a user forum. Covers Oracle 8i, 9i and 10G. ... Oracle Certification. Forums. Blog. Blog Aggregator. Industry News. Book Store. Questions and answers about the available Oracle Certification Exams and Tests. ...
What official Oracle certification tracks are available? Oracle Certification Training BootCamp Exam Questions ... training tools for Oracle exams are your ticket to certification success. Oracle Braindumps for Certification Training at Blue Braindumps ... Prepare for your Oracle certification today! ... part of more than one Oracle certification. ORACLE DBA Certification Exam - Book Page. ... Oracle Exam & Certification Page. Oracle Certified Professional/DBA .Oracle Certification Training Boot Camp Classes and Courses on Videos and CDS. Learn Oracle with our training curriculum for 8i and 9i for Administration and Developer. Pass Oracle certification exam in first attempt. ... The Oracle Certified Professional (OCP) certification is given by one of the. Oracle Architecture. Startup and Shutdown Instance. Create a Database. Access and Update Data ... Oracle and Oracle Certification Training. Oracle8i training from Oracle experts who have real-life experience using Oracle Database products. We can train you for Oracle's certification exams: Oracle10g, Oracle9i. Assisting Oracle customers and professionals by providing technical discussion, an integrated Oracle directory, job postings, news, and much more. A student entering the Oracle Certification Program must start with this course. ... prepared to take the Oracle Certification exam for the completed track. Oracle Certification Training for Oracle exams buy Exact Questions. Gauranteed Certification with 100% Exact Questions. New Oracle certification being offered. Oracle Training Videos and CD-ROMS Certification... Cisco,Unix,MCSE,Linux, Certification ... The complete Oracle Certification for 8 Certified Database Administration.
Transferring Operating System Files from within Oracle : As new versions of Oracle are released, we are less likely to access the operating system. The ability to move data files from within Oracle is just one more great hook to the operating system that aids DBAs in their daily tasks.
Connecting with Oracle: Oracle Ports : 1521. 1810. 2481. 7778. These are just a few of the port numbers Oracle uses in networking. Everyone knows 1521 is the typical port number used by a listener, but how sacrosanct is that? This article will help clarify some facts about port usage related to Oracle.
Installation Cookbook: Installing Oracle Application Server 10g (9.0.4)Forms and Reports Services : Support for versions older than Oracle 9i is coming to an end--users wanting to view data in a database via forms will have to move to Oracle 9i/10g forms. The big show stopper on that process is that you need to have Application Server installed and running to view 9i/10g forms on the web. Learn how to install Application Server and make the connection to your databases.
Connecting with Oracle: Finding and Setting a Configuration File Location : You can have a 'good' tnsnames.ora file, but 'reject' its use due to not knowing where it is. You can have a 'bad' tnsnames.ora file in a location you know about, and try to 'accept' its use. Both situations are bad. Fortunately, each is easy to correct. Learn how to set a location for your tnsnames.ora file and where to look for that location.
Connecting with Oracle : Steve Callan discusses a common error frequently seen in Oracle Net Services. Learn how to avoid the "ORA-12154: TNS: could not resolve service name" error.
Product Review: Thomson Course Technology's Oracle9i Database Performance Tuning : When it comes to IT training, how do you want to spend your hard-earned dollars? There are plenty of options, approaches, and vendors to choose from, so it helps if you have a specific or somewhat focused goal in mind before spending your money. Steve Callan begins his product review series with a look at Thomson's course on performance tuning.
Virtual Indexes in Oracle : Oracle's Virtual Indexes have a specific purpose and do not behave like normal indexes. Learn how to create and use these pseudo-indexes.
Transitioning to Locally-Managed Tablespaces : Oracle 8.1.6 offered a new format for tablespace storage management – locally-managed tablespaces – that offers significant improvements in tablespace performance and free space management. Oracle 9i Release 2 improved upon segment storage in locally-managed tablespaces with the Automatic Segment Storage Management option. This article delves into the advantages of using locally-managed tablespaces over dictionary-managed tablespaces and suggests practical methods to achieve the transition.
Inserting Custom Messages in Oracle Alert/Trace files : Learn how to insert your own customized message into alert log and/or trace files.
Oracle's Wrap Utility : With Oracle's wrap utility, you can turn the inner workings of your code into an impenetrable black box, for the most part, to protect your property. Learn how in this article from Steve Callan.
Bulk Binds and Collects in PL/SQL - Part 2 : Part 2 of this series continues a discussion of how to work with collections. This installment covers avoiding performance issues when retreiving immense amounts of data in PL/SQL collections.
Oracle Performance Tuning - (Otherwise Known as Drowning in a Pool of Confusion) : Steve Callan offers recommendations on two excellent books that plainly and effectively tell you what to look for, and more importantly, how to fix a poorly performing system.
Oracle on Windows - Part 3 : Microsoft and Oracle issue strong advisories against manually editing the Windows registry, yet both of them tell you how to do just that. If you have been reluctant to edit your registry because of the horror stories you have heard, then this article will help you overcome some of that trepidation.
Using Cursor Variables As Function Arguments on Oracle 9i : Oracle 9i offers the ability to pass data to a PL/SQL function in the form of a cursor variable. When this feature is paired with the concept of the table function, the resulting PL/SQL code increases significantly in flexibility and scalability. This article builds upon the author's previous article on table functions and provides a brief technical explanation of how best to implement this feature.
Bulk Binds and Collects in PL/SQL - Part - 1 : This article begins a discussion of how to work with collections. Previous versions of Oracle had limitations for collection usage in regards to SQL statement processing. Bulk Bind and Collect features were introduced to reduce the SQL processing overhead by efficient use of collections in PL/SQL code.
Striking Gold with LogMiner - Part 1: Getting Started : Oracle's LogMiner utility has been around for several years now, and it originally appeared as a new feature (as opposed to being an improvement of something else). The purpose of this series is to help demystify some of the procedures, illustrate some examples of using LogMiner, and to recommend cases where LogMiner should be a DBA's primary tool for recovering lost data.
Creating NOT NULL Columns in Huge Oracle Tables : Databases are often taxed by applying SQL statements to enormous tables. One such activity is when we add a new NOT NULL column with default value to a huge transaction table. Amar Padhi shares several methods to add a new column with default value, comparing the advantages and disadvantages of each.
Surviving a Database Disaster with RMAN Backups : Follow along with this real-world disaster scenario and learn how one company recovered their databases using RMAN backups.
Decrypting Oracle's DBMS_OBFUSCATION_TOOLKIT : To secure sensitive data, Oracle provides developers with the DBMS_OBFUSCATION_TOOLKIT, an industrial strength version of the DBMS_RANDOM package. You may feel the need of a decoder just to keep track of all the acronyms and to decrypt the errors in Oracle's sample code, but once you see how easy it is to use, you'll be able to take Oracle's code example and modify it for your own use.
Connecting with Oracle: Accessing Oracle via Access and Excel : Giving your users the ability to access an Oracle database using either Access or Excel is easy to do. It takes all of three minutes to set up the link or connection. Learn how in Connecting with Oracle, Part 4.
Generating random numbers and strings in Oracle : Generating random numbers or strings is oft-times a necessity. Oracle provides a random number generator that is faster than writing your won random generation logic in PL/SQL, and can generate both character and alphanumeric strings. Perhaps it is time to learn more about the DBMS_RANDOM package.
CASTing About For a Solution: Using CAST and Table Functions in PL/SQL : Oracle 8i offered the CAST function, which allows a PL/SQL collection to be processed as if it was a normal table. When CAST is paired with table functions, it becomes even more powerful as a data manipulation toolset. This article provides a brief technical explanation of CAST and table functions as well as some practical, real-world examples of their use in concert.
A Practical Guide to Data Warehousing in Oracle, Part 6 : Materialized Views are continually enhanced by Oracle to leverage data warehouse performance and maintainability. This is the first in a mini-series of articles that will introduce the concept, identify some of their uses and describe some potential problems with them.
Multiple Temporary Tablespaces in Oracle 10g : The creation and use of temporary tablespaces has just taken another leap in performance and manageability, which should make us all re-think how we have created and assigned our users to temporary tablespaces.
So You Want to Become an Oracle DBA? Part 2 - Learning Oracle on your own : The second half of this two-part series on how to become an Oracle DBA in today's almost non-existent DBA job market focuses on inexpensive and effective means of learning Oracle.
Oracle Background Processes : With every release of Oracle, background processes have been added or modified. Amar Kumar Padhi takes an in-depth look at these processes that are key to the proper working of the database.
Transferring Operating System Files from within Oracle : As new versions of Oracle are released, we are less likely to access the operating system. The ability to move data files from within Oracle is just one more great hook to the operating system that aids DBAs in their daily tasks.
A Practical Guide to Data Warehousing in Oracle, Part 5 : Why can a data warehouse be operated successfully and safely without integrity being enforced at the database level? Learn about creating lightweight declarative integrity constraints that avoid much of the unwelcome overhead of maintaining enforced constraints.
Oracle's CASE Expression : Faster than a speeding bullet, more powerful than a locomotive... Perhaps not, but Oracle's CASE expression can do all that the DECODE function does, plus a whole lot more.
Unwrapping Oracle's DBMS Packages: Understanding Oracle's Random Number Generator : Beginning with later versions of Oracle8, Oracle has provided a means of generating random numbers. This built-in package, DBMS_RANDOM, is fairly simple to use, and can generate random numbers which are generally good enough for the needs of most users. Learn more as Steve Callan unwraps the first DBMS package of this series.
Parsing in Oracle : Amar Kumar Padhi discusses the process of parsing, the difference between soft and hard processing, how Oracle deals with identical statements and various methods to reduce hard parsing.
Don't Just Do Something, Stand There! Avoiding Junior DBA Mistakes : When an Oracle database suddenly becomes unavailable, the immediate reaction is to do something -- right now! -- to solve the problem, which sometimes makes the problem worse. This article discusses some examples of when it's really best to stop and think before proceeding.
Data Modeling, Breaking & Fixing First Normal Form (1NF) : Call by Reference Parameters in PL/SQL (The NOCOPY Hint) The inability to conform to the very basics of data modeling principles often causes enormous problems for data modelers, administrators and the development chain. Of those principles, adhering to 1NF is probably the most broken rule. When the model does not follow 1NF, queries are hard to develop and producing usable data from the model is even harder. This article explores some of the common mistakes and their fixes.
Connecting with Oracle: Oracle Ports : 1521. 1810. 2481. 7778. These are just a few of the port numbers Oracle uses in networking. Everyone knows 1521 is the typical port number used by a listener, but how sacrosanct is that? This article will help clarify some facts about port usage related to Oracle.
So You Want to Become an Oracle DBA? Part 1 – Getting Close to Oracle : This is the first of a two-part series about how you can become an Oracle DBA in today's almost non-existent DBA job market.
Working with VARRAYs in Oracle Part III : The third and final installment of this series examines the performance implications of using VARRAYS.
Practical Data Warehousing in Oracle, Part 4 : On a regular OLTP system, one of the perennial sources for doubt and debate is the number, type and configuration of indexes. Dave Aldridge shares some simple principles that can be applied to the business of indexing a data warehouse.
Oracle on Windows - Part 2 : Oracle on Windows is easy to use, and even easier to use if you have a good understanding of how the Windows operating system works. With Oracle's new pricing scheme aimed at enticing small businesses to make the switch from the SQL Server arena, you almost cannot afford not to know more about the Oracle and Windows combination.
The Mutation error in Oracle Database Triggers : Amar Kumar Padhi discusses the causes of the mutating table error and how to prevent it.
Oracle Database Resource Manager, Part 3: Conclusion : Oracle Database Resource Management (DRM) provides tools that allow any Oracle DBA to manage a database server's CPU resources effectively for application user groups and during different resource demand periods. This final article builds upon the concepts in the two previous articles, including the construction of more complex resource plans, monitoring DRM utilization, and general DRM maintenance.
Using Oracle's SQL Functions - Part 2 : The second article of this series looks at 11 SQL-related functions commonly used in statistics: count, sum, average, standard deviation, variance and covariance (standard deviation and variance have three each; covariance has two).
Working with VARRAYs in Oracle - Part II : Part two of this three part series takes you through the steps on how to abstract the difficulty from using VARRAYs so that developers or end uses can interact with these structures through familiar table insert and select statements.
Installation Cookbook: Installing Oracle Application Server 10g (9.0.4)Forms and Reports Services : Support for versions older than Oracle 9i is coming to an end--users wanting to view data in a database via forms will have to move to Oracle 9i/10g forms. The big show stopper on that process is that you need to have Application Server installed and running to view 9i/10g forms on the web. Learn how to install Application Server and make the connection to your databases.
Use Oracle's DBMS_APPLICATION_INFO to Prevent Routines from Running Simultaneously : Learn how to use Oracle's DBMS_APPLICATION_INFO to prevent two routines or business processes from running at the same time.
Working with VARRAYs in Oracle Part I : James Koopmann presents a three part series designed to take you through the process of creating VARRAYs and dealing with them in Oracle tables.
Using Oracle's SQL Functions : Oracle provides quite an array of functions when it comes to manipulating data via SQL. Of particular interest for this new series, are the functions related to numbers. Learn how this relates to your job as a DBA.
A Practical Guide to Data Warehousing in Oracle - Part 3 : There are three major advantages of partitioning. Learn what they are in part 3 of A Practical Guide to Data Warehousing in Oracle.
Locking Down SQL*Plus Security : Is your data at risk? Users with valid database username/password combos can log into a database from SQL*Plus and view or edit critical data not accessible from an application itself. The question is, how do you prevent users from accessing data via SQL*Plus? Learn how to insert restrictions in the PRODUCT_USER_PROFILE (PUP) table, owned by the SYSTEM user.
Oracle Database Resource Manager, Part 2: Resource Plan Management : Oracle Database Resource Management (DRM) provides tools that allow any Oracle DBA to manage a database server's CPU resources effectively for application user groups and during different resource demand periods. This article builds upon the concepts in Part 1 to build and maintain more complex resource plans, assign users to resource consumer groups, and manage users and session utilization of DRM resources.
DBA Call to Action: Zeroing in on Performance Problems : Have you ever been asked to help with the evaluation of a database that is not performing optimally? Here is a quick guide to help you if you just do not know where to start.
Installation Cookbooks: Installing Oracle9i Developer Suite : Most people can muddle through Oracle product installations on their first one or two attempts. But what happens when you run into the occasional lemon-like installation guide, such as the one for Oracle9i Developer Suite (iDS)? Steve Callan offers a detailed, step-by-step installation cookbook for installing Oracle9i Developer Suite (9.0.2, including a patch) on a Sun Solaris platform.
DDL Event Security in Oracle Database : Secure your Oracle database against structural or Data Definition Language (DDL) changes.
Storing Word Documents in Oracle : Have you ever wondered about storing documents in your Oracle database but didn't know where to start? Here is a quick introduction to the basics you need to know.
Oracle on Windows : Why should you use Oracle on Windows or even bother to learn about it? One reason is, if you change jobs often enough or develop enough applications, sooner or later, you're dealing with Oracle on Windows.
Oracle A Practical Guide to Data Warehousing in Oracle, Part 2 : Part 2 of 'A Practical Guide to Data Warehousing' examines the various possible attributes of tables, and seeing what use can made of them in the different table types of a data warehouse.
Oracle Optimizer: Moving to and working with CBO - Part 7 : The final installment of this series covers the basics of using Stored Outlines and Oracle Application specific information.
The Trigger-Happy DBA - System Triggers : The use of system triggers can greatly expand a DBA's ability to monitor database activity and events. Join Steve Callan as he examines the creation and use of system triggers.
Oracle Database Resource Manager, Part 1:Overview : Oracle Database Resource Management (DRM) provides tools that allow any Oracle DBA to manage a database server's CPU resources effectively for application user groups and during different resource demand periods. This article provides a brief overview of how DRM works and then delves into the preparations necessary to implement a simple DRM configuration.
Manipulating Oracle Files with UTL_FILE : Take hold of your alert log with the use of a few new subprograms in the UTL_FILE package.
Installation Cookbooks: Installing Oracle Forms & Reports 6i : More often than not, the DBA owns everything related to Oracle, whether or not the DBA has anything to do with that 'other' Oracle stuff. It's time to shake off the narrow-minded view about what a DBA does and expand your knowledge of Oracle's installation process.
DBA Call to Action: New Year Resolutions : James Koopmann looks at ways to plan your New Year resolutions around your current DBA roles and responsibilities.
Installation Cookbooks: Installing Oracle9i : In his new series, Installation Cookbooks, Steve Callan lays out a methodology for installing Oracle products on UNIX-based systems (primarily using Solaris).
The Trigger-Happy DBA - Part 2 : What a form trigger can do, and has in common with the "pure" development type of trigger, is generate the ORA-04091 mutating table error. Learn how to work your way around this error by taking your DML elsewhere.
Oracle Optimizer: Moving to and working with CBO - Part 6 : Previous installments of this series have covered how the Cost Based Optimizer works and behaves. In part 6 of the series, learn how to assist the optimizer to do its job properly.
CONFIGURE This! Taking Advantage of Oracle 9i Recovery Manager (RMAN) Features During Backups : Oracle Recovery Manager (RMAN) features have been expanded significantly in Oracle 9i. This article discusses several of these new features and includes examples on how to implement them to make any Oracle DBA's backup, restoration, and disaster recovery plans more effective.
Oracle Technical Interview Questions Answered – Part 2 : James Koopmann provides more answers to the questions raised in his popular article "Technical Interview Questions."
Oracle Technical Interview Questions Answered – Part 1 : James Koopmann responds to readers by providing answers to the questions raised in his popular article 'Technical Interview Questions.'
The Trigger-Happy DBA : Triggers can be an effective tool to manage and control data, and to enforce business rules and logic. Some of the more commonly used areas include auditing, enforcement of business rules, and behind the scenes DML-related operations. This first article in the series focuses on DML triggers.
Practical Data Warehousing in Oracle, Part I : Enemy Number One--the disk subsystem. Nothing will cripple a data warehouse more effectively than a failure to manage your i/o requirement vs. your i/o capacity. Take a different look at disk capacity.
Oracle Optimizer: Moving to and working with CBO - Part 5 : This month in Moving to and working with CBO, Amar Kumar Padhi examines the data skewness problem and the use of the Monitoring option for updating statistics on the fly.
Oracle Label Security, Part 4: Conclusion : Oracle Label Security (OLS) offers a powerful implementation of row-based security that is perfect for restricting user access to specific data, especially in a data mart or data warehousing environment. This concluding article wraps up this series with a discussion of some advanced OLS features as well as mechanisms for maintaining an existing OLS security policy.
Oracle9iR2 Segment Level Statistics : Oracle's Segment Level Statistics gives you the power to make decisions on the configuration of structures within Oracle as well as to application code. Learn how to fine tune memory structures and access methodologies using Oracle's Segment Level Statistics.
Connecting with Oracle: Finding and Setting a Configuration File Location : You can have a 'good' tnsnames.ora file, but 'reject' its use due to not knowing where it is. You can have a 'bad' tnsnames.ora file in a location you know about, and try to 'accept' its use. Both situations are bad. Fortunately, each is easy to correct. Learn how to set a location for your tnsnames.ora file and where to look for that location.
Oracle9iR2 Shared Pool Advisory : Learn how to get the most out of your Oracle database using the Shared Pool Advisory.
A Practical Guide to Data Warehousing in Oracle: Series Introduction : Making the mental leap from OLTP to data warehousing is a daunting prospect. This series of articles is intended to be a reference to answer both questions you have and those that you don't even suspect you need answsers to. As an introduction to the series, Dave Aldridge discusses a few high-level differences between OLTP and Data Warehousing systems.
Oracle: Preventing Corruption Before it's Too Late - Part 2 : Marin Komadina discusses Oracle data-block corruption, describing several features of Oracle that may be used at an early stage to detect database corruption. Part 2 of this series explores Oracle soft and bug corruption.
Oracle Optimizer: Moving to and working with CBO - Part 4 : Part 4 of the Oracle Optimizer series covers the various facilities available for generating statistics in Oracle database.
Connecting with Oracle : Steve Callan discusses a common error frequently seen in Oracle Net Services. Learn how to avoid the "ORA-12154: TNS: could not resolve service name" error.
Oracle Label Security, Part 3: Administration : Oracle Label Security (OLS) offers a powerful implementation of row-based security that is perfect for restricting user access to specific data, especially in a data mart or data warehousing environment. Previous articles presented a brief overview of how these features work, and how these features can be implemented in any Oracle database. This article discusses how Oracle Label Security policies can be administered when data or users change.
Oracle's Default TEMPORARY Tablespaces : Using the SYSTEM tablespace as a temporary tablespace is to be frowned upon, yet Oracle still lets us assign it as such. James Koopmann explores a better way.
Oracle Technical Interview : Uncertain about the technical interview process? James Koopmann offers 65 technical questions to get you up to speed for that technical interview.
Preventing Corruption Before it's Too Late: Part 1 : Marin Komadina discusses Oracle data-block corruption, describing several features of Oracle that may be used at an early stage to detect database corruption.
Oracle Optimizer: Moving to and working with CBO - Part 3 : In this months installment of "Oracle Optimizer and how to move to CBO," Amar Padhi covers the Initialization parameters and Hidden or Internal Oracle parameters that influence the Optimizer in choosing execution plans.
DBA Call to Action: Oracle Database Integrity : James Koopmann offers a refresher on database integrity, and why it's important.
Oracle Label Security, Part 2: Implementation : Oracle Label Security (OLS) offers a powerful implementation of row-based security that is perfect for restricting user access to specific data, especially in a data mart or data warehousing environment. A previous article presented a brief overview of how these features work; this article presents how a reasonably skilled Oracle DBA can configure a database for OLS, install an OLS security policy, implement security for users, and impose row-level security for data.
Oracle Time Zone : Just when you thought you knew where you were, Oracle has implemented time zones to totally zone us out. Join James Koopmann while he figures out where on this great planet we are.
A Comparison of Oracle 9i with DB2 v8.1 : Alexander Chigrik compares Oracle 9i with DB2 Universal Database v.8.1 regarding price, platforms supported, features, and product limits.
What's In A Name - Naming and Idenifying Oracle Databases and Instances : Identification of the database you are currently working on can sometimes be somewhat confusing. James Koopmann examines the parameters that need to be set and at the same time explains ways of determining to which database and instance you are working and connected.
Oracle Label Security, Part 1: Overview : Oracle Label Security (OLS) is a relatively new feature of Oracle 9i. It offers a powerful implementation of row-based security that's perfect for restricting user access to specific data, especially in a data mart or data warehousing environment. This article presents a high-level view of this new set of features in preparation for implementation by any reasonably skilled Oracle DBA.
Deleting Historical Data on Oracle Databases : Archiving historical database data is an important, complex and in most cases forgotten task of database projects. Marin Komadina examines the problem of deleting historical data and presents some practical tips on how to execute and check the deleting performance.
ETL Prototype using Oracle Warehouse Builder – Part 3 : Nandeep Nagarkar shares his views on choosing the Oracle Warehouse Builder as a tool in an Oracle data warehouse life cycle management project, along with quick steps to get started with a simple "prototype."
Oracle Optimizer: Moving to and working with CBO - Part 2 : In this months installment of 'Oracle Optimizer: Moving to and working with CBO,' Amar Padhi covers the Initialization parameters and Hidden or Internal Oracle parameters that influence the Optimizer in choosing execution plans.
Tracking Data Access Patterns in Oracle : Performance in Oracle is directly related to the SQL workload that is submitted. Often it is not the change in the SQL that degrades performance but instead is the access path to that data. This article will help you understand when new access paths have been introduced in your environment.
Oracle PL/SQL Built For Speed : Everyone is looking for an edge. With PL/SQL that edge is compiling the PL/SQL code into native code. James Koopmann shows you how to setup and compile your PL/SQL procedures and packages.
Excel Document Management with the Oracle iFS (Internet File System) : Marin Komadina explains one of the lesser-known methods of controling information chaos using Oracle iFS. Learn how Excel documents can be securely stored and retrieved from the Oracle database using iFS.
Automating ETL using Oracle warehouse Builder – OWB architecture : In part 2 of the Oracle Warehouse Builder series, Nandeep discusses the Oracle Warehouse Builder architecture, its compliance with industry standards and is technical suitability for use in DW projects.
Oracle Safety Blankets: Insulating Your Applications Against Database Changes : Changes to Oracle database objects can wreak unexpected havoc on the applications that depend on them, especially when the database objects are invalidated even for a brief period. This article discusses some techniques that any DBA can put into practice to limit the impact of database object changes on dependent applications.
Oracle Optimizer: Moving to and working with CBO : Learn about the Oracle Optimizer and various efficient ways of moving to Cost Based Optimizer. Part 1 of a five part series.
A Comparison of Oracle's DATE and TIMESTAMP Datatypes : If you want to store date and time information in Oracle, you really only have two different options for the column's datatype. Join James Koopmann as he examines the DATE and TIMESTAMP datatypes
Oh Danny Boy, The DBMS_PIPES Are Calling : Oracle pipes have been around for a long time but just how many use this powerful mechanism? James Koopmann explores this feature, reminding us all that it is not dead yet.
The Road from Oracle8i to Oracle9i Certification : Follow along with James Koopmann as he travels the road from Oracle8i to Oracle 9i certification.
Automating ETL using Oracle warehouse Builder – Part 1 : Prototyping is one of the best-suggested approaches in mitigating the adverse effects of unforeseen problems in the data warehouse development cycle. In this series, Nandeep Nagarkar focuses on prototyping the ETL stage of the data warehouse life cycle using Oracle WareHouse Builder.
It All Depends on the CONTEXT: Using the SYS_CONTEXT Function : The SYS_CONTEXT function is the recommended replacement method for obtaining information about users and environment variables instead of the deprecated USERENV function. This versatile function has been expanded in Oracle 9i to provide a plethora of information about the Oracle database and its processes as well as its users and sessions.
Understanding Oracle's Locally Managed Tablespaces : Locally Managed Tablespace (LMT), one of the key features in Oracle databases, has been available since Oracle 8i. Amar Padhi offers some scenarios of note for systems that are already using LMTs or planning to shift to LMTs.
Using Oracle Locks to Manage Data Concurrency and Consistency : Ever wonder what prevents the same data from being modified by two or more users at the same time? Learn how Oracle manages data concurrency and consistency by using Locks.
Returning Rows Through a Table Function in Oracle : James Koopmann introduces Oracle's Table Function. Learn how to call a table function within the FROM clause of a SQL statement and have it return a result set that mimics what we would normally expect from a traditional SQL SELECT statement.
Document Management with Oracle Text : Powerful procedures for handling image, audio, video and the text data in various formats are incorporated in the Oracle database kernel code. Marin Komadina looks at the ins and outs of the feature originally known as ConText, then interMedia Text, and finally Oracle Text.
Disk Sorts - A Subtle Threat to Database Performance : Disk sorts are a near-silent performance vampire that can rob a database of good response times. Intelligently diagnosing the presence of disk sorts and then doing what you can to reduce or eliminate them altogether, you can remove this subtle threat to your database's performance.
Altering Oracle's SQL*Plus Help Facility : Everyone needs a little help now and then. James Koopmann finds new ways to provide information to users of SQL*Plus through the Help Facility.
So You Want to Use Oracle's SPFILE : Oracle's traditional method of storing parameters in the INIT.ORA file has given way to a more robust method-- the server parameter file (SPFILE). Learn what truly works in converting and maintaining your parameters without ever having to use an editor again.
Reporting Database Object Increase On Oracle : On the production Oracle system, a DBA is responsible for collecting database increase statistics. Learn how to do so easily and economincally, without changing the existing database.
Using Index Hints in SQL statements - 'Cause we know more about our application than Oracle does : Hints are used to give specific information about our data and application, to Oracle. Ajay Gursahani examines Index Hints, how they can improve certain SQL statements that might otherwise be inefficient, and the advantages of doing so.
Change data capture implementation in Oracle Data warehouses – Part 3 : Nandeep Nagarkar continues his series on change data capture implementation in Oracle Data warehouses. Learn about the change data capture model and how to publish subscribe to change data.
Getting ANSI About Joins : The new ANSI format for joins in Oracle 9i may appear alien at first, but they have the potential to become part of a DBA's arsenal for clarifying SQL and PL/SQL code. This article discusses the new join formats including NATIVE, CROSS, and OUTER and includes examples for review and comparison to the "traditional" join mechanisms.
DBA Call to Action: Make an Impact : A DBAs true value is not only to maintain database order but also to provide technical advantages to the company. Join James Koopmann as he breaks out of the cubical shell with a mission to 'make an impact.'
Recovering Accidentally Lost Data Using Oracle's Flashback Query : Recent studies show that nearly 50% of system outages are due to human errors. Oracle 9i's new feature, Flashback Query allows the user to view an old image of data that has been modified and committed by the DML statement, without requiring any structural changes to the database.
Manually Refreshing Materialized Views and Creating Refresh Groups in Oracle : Learn how to manually refresh materialized views and create refresh groups using Oracle supplied packages.
DDL Generation--Oracle's Answer to Save You Time and Money : The days of building your own DDL extraction utilities are almost gone; Oracle has given us a simple way to generate the DDL for objects defined in the database. Join James Koopmann as he delves into DBMS_METADATA.GET_DDL.
Getting control of the Oracle Java Virtual Machine : Being the master of your database means gaining control of Oracle's Java Virtual Machine. Follow along with Marin Komadina as he explains installation tricks and offers some practical JVM tips.
Becoming the Master of Disaster : If a disaster happened to your database server, could you recover from it? This article discusses the questions a DBA can ask to probe the realm of what we all hate to think about - the possibility of the untimely demise of a production database server. Learn how to become a fearless 'master of disaster'.
Materialized Views in Oracle : Learn how to make local copies of remotely located data & specify automatic refreshes.
Database Impact of Collecting Statistics in Oracle : Oracle has given us a new parameter STATISTICS_LEVEL for collecting database statistics. James Koopmann takes a deeper look at what to expect from your database system when this parameter is set and statistics are being gathered.
Get the init.ora parameter value using DBMS_UTILITY : Ajay Gursahani explains how to get the values for the parameters specified in 'init.ora' by using the GET_PARAMETER_VALUE procedure supplied with the DBMS_UTILITY package.
Implications of Setting Oracle9iR2's Statistics Collection Level : Concerned about looking at statistics within Oracle? You should take a quick look at Oracles' new method of turning collections on or off.
Change data capture implementation in Oracle Data warehouses - Part 2 - Oracle Streams implementation : In part-1 of the series, we discussed the overall view of Oracle Streams and the process of information sharing between databases. Part-2 of this article, presents a scenario to demonstrate a simple and "straight-forward" configuration for Oracle Streams.
The comparison of SQL Server 2000 with Oracle 9i : Alexander Chigrik compares SQL Server 2000 with Oracle 9i Database regarding price, performance, platforms supported, SQL dialects and products limits.
Recompiling PL/SQL Objects using DBMS_DDL package : Learn how to compile PL/SQL objects that are, already stored in the database using DBMS_DDL Oracle supplied package.
Hold On There SYSter : Probably the most sacred user in all of Oracledom is the SYS user. Koopmann takes a quick look at how DBAs can take hold of this often misused account.
EXECUTE IMMEDIATE option for Dynamic SQL and PL/SQL : Amar Kumar Padhi shares usage tips and examples of EXECUTE IMMEDIATE, which replaced DBMS_SQL package in Oracle 8i and above.
Activating, Monitoring, and Tuning Automatic PGA Memory Management via PGA_AGGREGATE_TARGET Under Oracle 9i : Sizing the Program Global Area (PGA) is now one of many tasks made simpler under Oracle 9i. Learn how a database server utilizes the PGA, how the PGA can be automatically sized using PGA_AGGREGATE_TARGET initialization parameter, and how the PGA's size can be monitored and tuned using some new dynamic database views, now part of 9i.
Protecting Oracle Instance with Local Clustering : Follow along with Marin Komadina as he explains the ins and outs of Local Clustering with Sun Cluster software.
Oracle in a Nutshell: A Desktop Quick Reference : The goal of Oracle in a Nutshell is to pull together the most essential information on Oracle architecture, syntax, and user interfaces. Learn the two basic ways to access Oracle data from Java.
Web Reports from SQL *Plus in Oracle 8i/9i : Learn how to build complete HTML Reports using SQL *Plus, Oracle's interactive query tool.
Explain Away Your Troubles : Determining when things change in a database is the first step in zeroing in on problems. One of the prime culprits to change is the very SQL that we attempt to run every day. James Koopmann shares his no-frills method to help sniff out those changes that occur.
Using Resume Operation in Oracle 9i : Learn how to suspend or resume operations using the new RESUME option in Oracle 9i
DBA Call to Action: The Information Chase : A key role of every DBA is to keep up-to-date on trends within the database industry. Journey along with Koopmann as he rids his desk of endless piles of documentation and articles while still staying on top of the latest news and trends.
Concerned About The (Oracle) Environment? : Jim Czuprynski offers suggestions on the perfect environment for evaluating software changes before they are run against the production Oracle database.
Change Data Capture Implementation in Oracle Data Warehouses - Part 1 : In the first of this three part series, Nandeep gives an overview of Oracle Streams. Part 2 of the series will focus on a simple implementation of Oracle Streams followed by part 3, which will describe the Change Data Capture framework of Oracle.
External Tables in Oracle 9i : Learn how to run any SQL query against external data without requiring that the external data first be loaded into the database.
Killing the Oracle DBMS_JOB : If you've ever had a problem with a run-away job that didn't want to end, or found that you needed to shut down the database only to find it was waiting for a job to complete, Koopmann can help. Learn how to manage those jobs that don't want to end.
How Grid Computing Can Improve Database Performance : Nathan Segal interviews Benny Souder, Vice President of Distributed Database Development for Oracle, and Jeff Jones of IBM.
Oracle9i's Auto Segment Space Management Option : Follow along with James Koopmann and learn what you, the DBA, no longer have to manage thanks to a little feature from Oracle.
Definer and Invoker Rights for stored routines in Oracle : Learn how to share procedures between users without sharing tables.
Leaving the History Behind with Oracle's Fine Grained Access Control : Marin Komadina explains how to export tables from a user schema--without having to export the history tables as well.
That Darn Alert Log : Until Oracle decides to give DBAs built-in direct access to the alert log, it will always be our responsibility to continually check and maintain it. Here is a simple solution that will help with this most basic of DBA task.
Exploring the use of Directory Objects in Oracle 9i : Nandeep explores the advantages of Oracle9i's Directory Object. Learn how to set up a directory object, access data using external tables, and get directory information from the database.
FireWire Real Application Cluster : With the demands of a 24/7 marketplace, a highly available and scalable database is getting increasingly more important. In the past, you had to choose from one of two options in a cluster. RAC takes the cluster architecture even further, providing improved fault resilience and incremental system growth by offering connection failover and load balancing in the same cluster. In the event of a system failure, RAC ensures your database will still be available. RAC gives you the availability and scalability that enterprises demand.
Using Flashback in Oracle 9i : Lost data? No problem. View or recover data with Oracle 9i's Flashback feature, DBMS_FLASHBACK!
Viewing and Managing Job Queues in Oracle 9i : Learn how to schedule the periodic execution of user jobs using job queues in Oracle 9i. Also covered are topics on viewing job queue information and managing job queues.
Database Performance and some Christmas Cheer : James Koopmann demystifies some of the definitions surrounding the topic of database performance in his latest article. Whether a seasoned veteran or a beginner, the arena of database performance should not be confusing. Join Koopmann as he puts a framework around what database performance truly is.
Call by Reference Parameters in PL/SQL (The NOCOPY Hint) : Amar Kumar Padhi discusses the use of the NOCOPY parameter hint, which has been introduced for OUT and IN OUT parameters in Oracle 8i/9i. Using this hint tells Oracle to make a call by reference.
Remote Procedure Calls Will Get You the Cheese : Ever need to pull information from a remote computer through Oracle? Here is a method for getting the system date and time that you can easily expand on to pull loads of other information.
Autonomous and Distributed Transactions in Oracle 8i/9i : This article presents a basic introduction to transaction processing in PL/SQL and primarily focuses on the Autonomous transaction processing feature of PL/SQL and the changes that have occurred from Oracle 8i to 9i.
Managing Processes for External Procedures in Oracle : In his first article, Ajay Gurshahani details the use of External Routines in Oracle 8i/9i, which are helpful in eliminating the need for using CGIs and also make it possible to create dynamic libraries and call them from PL/SQL.
Abstracting Oracle Connectivity with PHP/OCI8 : Dante Lorenso presents several functions designed to help run Oracle queries without the drudgery of repetition. Take these functions, roll them into a PHP class, and voila! ... easy PHP/OCI8!
Sending E-mails from Oracle Database : In his first article for DBAsupport.com, Amar Kumar Padhi details how to take advantage of an e-mail server option in Oracle 8i that allows you to send mail from within your code.
Oracle 8i Row Chaining and Migration : Though a number of factors can contribute to performance degradation in your databases, many performance issues can be prevented by properly designing and/or diagnosing the databases. As Gaurav Sharan Gupta discusses in his first article for DBAsupport, proper diagnosis of Row Migration (RM) and Row Chaining (RC) can eliminate one of these issues and improve database performance.
Listen Software Solutions' "How To" Series: Dynamic SQL : In the final article of the "How To" series from Listen Software, author David Nishimoto discusses how to use Dynamic SQL (select, insert, update, and delete) in stored procedures.
SQLTools 1.3.5.15 Beta Released : SQLTools is a light-weight, robust tool for ORACLE database development that includes a text editor, SQL console and a couple of SQL utilities. Small enough to fit on a floppy disk and able to be used on a dial-up connection, SQLTools is a handy, portable, free program that works as fast as SQLPlus.
Listen Software Solutions' "How To" Series: The Listener Server : In the twenty-fifth article of the "How To" series from Listen Software, author David Nishimoto discusses how to start and stop the listener server and how the client and server use the listener server.
Adding Columns in a Synchronous Multi-Master Replicated Environment : So you find yourself in a synchronous multi-master replicated environment under Oracle 8i and need to add a column to a table. Greg Johnson's step-by-step guide makes the process as painless as possible.
Listen Software Solutions' "How To" Series: Using the Net 8 Assistant : In the twenty-fourth article of the "How To" series from Listen Software, author David Nishimoto discusses using the Net 8 Assistant to create a connector descriptor, using Host, Port, Sid, and logical names.
OLAP and Data Warehousing - Data Warehousing Solution Architecture (Part 2) : Alexzander Nepomnjashiy continues his series on OLAP and Data Warehousing with a focus on Online Analysis Processing (OLAP) and Data Mining technologies.
Listen Software Solutions' "How To" Series: SQL Tuning - File I/O Performance : In the twenty-third article of the "How To" series from Listen Software, author David Nishimoto offers tips and tricks for improving File I/O performance, with tuning topics focusing on the library cache, data dictionary cache, data cache hit ratios, sorting, utlbstat and utlestat, and rollback wait stats.
Listen Software Solutions' "How To" Series: SQL Tuning - Performance : In the twenty-second article of the "How To" series from Listen Software, author David Nishimoto presents sample SQL code to analyze the library cache, data cache hit ratio, buffer hit ratio, and shared pool free memory.
OLAP and Data Warehousing - Data Warehousing Solution Architecture (Part 1) : In his latest article, Alexzander Nepomnjashiy continues his analysis of OLAP and Data Warehousing with a look at the architecture used for enterprise-level business intelligence information systems organization.
Oracle 9i Locally-Managed Tablespaces (LMT) Migration Method : So you've just migrated your Oracle8i databases in which all your various sized segments reside, and now you want to place them in appropriately sized Locally-Managed Tablespaces (LMT's). Here is a brief guide from Greg Johnson to help you get started in this process.
Listen Software Solutions' "How To" Series: SQL Tuning - Optimizer Hints : In the twenty-first article of the "How To" series from Listen Software, author David Nishimoto offers hints to help improve the optimizer's performance.
OLAP and Data Warehousing - Data Warehousing Technology Review (Part 2) : In his latest article, Alexzander Nepomnjashiy continues his analysis of OLAP and Data Warehousing with a review of the technology behind and the construction of Data Warehouses.
OLAP and Data Warehousing - Data Warehousing Technology Review (Part 1) : In his latest article, Alexzander Nepomnjashiy continues his analysis of OLAP and Data Warehousing with a review of the technology behind and the construction of Data Warehouses.
Listen Software Solutions' "How To" Series: SQL Tuning - The Explain Plan : In the twentieth article of the "How To" series from Listen Software, author David Nishimoto guides you through creating and using the explain plan to tune your SQL statements.
Listen Software Solutions' "How To" Series: Performing an Incomplete Recovery : In the nineteenth article of the "How To" series from Listen Software, author David Nishimoto provides a step-by-step guide to performing an incomplete recovery of your database.
Listen Software Solutions' "How To" Series: Troubleshooting Tips : In the eighteenth article of the "How To" series from Listen Software, author David Nishimoto offers troubleshooting tips for types of database failures, alert logs, and recovery views.
OLAP and Data Warehousing - Data in Jail : In his latest article, Alexzander Nepomnjashiy continues his analysis of OLAP and Data Warehousing with a discussion of "Data In Jail" crises.
Listen Software Solutions' "How To" Series: Backup and Recovery Strategy : In the seventeenth