Posted
on May 10, 2012 in Technical Tips | 0 comments
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
Posted
on May 8, 2012 in Industry Trends, Offerings, Technical Tips | 0 comments
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.
Software and versions used for the screenshots in this Technical Tip document are:
- Windows 7 Ultimate 64-bit
- JDeveloper 11.1.1.6
Posted
on Feb 10, 2012 in Technical Tips | 0 comments
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.
Posted
on Jan 12, 2012 in Industry Trends, News and Updates, Offerings, Technical Tips | 0 comments
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)
Posted
on Oct 27, 2011 in Technical Tips | 0 comments
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:
Posted
on Sep 30, 2011 in Industry Trends | 0 comments
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.
Posted
on Sep 6, 2011 in Industry Trends, Offerings | 0 comments
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.
Posted
on Jul 29, 2011 in Industry Trends, News and Updates, Offerings | 0 comments
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!
Recent Comments