(James F. Koopmann) Need to brush up on some basic scripting? It has been my observation that some very basic scripting techniques have been either forgotten or never learned by many IT professionals. I don’t know if it is because we are such a GUI driven society of professionals now or something

(Garry Robinson) Like SYSTEM, the SYSAUX tablespace is mandatory. It is primarily used to store AWR data collected by MMON but is also used as the default tablespace for OEM, RMAN repository, Logminer and advanced features such as Oracle Text, Workspace Manager, Streams and Spatial. If you elect to

If you want to get your hands on Oracle 10g RAC but don’t have the necessary hardware to get started, try the low cost alternatives below. Note: each of these alternatives provides a method to learn the functionality of RAC but not the capacity, scalability or feasibility of a production grade hardw

(Scott Stephens) Oracle stores numbers with the NUMBER datatype in an unusual format, with bytes in binary-coded decimal (where the byte hex value 0x99 represents 99 decimal). ANSI standard datatypes such as INTEGER, FLOAT, and DOUBLE are aliases for the NUMBER datatype, with extra restrictions: INT

(Galina Petrenko) This code gives date ranges for the start-end of the week, regardless of the NLS setting for the system.

You tried to connect to Oracle, but the service name is either missing from the TNSNAMES.ORA file or is incorrectly defined.

(Steve Callan) The title says it all, except these are some of my personal favorites.

(John K. Waters) Oracle Corp. released the long-awaited overhaul of its database design and ETL (extraction, transformation and load) tool, Warehouse Builder 10g, Release 2 (formerly code-named “Paris”).

(Przemyslaw Piotrowski) Developers today benefit from a range of server-side technologies that function as the middle layer between a Web server and the database, including JavaServer Pages (JSP), Active Server Pages (ASP), PHP, and if you’re an Oracle developer, PL/SQL Server Pages.

(Bruno Vroman) In a case where you cannot (because you don’t have enough time, for example) query V$SESSION to initiate a trace for the session, and you have to trace a "fast" user session, (for example, initiated by clicking on a button on the GUI of an application), this code traces the session(s)