Oracle SUBSTR and INSTR SQL functions are typically used together in practice for parsing a string. Following are some examples uses that will exemplify how to take advantage of their combined power.
1 2 3 4 5 6 7 8 | SELECT substr ( '[email protected]', instr('[email protected]','@',1)+1 ) FROM dual --returns: mandsconsulting.com |
…
M&S was engaged by ABC, a publically traded company, for a multi-national Oracle initiative. Upon joining, M&S recognized the need to easily share, collaborate, and centrally publish information.
The value of Web/Enterprise 2.0 social software was no longer a secret reserved only for the most cutting-edge — or as some might have labeled them, “bleeding-edge” — organizations.
Within two weeks of deciding to implement the M&S solution, the application was available to the customer, hosted by M&S Consulting.
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…
