(Jonathan Gennick and Isobel Eckhardt) With Oracle9i marking the terminal release of the Oracle Names software, it’s time for all Names users to think about migrating to another naming method. The most logical migration path, if you want to maintain centralized name resolution, is to migrate to dire

(Robert Westervelt) Oracle’s new price incentives are a good sign that the company is beginning to acknowledge the demand for lower database costs, but it has much further to go if it wants to lure SQL Server users, according to a recent report by Boston-based AMR Research. (R)

(Krishna Sarabu) To convert date and time from the local time zone to any other time zone or vice versa, it is necessary to find out the local time zone of the database first. The NEW_TIME function in Oracle 8i converts the date and time value from one time zone to another time zone, but it won’t pr

(Jim Czuprynski) JOIN … USING. When you need to join tables that share more than one column naturally, the JOIN … USING syntax needs to be used. A NATURAL join between the Employees and Departments tables, for example, could yield unexpected results because the tables share both the DEPARTMENT_I

(Matt Rohrer) With Apple’s move to a UNIX base with Mac OS X, many developers have been excited about the prospects of a development platform that combines legendary ease of use with a rock-solid foundation. Considering that Oracle has a developer release of the Oracle9i Database Release 2 for OS X

(James Koopmann) In my early days of being a database administrator, I was thrown straight into the fire of database performance issues. Now, I did not have any experience, except for the education of database systems from my local college, and was at the mercies of other professionals around me. Th

(Amar Kumar Padhi) We have various levels of security (inside and outside of Oracle database) that can be implemented according to one’s requirements. Mentioned here is a way of implementing security against structural changes or Data Definition Language (DDL) changes. This security is put within th

(Harshad Oak) Developing Java 2 Enterprise Edition (J2EE) applications using Java Server Pages (JSPs)/Servlets and Enterprise JavaBeans (EJBs) is quite popular. However there is no denying that J2EE can get quite complex at times. You need to understand many things to be able to deploy a quality J2E

(Steve Callan) Previous articles in this series covered installing a database product (Oracle9i) and a development tool (Forms & Reports 6i). For the most part, those installations – just using what Oracle provides in its hundreds of pages long installation guide – are fairly straightforward. With a

(Ryan Naraine) British security research firm NGSSoftware has discovered multiple security vulnerabilities in Oracle’s database server software. The firm is warning that the most serious flaw could lead to system takeover. The vulnerabilities affect the Oracle9i Database (both enterprise and stan