M&S Consulting - Solutions Consultants Training

SQL – Nested Selects

ashok.aggarwal — Thu, 10 May 2012 20:09:29 +0000

I like to ask this series of questions in interviews when people say that they “know” Oracle SQL. Granted, none of this exemplifies the hardest parts of SQL, but it’s nice to see how hard someone is thinking when they answer.

Question 1: Can you nest a select inside the from clause?

Answer: Of course! This is essentially like querying from a view.

Simple Example:

SELECT t1.columnA FROM (SELECT columnA FROM tableX) t1

Question 2: Can you nest a select inside the where clause?

Answer: Yes, you can perform match data with an “in” or equals (“=”) against a select statement.

Simple Example:

SELECT t1.columnA FROM tableX WHERE columnA IN (SELECT columnB FROM tableY)

Question 3: Can you nest a select inside the select clause?

Answer: Yes, though I don’t find myself using it often, you can certainly do this.

Simple Example:

SELECT t1.columnA, (SELECT MAX(columnB) FROM tableY) AS columnB FROM tableX

Have an Oracle DB? Try it for yourself.

SELECT
(SELECT 1 FROM dual) one
FROM dual

Oracle SQL Subselect Statements It is becoming more common that I find myself surprised...
Invalid Nested Schema Loading Error with Oracle BPEL, AIA/PIP I faced this issue in the context of building an...
Thoughts on Learning Oracle SQL: 2 – Knowledge and Normalization I return again to my APEX SQL command box, break...
ASP.NET HyperLink in GridView using HyperLinkField, SqlDataSource, BoundField, TemplateField, and HyperLink I am amazed how difficult it was to find simple...

Google Analytics Integration with Oracle ADF 11g

ashok.aggarwal — Tue, 08 May 2012 23:02:58 +0000

There are occasions when we desire to view the usage statistics of our webpage. Some of these metrics might include:

active users currently viewing our web site/application
user’s web browser
user’s operating system
pages visited per session
average time spent on web site/application per session

If you have designed your enterprise application or enterprise portal using Oracle ADF 11g, there is a simple way to track these usage statistics. To find out more, feel free to download our FREE Technical Tip document below.

Free Download
Please complete the following for access to the free download.

[contact-form-7]

Software and versions used for the screenshots in this Technical Tip document are:

Windows 7 Ultimate 64-bit
JDeveloper 11.1.1.6

Google Docs Redirect Loop You may have noticed a redirect loop when trying to...
Google Custom Search Engine (CSE) The site search game is changing with Google CSE....
Google Apps Our Services and Solutions Google Apps Consulting and Mentoring Let...
Oracle IdM – SAML SSO with Google Apps We recently integrated Oracle IdM with the SAML SSO Service...
Google Apps Reporting API – Not quite this easy with Exchange I have been somewhat enamored by Google Apps and its...

Check Point VPN – SSL Network Extender – Windows 7 or Windows 2008 64-bit

ashok.aggarwal — Fri, 10 Feb 2012 19:33:15 +0000

If you come across an issue where your Check Point VPN SSL Network Extender (SNEX) fails to initiatize (as seen below), try downloading a new version of the Check Point client made to work with Windows 7 and Windows 2008 64-bit.

The client you want to download is SNX R71 HFA 1 with support for Windows 7 (msi) and you can click here for the readme.

Oracle Client Download (11g Windows Client) – 32 bit and x64 Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows...
Oracle Client Download (10g Windows Client) Following is the link to the Oracle 10g Release 2...
BPA 10.1.3.4 Windows Install with XE I have just had a heck of a time with...
Google Custom Search Engine (CSE) The site search game is changing with Google CSE....
Oracle APEX Tutorial 5 – Check Boxes – Part 2 – Video Training Within APEX, there are a multitude of things you...

Oracle Identity Management vs. Oracle Identity and Access Management

ashok.aggarwal — Thu, 12 Jan 2012 23:27:41 +0000

Many of our customers get hung up on the terminology for Oracle’s Identity and Access Management offerings, and perhaps rightfully so. There are more names and acronyms given to these products as there are people implementing them.

Following is a quick breakdown of the latest version of both 1) Oracle Identity Management and 2) Oracle Identity and Access Management from the technical perspective of downloading and installing the products (as opposed to product packaging/licensing). When you speak with an identity management implementation partner like M&S Consulting, you will want to use the below terminology to ensure everyone is on the same page.

Oracle Identity Management 11g R1 (11.1.1.5.0) – Released May 6, 2011

Oracle Internet Directory 11g R1 (11.1.1.5.0)
Oracle Directory Integration Platform 11g R1 (11.1.1.5.0)
Oracle Virtual Directory 11g R1 (11.1.1.5.0)
Oracle Directory Services Manager 11g R1 (11.1.1.5.0)
Oracle Identity Federation 11g R1 (11.1.1.5.0)

Oracle Identity and Access Management (11.1.1.5.0) – Released May 23, 2011

Oracle Identity Manager 11g R1 (11.1.1.5.0)
Oracle Identity Manager Connectors 11g
Oracle Access Manager Server 11g R1 (11.1.1.5.0)
Oracle Access Manager WebGate 11g R1 (11.1.1.5.0)
Oracle Adaptive Access Manager 11 gR1 (11.1.1.5.0)
Oracle Security Token Service 11g R1 (11.1.1.5.0)
Oracle Entitlements Server 11g R1 (11.1.1.5.0)
Oracle Entitlements Server Security Module11g R1 (11.1.1.5.0)
Oracle Identity Navigator 11g R1(11.1.1.5.0)

Identity Management Oracle’s Identity Management offerings are breaking new ground. Like other...
Identity Management: From Oracle 10g to 11g – IdM, SSO, OAM I have been running Oracle Identity Management 10g with heavy...
Identity Management Authentication Enterprise authentication these days typically involves some LDAP integration,...
Oracle Identity Manager (OIM) – formerly Xellerate Identity Provisioning – Is Enhanced In a recent press release, Oracle promoted Oracle Identity Manager...
Oracle Middleware – Identity Management Consulting M&S Consulting is a technology and strategic management consulting company....

Edit Environment Variables in Windows – Quick Screenshot Steps

ashok.aggarwal — Thu, 27 Oct 2011 13:23:25 +0000

I have been asked this question so many times that I thought I might as well post a proper screenshot with all the steps (starting with the “Start” button) for how to get to your system environment variables in Windows. I used Windows 7, but intentionally followed similar steps to those I have followed in other Windows environments like XP and Vista:

A quicker way to do this in Windows 7 specifically is to simply begin typing “environment variables” in the Start > Search bar as shown below:

Oracle SOA Environment Performance Tuning Options – Quick Notes Tuning OAS and BPEL Console....
SSIS Tip – Read from Variables to Rows in Data Flow using Script Task Reading from variables to augment rows with data from variables...
JDeveloper 11g Tutorial – Install Steps (11.1.1.3.0) New versions of JDeveloper 11g have been released since the...
ADF Jdeveloper 11g and QTJava.zip (QuickTime) – Integrated WebLogic Server If you are having trouble starting your integrated WebLogic Server...
Complete Fusion Middleware 11g environment setup We have recently been working on and completed an entire...

Oracle 12c!?

ashok.aggarwal — Sat, 01 Oct 2011 00:11:36 +0000

Many people do not know that Oracle versions represent something more than just an incremented number. People have been saying 8i, 9i, 10g, and 11g for years, conditioning their brains to forget even asking what the meaning or thought is behind the *letter* at the end of the version number, just as many people commonly use other technology acronyms so commonly while forgetting their expanded versions, like TCP, AJAX, SOAP, and so on.

So, as Oracle may set to announce new versions and releases of big products in the coming week, we turn our sights to the version 12 release? I have been saying for months that my best guess for this will be 12c, where the “c” stands for Cloud (or maybe Collaboration, though I feel more strongly about the intention being “Cloud”). By the way, the “i” stood for Internet while the “g” stood for Grid.

We’ll keep you posted as we get the official word, but remember where you heard the 12c (for Cloud) prediction.

Semantics, Reality, Marketing: I’m “Cloud Computing” Too If there were a buzz word that could compete with...
Oracle on Amazon EC2 Cloud – APEX, Apps, Middleware, and DB Virtualized Hosting The economy is evolving, technology is getting better, and overall,...
Should I always use an Oracle sequence? Oracle die-hard purists will generally swear up and down about...

Oracle Books – Packt Publishing

ashok.aggarwal — Tue, 06 Sep 2011 13:25:23 +0000

Packt Publishing, the company that published the WebCenter Book that M&S Consulting’s E2.0 team co-authored, has just launched an Oracle focused version of its new online library platform: PacktLib.

Aimed at all Oracle professionals, the Oracle book library is a low-cost, cloud-based resource that you can access anywhere whether in the office, on the move, or at a client’s site.

Access all Packt’s Oracle books (50+) for less than $120 per year! That’s just couple of bucks per book.
Get hold of high value information on the Oracle Database, Oracle Middleware, Oracle Applications, and more.
Read content on your PC, Laptop, iPad, or mobile device.
Copy, Paste, Bookmark, and Print information – as needed.
Get access to all the new Oracle books as they are published! There will be more than 20 in the next 12 months alone.

Click to see all Packt’s Oracle Books. Also, enjoy a special M&S Consulting discount (10% off) by entering the code: oraclib10 when you sign up to the Packt Oracle Book Library.

WebCenter 11g Book – Hello World Examples, Screenshots, and Tutorials Our WebCenter 11g book has been out a few weeks...
Oracle Books for Developers Following are some of the best Oracle books for developers....
Oracle BPEL Sensors for Real Time Event Publishing from Business Processes – A Design Perspective This article is a look at Oracle’s BPEL Sensor approach...
WebCenter 11g Book A few of us have got some writer's cramp (is...
Outlook 2003 Check Names Address Book Contacts Do you have contacts in your contact folder(s) and wonder...

Oracle OpenWorld 2011 — Come See Us!

ashok.aggarwal — Fri, 29 Jul 2011 16:03:51 +0000

We’ll head out to yet another Oracle OpenWorld even this year. Drop us a line and come see us October 2-6 in San Francisco!

If you haven’t already, click the below image to register!

As usual, it’s going to be fun…and if you haven’t already heard, this year’s Appreciation Event features Sting as well as Tom Petty and the Heartbreakers!

Oracle Portal 10.1.4 Intranet and OpenWorld M&S Consulting has implemented a world-class intranet environment for a...
Oracle OpenWorld OOW 2010 – Middleware As has become tradition, I will be attending Oracle OpenWorld...