This tutorial is a supplment to the install video linked to below. It takes you through the process of installing and verifying APEX version 3.2 installed to an Oracle XE database on a Windows XP Professional computer.
[youtube]http://www.youtube.com/watch?v=637Kf2nyl-U[/youtube]
The Oracle TO_DATE SQL function is used to convert a TEXT or NTEXT representation of a date into an Oracle DATETIME value.
Below shows the TO_DATE function along with the arguments it takes:
1 | to_date(string) |
1 | to_date(string, date_format) |
1 | to_date(string, date_format, options) |
The Oracle TO_DATE function returns a DATETIME representation of the string input using the date_format input.
The Oracle INSTR SQL function is popular and performs materially the same operation as instr functions in many other programming languages.
Below shows the INSTR function along with the arguments it takes:
1 | instr(string, SUBSTRING) |
1 | instr(string, SUBSTRING, start_position) |
1 | instr(string, SUBSTRING, start_position, occurrence) |
The Oracle INSTR function returns the position (an integer) within string of the first character in substring that was found while using the corresponding start_position and occurrence.
The following are links to the download page for Oracle Database 10g Release 2 (10.2.0.1) Express Edition (XE) for Microsoft Windows:
XE Windows English Language Download
XE Windows Universal Language Download
XE Windows Client Download
This tutorial article is meant to provide a visual guide to the process of installing Oracle express edition (XE) onto a Windows XP Professional computer. The video below contains the actual tutorial, while this document provides additional information and clickable links to the required software.
[youtube]http://www.youtube.com/watch?v=VojTYmTNaj4[/youtube]
Oracle Corporation has recently published a white paper written by M&S Consulting, where we take the opportunity to outline an integration approach to Salesforce.com using Oracle BPEL.
A Technical Case Study – Creating an Oracle BPEL adapter to integrate with Salesforce.com – Feb 2009
Below is the introduction to the article, which goes on to detail (with step-by-step screenshots) how to achieve integration with Salesforce.com…
Among their many characteristics, all too often SOA projects have been labeled in their worst moments as:
Guess what. None of these are characteristics of SOA, but instead…
I have just had a heck of a time with installing BPA (Architect) Evaluation on a Windows Server 2003 machine. There were no inherent issues with the product itself, but some gotchas that I thought I might point out. For the following, I assumed you are installing on a single machine for testing/evaluation purposes like I was.
For one, if you were familiar with BPA 10.1.3.3, there is no longer an auto-installable olite database option. You must use Oracle XE Universal (or better) and you should have it installed locally prior to installing BPA. Note: You should use XE Universal specifically so you get the AL32UTF8 character set that is expected by the BPA install.
After I got the character set squared away, I continued to receive a database connection error
