(Yuli Vasiliev) As is well known, caching the results of database queries can dramatically improve script execution time and minimize the load on the database server. This technique can be especially effective if the data you are dealing with is quite static. This is because many data requests to a

(James F. Koopmann) FIPS stands for Federal Information Processing Standards which includes which include a set of standards and guidelines for governments. Included are requirements for SQL to meet a set of standards. Wow! What a mouthfull. Really if you care about this you should do a search on th

As its largest hands-on training facility, Oracle’s Enterprise Technology Center (ETC) is used by Oracle and its customers to develop, demonstrate, and test Oracle solutions in a full-scale enterprise environment. But prior to a February 2005 storage upgrade, capacity limitations prevented the Oracl

(Mark Brunelli) Customizing Oracle E-Business Suite applications can be very dangerous for developers who make common rookie errors, experts say. (R)

(Tarry Singh) In our last article, we spoke about certain CRS_ commands and syntax. We should also try to see what happens when our cluster suddenly starts to act weird and we really do not know where to get started and how to proceed. But first let’s continue our introduction to the remaining crs_

(Antone Gonsalves) Oracle Corp. unveiled a suite of components that enable large corporations to provide a single sign-on and authentication mechanism for accessing mainframe, client/server and Web applications.

(Gregory Williams) To change your Oracle 9i release 2 database from a dedicated server to a shared server, you must change the number of dispatchers to at least one. (R)

(Steve Callan) No, this article is not about the math behind Oracle’s pricing scheme. The question posed in the title has to do with the calculator math, which comes with Oracle. Over the past 30 years, calculators have evolved from expensive novelties to inexpensive, largely ignored dust collectors

(Jayaram Krishnaswamy) In an earlier tutorial we saw how to use SQL commands in the Oracle 10g Express Edition, or simply Oracle XE. We also saw how to use the PL/SQL commands as well. In this tutorial we will see how to use the Query Builder, the graphical interface for fashioning and running SQL i

(Lewis R Cunningham) A reader recently asked: Hi, We are using Oracle eBS and 9i (XML DB not installed), and need to generate XSDs from the client site using SQLPlus. DTDs are currently generated from the client: the SQLPlus script calls a database package that creates a bunch of DTDs from a t