We all know that we should not use TWO DIGIT YEAR formats in database applications since more than a decade.
And we also know that we should never rely on implicit datatype conversion especially with dates.
I recently came across a very surprising effect with Oracle 11g R2 Enterprise Edition when I was testing with two digit years:
I convert a string with two digit year information into a date and then I convert this date into a string with four digit year format to see what the server made.
SQL> SELECT TO_CHAR(TO_DATE('07-11-58', 'dd-mm-yy'), 'dd-mm-yyyy (more...)
Oracle Technology Network now has the new APEX version 4 available for download.
The documentation and installation guides can be found here.
The Advanced Tutorials Guide contains up-to-date How-Tos including:
- Create a Tabular Form
- Create a Parameterized Report
- Create a Drill Down Report
- Control Form Layout
- Work with Check Boxes
- Implement a Web Service
- Create a Stacked Bar Chart
- Upload and Download Files in an Application
- Build an Access Control Page
- Review a Packaged Application
- Create a Master Detail PDF Report
- Design an Issue Tracking Application
- Build and Deploy an Issue Tracking Application
The new (more...)
I have just found the website of the Arab Orcale Usergroup
I was not aware that they are already online.
Today I have received a notification from OTN that APEX 4 for Early Adopters is in testing phase II now.
It is possible to request a workspace now.
The documentation is still not available yet, instead the online docs for APEX 3.2 are linked.
Let’s test it.
This week I deliver an 11g course in London downtown for a training partner of Oracle Education UK.
It is a very fun class and I have some very interesting people in the course.
is a highly skilled trainer and delivers the Microsoft SQL Server 2008 for the Experienced Oracle Database Administrator course for internal Microsoft staff and is responsible for the high end Microsoft customers. This course is definitely one I would like to attend!
He is about to publish his latest book on SQL SERVER for ORACLE DBAs shortly. I am pretty shure that this will be (more...)
The new version of APEX is available for testing by early adopters.
Use this link to request a workspace as hosted environment:
I will post about my first impressions soon.
Today I have encountered a surprising fact:
Scenario is 10.2.0.1 Express Edition on Win32.
I have a table called job_history in the HR scheme which has a composit primary key : and there is an index for the primary key:
SQL> select index_name from user_indexes where table_name=’JOB_HISTORY’;
Does the following info help to explain?
This is my constraint in the data dictionary:
SQL> select column_name , position
2 from user_cons_columns
3 where constraint_name=’JHIST_EMP_ID_ST_DATE_PK’;
Now I drop the primary key constraint
Yesterday in my course I ran into a strange BUG in Oracle Express (XE) on WIN32 and Linux 32 bit, in fact one of my students, Ralf Spiwoks, found it:
I have tried to run a top level anonymous block in which assigned a value to a BIND variable and got kicked out of my session with an ORA-03113.
SQL> VAR lname VARCHAR2(4)
ORA-03114: not connected to ORACLE
ERROR at line 1:
ORA-03113: end-of-file on communication channel
THIS IS A BUG which exists in 10gR2.
Only top level blocks are (more...)
A few days ago Larry Ellison has unvailed Oracle Exadata Storage, a family of software and hardware products including a hardware product which has been designed specially for large Data Warehouses in cooperation with HP, HP Oracle Database Machine.
The Database Machine runs Oracle Database 11g and Real Application Clusters, Oracle Enterprise Linux, and includes all the required Infiniband infrastructure and related hardware.
This is the first hardware product ever Oracle marketed under its own name.
It integrates Oracle Database Software with highly suffisticated hardware using Linux and ASM to build a very fast database maschine.
You can (more...)
A few days ago I arrived in Cairo again.
I will deliver a series of 11g Administration Courses for Oracle again.
One day after I arrived the there was a a big fire which burned down the house of the maglis ash-shura, consultative councel completely.
I was lucky enough to have my new camera with me to take some exciting shots.
It looked to me as if there were multiple fires burning at the same time.
Today I have reveived a parcel from IOUG containing five copies of the current SELECT magazine.
Plus a sweater with the SELECT Journal Contributer logo:
Additionally I was granted a one year free membership for Independent Oracle User Group (IOUG) for my article on DETECTING AND REPAIRING CORRUPT BLOCKS IN ORACLE DATABASE 11g WITH THE DATA RECOVERY ADVISER which is included in the curernt issue Volume 15 Number 3/2008.
Thanks IOUG and SELECT, this was a nice surprise.
Today my blog has reached to the 100’000 hits landmark.
I am very happy that this has become such a successfull forum here.
Thanks for reading
I’ll keep on posting in the future!
Oracle Technology Network announces that “Oracle Unbreakable Linux support customers at the Basic and Premier support levels now can download and deploy Oracle Clusterware at no additional license fee or support cost.”
Oracle Unbreakable Linux.
Before this the clusterware needed at least one Standard Edition License.
Now you can download the clusterware and use it as an extension of your Linux to make virtually any application highly available even without having an Oracle Database Server.
For more info on this and ready made scripts see my previouse post on how to protect a single instance database with the clusterware.
Today I have delivered two presentation @ the
yearly conference of the Swiss Oracle Usergroup.
The topics were :
- Real Application Testing with Oracle 11g
REPLAY DATABASE and
SQL PERFORMANCE ADVISOR
- SQL Plan Management and Automatic SQL Tuning in 11g
I have used my new courseware which
I have produced in the last few weeks for 11g New Features.
I offer to to deliver special courses for topics such as
- High Availability with Flashback and other 10g and 11g features
- Backup 10g & 11g
- Memory Management 10g & 11g
- Upgrade Issues 10g & 11g
After arriving in Cairo I immediately went to see if the my friend Muhammd Ali is still in living in his place as before 13 years. I had been living in his place for a while in the 90s.
Muhammad is an internationally recognized artist and has been painting since more than 25 years now. He had exhibitions in Paris, Hamburg, Berlin, Zurich and many other places.
He lives in a very poor area near the great basar Khan Al-Khalili.
In April he will have an exhibition in Talaat Harb Streeet in Downtown Cairo and I hope that he will (more...)
Today I have arrived in Cairo, the Mother of the Earth.
I will deliver a number of Oracle 11g trainings here.
This is the first time I am in Egypt after 12 years.
In the middel of the ninetees I had been living here for a couple of longer times.
I am very interested in the developments in Egyptian society since then.
Hopefully I will meet a lot of interesting people.
Yesterday I had organized a little dinner with Steven Feuerstein, my former collegue Christoph Burandt and his lovely wife Silvia as well as my dear friend Jenny.
Steven had delivered a two day seminar for Oracle University in Munich. Although he was very sick in the last days, he had caught a chest cold and swollowed an enormaouse amount of remedies in order to be able to deliver anyway, he preferred not to hang around in his room alone and come for our little dinner.
Thanks for coming Steven! Hope you’re feeling better already.
We talked about everything but PL/SQL (more...)
Last week the patchset 10.2.0.4 was released by Oracle.
This patchset not only contains bugfixes but also comes with a number of New Features.
One of the highlights is the possibilty to capture a workload in a 10.2.0.4 database and ship it to an 11g database for testing.
Only with this feature in place the 11g Real Application Testing Feature DATABASE REPLAY makes real sense.
Before this patchset it was only possible to capture a workload in an 11g database and run it for testing in an also 11g database.
For more detailed (more...)
I am just downloading the latest patchset for RDBMS Server 10.2.0.4 for Linux x86.
It is documented in Metalink NOTE: 316900.1
Components of This Patch Set
The following are the updated components of this patch set:
- Up to January 2008 CPU is included in this patch set.
- Platform-specific bug fixes as listed in the “Fixed Platform-Specific Bugs” section
- Generic bug fixes as listed in the List of Bugs fixed document
- Oracle Configuration Manager 10.2.7.1
I am very curiose about the possibility to capture a workload in 10g and run for Real Application (more...)