BPEL: What It Is, What It Isn’t
Dave Shaffer explains the fundamental concepts behind Business Process Execution Language(BPEL), why it’s an improvement over EAI approaches, and its role in SOA–and why J2EE developers should care. Listen (MP3)
Filed in Oracle with Comments Off | Tags: bpelHow to personalize forms in Oracle Applications
With the Oracle E-Business Suite release 11.5.10, the Oracle has introduced a mechanism which revolutionizes the way the forms can be customized to fulfill the customer needs. For many years, Oracle Applications has provided a custom library using which the look and behavior of the standard forms can be altered, but the custom library modifications require extensive work on SQL and PL/SQL. In the release 11.5.10, Oracle has provided a simple and easy feature to implement the customer specific requirements without modifying the underlying forms code or CUSTOM library. Although CUSTOM library still can be used for forms customization to implement the complex business logic, the personalization feature provided in the latest release is easy, fast and requires minimum development effort. Ramakrishna Goud has put together a nice white paper about how to personalize the forms in Oracle Applications release 11.5.10.
Filed in Oracle with Comments Off | Tags: E-Business-SuiteDISTINCT vs GROUP BY
Have you ever wondered about the difference between the use of DISTINCT and GROUP BY in your queries? I certainly have. Wonder no more. They are, for all intents and purposes, the same (as demonstrated by Tom).
Even though it requires more typing, but I prefer using GROUP BY (instead of DISTINCT when possible) as it is more explicit about what’s being unique or not in your result set.
Filed in Oracle with Comments Off | Tags: distinct, group, sqlMicrosoft Update version 6
Microsoft Update v6 is now available. It combines the old Windows Update and Office Update, so no more updating in two different places! Plus it has a cleaner, more polished look. It doesn’t run on Firefox though.
Source
Model-Glue FAQ
The following are some Model-Glue notes (in the form of an FAQ) I wrote for my own reference. Please feel free to add or correct anything by commenting below. (more…)
Filed in ColdFusion with 20 Comments | Tags: FAQ, model-glueFramework Comparison
OK, you are torn between Fusebox, Mach-II and Model-Glue and you cannot decide which one to adopt and use as your framework for developing ColdFusion applications. To help you reach a decision, I suggest you take a look at Sean Corfield’s feature comparison matrix where he writes about the pros and cons of each of the three frameworks. You can also download sample applications in all three frameworks from here.
Filed in ColdFusion with Comments Off | Tags: framework, fusebox, machii, modelglueTo pound or not to pound in ColdFusion
Most Cold Fusion developers overuse the # character. Here are a couple of rules that will help you decide when to “pound” your variables: (more…)
I don’t understand that internet jive
I always notice that many people end their e-mails or newsgroup postings with three or four letter words that I do not understand. So, I start questioning myself, is it because English is not my native language? Is it because my English vocabulary is poor? Is it because the writer made a spelling mistake? Well, It turns out that these are acronyms frequently used in e-mails, and especially in internet chats and Newsgroups. Here are some to get you started: (more…)
Filed in Interesting Stuff, Tips with Comments Off | Tags: internet“Between” CASE and DECODE
Here is a select statement that demonstrates the following:
- Use of CASE to do a “between” logic.
- Use of DECODE with SIGN to do a “between” logic.
How easy and clear to use CASE as compared to using DECODE.
Oracle’s V$ views
The V$, V_$, GV$ and GV_$ views are known as the ‘dynamic performance tables’ (DPT). They are called this because they have no physical existence in the database and are constantly changing (hence “dynamicâ€) views of the database system. Each time one of these views is accessed, it provides a snapshot for that moment in time of the database status.
The V_$ tables are actually views against the GV_$ tables. The only difference being that the GV (Global View) views include the instance value for systems using the parallel server option.
Most general database users usually don’t need to access these DPTs. Some DPTs, like the V_$DATABASE view, do contain useful information, such as the Oracle version and database name, for general users.
Note: Unlike the DBA views, the DPT views do not store a general description of their purpose or column definitions in the Data Dictionary.
Filed in Oracle with Comments Off | Tags: v$
