Oracle SQL Subselect Statements

AshokTechnical Tips1 Comment

It is becoming more common that I find myself surprised by self-proclaimed, seasoned SQL developers who do not even understand some of the basic power that is possible with an Oracle SQL SELECT statement. I am not talking about some of the more complex analytical functions; I have seen SQL developers lost when it comes to simple subselect statements (a “SELECT” inside a “SELECT”). Most people understand that they can nest a SELECT statement inside the WHERE clause of another SELECT statement, but many do not realize that it is possible inside the FROM clause (perhaps, my most common use) … Read More

Oracle Portal CMEF

AshokTechnical Tips1 Comment

A new and exciting piece of functionality that comes with the new versions of OracleAS Portal (starting with 10g – 10.1.4) is the Content Management Event Framework (CMEF). CMEF enables you to extend OracleAS Portal’s content management functionality by adding programmatic hooks to certain pre-defined portal events. The framework publishes these events to an Oracle database queue. This allows third party programs to subscribe to these events and to use the APIs to extend your portal. In this way, you can use page and item related events within a portal to trigger actions within one or more external applications. The … Read More

OracleAS (9iAS and 10gAS) Java/J2EE Development

AshokTechnical TipsLeave a Comment

I highly recommend the use of JDeveloper as the IDE for Oracle Application Server (Oracle 9iAS and Oracle10gAS — or however they are spelling/selling it these days). As I understand it, JDeveloper is now offered as a free IDE by Oracle for developers. With the built in integration for OracleAS for deploying Java-based web applications, portlets, ADF (Oracle’s implementation on top of the hot JSF technology), and much more, JDeveloper is quickly becoming the free, non-open source IDE of choice for the enterprise. ADF, specifically, requires a license before deployment to production, but regardless of this, JDeveloper has much to … Read More

SQL Server 2005 Licensing Costs and Pricing Example

AshokIndustry TrendsLeave a Comment

Processor Licensing Model. Under this model, a license is required for each physical or virtual processor accessed by an operating system environment running SQL Server. This license does not require any device or user client access licenses (CALs). Server plus Device CALs. Under this model, a server license is required for each operating system environment running an instance of SQL Server, as well as a CAL for each client device that accesses a system running SQL Server. Server plus User CALs. Under this model, a server license is required for each operating system environment running an instance of SQL Server, … Read More

Outlook 2003 Check Names Address Book Contacts

AshokTechnical Tips1 Comment

Do you have contacts in your contact folder(s) and wonder why your email doesn’t automatically check against them when sending a message? I noticed this issue when working with Outlook 2003, while using Exchange 2003 and RPC over HTTP. The resolution was actually easy, but it took enough clicking that I thought I would share the solution: To add your contacts folder as an “Outlook Address Book”: Right click your folder containing contacts (i.e. “Contacts”) Click “Properties” Click the “Outlook Address Book” tab Select the “Show this folder as an e-mail Address Book” checkbox Click the “OK” button To add … Read More

SQL Server 2005 Install Samples

AshokTechnical TipsLeave a Comment

If you have installed SQL Server 2005, it is likely you have installed the samples as well. In my case, I installed what I thought to be everything, realizing that the samples did not install. When I went in through the normal set up to install them, I was not able to. Thankfully, I found a workaround that prevented me from having to uninstall and reinstall… Go to Start –> Control Panel –> Add/Remove Programs Click “Change” for SQL Server 2005 Entering the setup from this approach, you will have the option to add/change components. Follow the wizard, and when … Read More

Outlook/Exchange 2003 Address Book

AshokTechnical TipsLeave a Comment

Have you wondered why the Outlook/Exchange 2003 address book does the (sometimes strange) things that it does? …when does it refresh/replicate? …does it work the same online versus offline? …etc., etc. Well, I found a great Microsoft KB Article to answer these questions that I just had to share: Enjoy!

Oracle Client Download (10g Windows Client)

AshokTechnical Tips6 Comments

Following is the link to the Oracle 10g Release 2 Client for Windows: As of this writing (in January 2006), this is the latest Windows Client available. Update: Oracle Client Download (11g Windows Client) – 32 bit and x64.