This tutorial video and article is meant to help you setup your APEX installation so you can proceed through the Advanced Tutorials. It covers creation of a new workspace for the tutorials, as well as installation of the OEHR sample data needed for the tutorials themselves.
[youtube]http://www.youtube.com/watch?v=pzFgkhRyJM8[/youtube]
In a recent press release, Oracle promoted Oracle Identity Manager (OIM) focusing on the hot-pluggable nature of the product and it’s ability to handle, among other challenges, compliance and demands of SAP.
Oracle has already made a few strategic moves in the identity management space, and…
Following is simple example syntax for renaming a column to an Oracle table using “alter table” SQL:
1 2 | ALTER TABLE [my_table_name] RENAME COLUMN [current_column_name] TO [new_column_name]; |
A simple example would be:
1 2 | ALTER TABLE employee RENAME COLUMN f_name TO first_name; |
Like renaming an Oracle table, you should be aware of any dependencies in code, etc. that reference a table column by name.
These words are being used more and more. Of course, it was just a matter of time before the popularity and creativity of “Web 2.0” as a buzzword was reused, extended, and blatantly copied for other innovations in the technology space.
In early 2008, Oracle allowed you to enable WebCenter 11g and SOA 11g Tech Previews through the Oracle JDeveloper 11g Technology Preview. At this point, mid-2009, this is somewhat outdated. The actual WebCenter 11g release (not available for download by Oracle) has quite an enhanced environment, features, etc. I don’t know the timing details exactly, but I imagine that the tech preview was put together before the BEA acquisition decisions were finalized and certainly before they were fully integrated. WebCenter 11g should be a fantastic product taking the best of many Enterprise 2.0 products and services that Oracle has either … Read More
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]
