If you’re trying to export numeric values in OBIEE 11.1.1.7.0 to Excel 2007+, you may notice there are issues when you attempt to sum a column that has negative numbers. This problem will occur if you have a negative number’s font color set to red. Excel 2007 disregards those values when directly exported whereas if you export to Excel 2003 you will not have this issue but will lose some of the formatting from OBIEE. Proposed is an easy solution to implement that will allow users to have useful data and not be limited to where they can export to. The Problem: … Read More
Create Table – ORA-00907: missing right parenthesis — CHECK and DEFAULT Order Swapped
Most people, including myself, don’t memorize the syntax and associated options for every programming language. So, I was interested in determining what the issue was with the following create table command that one of my developers was having. He continued to receive the following error, regardless of what he did with parentheses: ORA-00907: missing right parenthesis CREATE TABLE AppItem (id INTEGER PRIMARY KEY NOT NULL, name VARCHAR(100), url VARCHAR(100), required CHAR(1) CHECK (required IN(’N’,’Y’)) DEFAULT ‘N’, img VARCHAR(100), title VARCHAR(100), description VARCHAR(100) );CREATE TABLE AppItem (id INTEGER PRIMARY KEY NOT NULL, name VARCHAR(100), url VARCHAR(100), required CHAR(1) CHECK (required IN(‘N’,’Y’)) … Read More
Download Archived and Older Java SE and EE JDKs and JREs
We just had to download Java SE JDK 1.6.0_11 (6 Update 11) and finding the files was not as intuitive as we had hoped. So, navigate to this link and you will see a screen like below where you can download many previous releases. Hope this helps get you there more quickly.
WebLogic 11g (10.3.4) Install on Windows – WLS 11gR3
I documented the steps I took to complete an install of WebLogic 11g PS3 (10.3.4) — sometimes also called 11gR3 — on my Windows 7 Ultimate 64-bit OS. There is only a 32-bit version of WebLogic available for Windows, but it runs fine on Windows 7 64-bit and, as I understand, the same way with other version of the Windows OS as well (Vista, XP, Servers, etc.). [box type=”shadow”]Note: The WebLogic Server version is 10.3.4, but this release coincides with other Oracle Fusion Middleware products released with a version numbering of 11.1.1.4.[/box] This walk-through covers: WebLogic 11g Install on Windows … Read More
WebCenter 11g Book – Hello World Examples, Screenshots, and Tutorials
Our WebCenter 11g book has been out a few weeks and I have heard some good reviews from people who have picked it up. This version 1 book will quickly get you started with WebCenter 11g, providing you step-by-step screenshots on creating your environment followed by a Hello World web service that is exposed to the web as a WebCenter portlet among other common business scenarios you may need to accomplish.
JDeveloper 11g Tutorial – Install Steps (11.1.1.3.0)
New versions of JDeveloper 11g have been released since the last step-by-step JDev install guide, so I thought I would post a quick refresher for anyone who wants that comfort of knowing they are seeing the screens they should expect to see as they march through the install. Enjoy; the product really is getting better and better everyday. Installing JDeveloper 11g (11.1.1.3.0) on Windows
Oracle DBMS_SCHEDULER vs DBMS_JOB (Create, Run, Monitor, Remove)
DBMS_SCHEDULER is a newer, more complex job scheduling engine released in 10g, intended to replace DBMS_JOB going forward. DBMS_JOB, the older job scheduler, as of now is still available for quick and easy DB based job scheduling.
Job scheduling comprises the core of the functionality of DBMS_SCHUDULER, however here are some additional benefits available to DBMS_SCHEDULER:
- Logging of job runs (job history)
- Simple but powerful scheduling syntax (similar to but more powerful than cron syntax)
- Running of jobs outside of the database on the operating system (see below)
- Resource management between different classes of jobs
- Use of job arguments including passing of objects into stored procedures
- Privilege-based security model for jobs
- Naming of jobs and comments in jobs
- Stored, reusable schedules
TOAD for Oracle 9 or TOAD 10 – 64-bit Windows – ORA-12154: could not resolve the connect identifier specified or ORA-6413: connection not open
I recently downloaded the new 10.x version of TOAD and could not connect to my databases. Still running TOAD 9.x, no problem. This really threw me off for a minute, so I thought I would share the resolution. You are likely running a 64-bit Windows OS and have installed TOAD into C:\Program Files (x86)\…. I simply copied over my entire Quest Software directory from C:\Program Files (x86)\… to C:\Program Files\…, and restarted the TOAD.exe. Everything is working great, without having to reinstall anything. PS: Not sure who to blame here. Vendors (like Oracle and TOAD) should know Microsoft is capable … Read More