Category Archives: Oracle

Commercial licensing is a double-edged sword

Larry Dignan reports on a coming revolution in software support and maintenance contracts, prompted by Dennis Howlett’s excellent analysis of why the reliance of enterprise software vendors on maintenance revenue is unsustainable.
Noting the negative response to recent price rises from Oracle and SAP, Dennis maintains that increasing maintenance costs is unsustainable as it reduces […]

Essential Geek-Speak Session Rescheduled

To avoid overlapping with Larry’s keynote on Wednesday afternoon, as promised, I have rescheduled my Unconference session, “Are you insulting me? Essential geek-speak, FTW!” to Tuesday morning at 10 AM in Moscone West, 3rd floor, Overlook C.

If you’re interested, check out the slides on SlideShare.
If you make it, stop by and say hello.

Savio Rodrigues: “Are vendors afraid of open source?”

Savio posted a blog entry a little while ago that I missed until now (yes, I’m way behind on my RSS feeds). Anyway, after reading my blog post here on Microsoft’s annual report statements regarding risk from open source, Savio went and looked up what other software vendors state in their annual reports regarding potential […]

IT Jobs In Saudi

We are the IT & Communication Company with Outsourcingdivision, Currently we need many IT Professionals from Operator level to theConsultants and project Managers from INDIA for our reputed client NATIONAL GUARD HOSPITAL Saudi Arabia,offering very attractive Salary with other benefits like yearly bonuses &Increments with Residence/Working Visa and family status. We have Plan to visit […]

Cycling

How to detect cycling records in 9i, remember CONNECT BY NOCYCLE does not exist in 9i

SQL> create table lsc_t as
2 select 1 parent, 2 child from dual
3 union all select 2,3 from dual
4 union all select 4,5 from dual
5 union all select 5,6 […]

where is my database link listed?

$ sqlplus scott/tiger@DEVL
SQL> select * from all_db_links;
no rows selected
SQL> select * from dual@PROD;
D
-
X

Hey, why does this work???
Ok, after some research I found out that this seems to be an implicit loopback database link. The fact that the DEVL database has the global name set to PROD is just to annoy more

SQL> select * from […]

read uncommitted

the default isolation level is READ COMMITTED. It means, a session read the committed data.
Session 1:

SQL> set transaction isolation level read committed;

Transaction set.

Session 2:

SQL> update emp set sal=4000 where ename=’SCOTT’;

1 row updated.

Session 1:

SQL> select sal from emp where ename=’SCOTT’;

SAL
———-
3000

Session 2:

SQL> commit;
Commit […]

Oracle APEX 3.1 installation on Oracle Database 10g XE

I’ve been asked many times if there is possible to install Oracle Application Express on Express Edition of 10g database, both of them being free products. The answer is YES, and the procedure is quite simple, as very well indicated on Oracle website
The steps would be:

Download the latest version from APEX website
Unzip the archive in […]

JDeveloper free as in beer

Infoworld is reporting that JDeveloper will be gratis: Oracle to offer JDeveloper tool for free.
Out of the box, JDeveloper has a lot more functionality than Eclipse in many areas. Visual JSP editing, visual support for JSF, support for some of the UML diagrams, wizard support for it’s ORM frameworks ADF Business components and Toplink. […]

Wilfred’s summary of CB’s migration from Designer to JDeveloper on OTN!

Wilfred’s story about Jules de Ruijter’s presentation on their migration from Designer to Developer made it to OTN’s frontpage! I have to agree with Wilfred, the presenation, Oracle Designer versus Oracle JDeveloper, was really interesting, Jules is a good speaker who likes to provoke his audience.