The Oracle Database Listener is the database server software component that manages the network traffic between the Oracle Database and the client. The Oracle Database Listener listens on a specific network port (default 1521) and forwards network connections to the Database. The Listener is compris

(Joe McKendrick) Continuous, 24×7 availability is no longer just a marketing slogan; it is now a necessity for eight out of 10 Oracle-based enterprises. With the rise of Internet-based business and service-oriented architectures that require that networks of applications and data be available to en

(Rudy Limeback) How do you insert multiple rows of data, say five rows of data, using insert into command? (R)

(Andrei Cioroianu) Enterprise applications can use Ajax to provide better Web interfaces that increase the user productivity. In many cases, it is possible to submit a partially completed form to obtain useful information from the server application. For example, the server could perform some early

(Alistair Lattimore) I recently had a requirement to store a time within Oracle, not a timestamp or a date – just the time. As it turns out, storing just the time information in Oracle isn’t something you can do without a little bit of work.

(Chris Page) If you are using Oracle databases, and you aren’t already working with Oracle Real Application Cluster (RAC) databases, it’s likely only a matter of time before you are. Oracle RAC databases can be used as a platform to provide scalability and high availability for Oracle databases, and

(Lawrence Linnemeyer and Bradley Brown) Most experienced programmers understand the advantages of separating the look and feel of an application from the application’s logic. Oracle uses HTML DB to accomplish this. This article introduces you to the themes and templates that HTML DB provides.

(Lucas Jellema) No matter how fancy the application you develop, no matter how sophisticated the user interfaces: end users will always clamor for Excel. All data eventually will end up in some Excel Spreadsheet it seems. And grudgingly or not, we will of course oblige them. Depending on how difficu

(Steve Callan) Is Oracle always the best tool or application to manipulate data? The answer lies within what you mean by manipulate. Data can be transformed via data manipulation language, and it can also be transformed via string or numerical manipulation. To distinguish between the types of manipu

(Alejandro Vargas) Rman compressed backup provides an efficient way to save space and transfer time over the network when cloning databases.