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
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.
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 184.108.40.206.[/box] This walk-through covers: WebLogic 11g Install on Windows … Read More
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.
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 (220.127.116.11.0) on Windows
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
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
Following is a sortable table of the most common Linux commands we use on a day-to-day basis while implementing and maintaining Oracle Fusion Middleware environments.