db wOrLd

Skill sets needed by Developers and DBAs

noreply@blogger.com (Unknown) — Thu, 17 Mar 2011 15:06:00 +0000

DBAs	Developers
Operations	Algorithms
Resource management	Languages
Troubleshooting	Frameworks
Physical data design	Design
System interfaces	User interfaces
Data modeling	Data modeling
SQL optimizer	Debugging, profiling, tracing
Oracle product features	Business-domain processes

Basic Data Mining Tutorial

noreply@blogger.com (Unknown) — Wed, 17 Mar 2010 12:51:00 +0000

Memo to Myself

noreply@blogger.com (Unknown) — Tue, 09 Mar 2010 11:26:00 +0000

Test (Sample) Data Generators

25+ Alternative & Open Source Database Engines

Hacking and Hardening Oracle XE (link)

noreply@blogger.com (Unknown) — Mon, 01 Feb 2010 12:17:00 +0000

How to Install Oracle 11g Release 2 on OEL 5.4 on VirtualBox: Installing Grid Infrastructure

noreply@blogger.com (Unknown) — Sat, 07 Nov 2009 10:27:00 +0000

How can I format xxxxxxxxx like xxx-xx-xxxx in Oracle?

noreply@blogger.com (Unknown) — Mon, 27 Jul 2009 08:16:00 +0000

Creating Custom Authentication in APEX

noreply@blogger.com (Unknown) — Fri, 17 Apr 2009 09:58:00 +0000

Installing Oracle 11g inside an Xubuntu Linux VMWare Image

noreply@blogger.com (Unknown) — Sun, 12 Apr 2009 06:15:00 +0000

Apex Database Objects

noreply@blogger.com (Unknown) — Tue, 31 Mar 2009 19:19:00 +0000

1. Workspace files: apex_workspace_files
Includes columns for:
file_name - name of file uploaded
file_id - unique identifier
application_id - application number
workspace_name - should always be your workspace
mime_type - e.g. text/plain, image/gif, application/excel
file_size - file size in bytes
created_by - e.g. APEX_PUBLIC_USER
created_on - sysdate
document - blob that contains contents of uploaded file

2. Apex access log: apex_workspace_access_log
Creates log record every time you log into application via Apex standard login page (I think). Must be workspace and Apex-owner schema-specific?
Columns include:
ip_address
seconds_ago - how log ago the access happened - dynamic?
access_date
authentication_result - e.g. AUTH_SUCCESS
custom_status_text - ?

3. Apex summary log: apex_workspace_log_summary
Includes columns:
application_id
page_views
distinct_pages
total_elapsed_time
first_view - date/time
last_view - date/time
period_in_days

4. Application activity log: apex_workspace_activity_log
Logs internal (Apex) as well as pages accessed in your application.
Columns include:
application_id
application_name
application_schema_owner - e.g. STEW_STRYKER
page_id
page_name - e.g. Load Import File - new
ip_address
error_message - e.g. ORA-00904: “ADDRESS_LINE_2_BILLING”: invalid identifier
error_on_component_type - report
error_on_component_name - Review Participants

5. Apex view definitions: apex_dictionary
Lists all views and their columns. The view columns are documented in this table in the Comments column.
To get a list of Apex Views
SELECT DISTINCT apex_view_name FROM apex_dictionary;
6. Installation-specific?
V3 Apex schema: flows_030000

Creating Oracle Extended RAC on Oracle VM

noreply@blogger.com (Unknown) — Tue, 30 Dec 2008 10:15:00 +0000

Click here for details on Oracle Extended RAC on Oracle VM.

Oracle SQL Developer Data Modeling

noreply@blogger.com (Unknown) — Thu, 11 Dec 2008 13:07:00 +0000

Oracle SQL Developer Data Modeling is the latest product offering to join the Oracle Database Tools. SQL Developer Data Modeling offers a full spectrum of data and database modeling tools and utilities, including Entity Relationship modeling, Relational (Database Design), Data Type and Multidimensional modeling, full forward and reverse engineering and code generation. It includes importing from and exporting to a variety of sources and targets, provides a variety of formatting options and validates the models through a predefined set of Design Rules.

SQL Developer Data Modeling can connect to any Oracle Database version 9.2.0.1 and later, and is platform independent. Initially available as a standalone product, with future releases available as an extension to Oracle SQL Developer. The second Early Adopter release is stand alone and file-based only.

Download

Apex Examples

noreply@blogger.com (Unknown) — Wed, 05 Nov 2008 09:35:00 +0000

Are you looking for Apex examples ?

Packaged Apps
Carl Backstrom's
Denes Kubicek's
Dimitri Gielis's
Mark Lancaster's
Vikas's

Oracle Locator Express

noreply@blogger.com (Unknown) — Fri, 26 Sep 2008 08:44:00 +0000

Oracle Locator Express is a small free utility with which you can switch the default Oracle Home on-the-fly, just like the Oracle Home Selector does.

http://www.dbmotive.com/ole/

You can get ...

noreply@blogger.com (Unknown) — Wed, 04 Jun 2008 07:37:00 +0000

You can get OpenSolaris Live CD and Oracle Unbreakable Linux DVD shipped to you free of cost.
Order OpenSolaris
Order Oracle Unbreakable Linux

Developing own program using Oracle XE and APEX

noreply@blogger.com (Unknown) — Thu, 24 Apr 2008 18:07:00 +0000

Steve Hall method:
1) Fresh install of Oracle XE to default location on new machine,
2) Run backup.bat script on my development machine (ApEx 3.1, my app etc),
3) Copied these files / folders from the development machine to the new installation :
flash_recovery_area\XE\AUTOBACKUP\*
flash_recovery_area\XE\BACKUPSET\*
product\10.2.0\server\database\SPFILE2INIT.ORA
4) Run the restore.bat script on the target machine.
Voila! ApEx 3.1 and my app on the target machine. It needs more testing and automating but it certainly seems to work 'in the lab'.

Suggestion: You can try the COMPRESS option in backup.

Andre method:
Basically the steps are as follows.

1. Create your schema.
2. Create a workspace using that schema.
3. Create your underlying db objects.
4. Import the application into the workspace.

This is pretty basic and there may be some other steps required to complete the job, such as importing images and workspace users but overall, once you do it once, its not that hard.

Connection to Oracle without using tnsnames

noreply@blogger.com (Unknown) — Thu, 03 Apr 2008 06:18:00 +0000

You can use the following syntax to connect

sqlplus user/password@//host:[port]/service_name
sqlplus user/password@//host:[port]/service_name as sysdba

This syntax (known as EZCONNECT) is only available with sqlplus >= v10.2

Oracle Application Express (APEX) related open source projects

noreply@blogger.com (Unknown) — Fri, 04 Jan 2008 10:08:00 +0000

ApexGen - The Oracle APEX Generator
A utility to generate Oracle Application Express pages based on a PL/SQL API.

The Oracle APEX Builder Plugin
The Plugin is a productivity and usability enhancement tool for the development evironment of Oracle Application Express (APEX).It integrates with Firefox and Internet Explorer 6 & 7 to put a wealth of new features to your favourite development tool.

ApexLib - The Oracle APEX Framework Project
The aim of this project is to provide "the" development framework for the Oracle web development environment APEX (Oracle Application Express). APEX is a very productive declarative web-development environment, but which has (as any tool) some short comings. Especially in the area of "out of the box AJAX features" and "out of the box client-side validation".

Oracle VM

noreply@blogger.com (Unknown) — Mon, 17 Dec 2007 13:18:00 +0000

Tarry Singh at http://www.databasejournal.com/features/oracle/article.php/3712246
writes great article how to install Oracle VM.
It gives a really detailed step by step run through the oracle vm installation with loads of pictures showing the screens you see at each stage of the install.

Don't like to read:
8 minutes and you know all about installing Oracle VM
Check out you tube http://www.youtube.com/watch?v=R_W5_5wJy80

Great series about "Mining Information from the Listener Log" by Arup Nanda

noreply@blogger.com (Unknown) — Mon, 17 Dec 2007 13:12:00 +0000

In this article, you will learn how to build an infrastructure to process the listener log and to use it to unearth information on your database operations. The information can be used in different scenarios, as you will see later.

On-line tutorials Oracle 10g, Java, XML and Web Services

noreply@blogger.com (Unknown) — Mon, 10 Dec 2007 11:46:00 +0000

Advanced technical tutorials to help you learn Oracle 10g, Java, XML and Web Services.
These online Tutorials are self-paced, self-study lessons that contain numerous working examples and hands-on workshops.

Conditional Column Formatting in APEX

noreply@blogger.com (Unknown) — Sat, 01 Dec 2007 22:09:00 +0000

An exmaple:

FREE book: IBM WebSphere Information Analyzer & Data Quality Assessment

noreply@blogger.com (Unknown) — Thu, 22 Nov 2007 12:22:00 +0000

This redbook describes a usage scenario that covers all dimensions of profiling, rule building, deployment, and quality monitoring through a data integration lifecycle.

FREE book: Getting Started with DB2 Express-C V9.1

noreply@blogger.com (Unknown) — Thu, 22 Nov 2007 10:30:00 +0000

Oracle Database Security Checklist - Nov 2007

noreply@blogger.com (Unknown) — Mon, 19 Nov 2007 10:57:00 +0000

Columns to Rows - UNPIVOT (11g)

noreply@blogger.com (Unknown) — Mon, 19 Nov 2007 10:35:00 +0000