(Galina Petrenko) This code shows you how to generate comma or pipe delimited output for tools such as Excel, Access, and so on while spooling from SQL*Plus.
Tag: Oracle
The Oracle DBA’s Guide to NT
This article presents a “lessons-learned” approach to whet you need to know about NT to setup, configure and best use Oracle.
Managing Web Services
(Mike Lehmann) If you think the term Web services is loosely defined in the industry, try looking for a clear definition of Web services management. Some think it is as simple as Web service configuration, monitoring, auditing, and logging. Others speak more abstractly, using terms such as service v
Creating an Oracle JDeveloper Application Migration Assistant Search Rules File
Oracle JDeveloper Application Migration Assistant (AMA) is a new tool developed by the Migration Technologies Group at Oracle to simplify the process of migrating applications to the Oracle platform. AMA provides simple code navigation and progress reporting to guide you through an application migra
Multiple Temporary Tablespaces in Oracle 10g
(James Koopmann) When a users executes a SQL statement that requires sorting or does some sort of database maintenance that requires the creation of temporary segments, it is the temporary tablespace that assists in that sorting or holding of those temporary segments. If we did not have an area desi
Oracle’s Web Conferencing Update
(Demir Barlas) The Web conferencing component of the Oracle Collaboration Suite has been around for about 10 months. Oracle recently offered Line56 an update on traction. According to Michael Miller, senior director of product management for Oracle Web Conferencing, there are 3,000 companies current
Guide to Linux System Command Mastery
(Sheryl Calish) In “Guide to Linux File Command Mastery,” we covered the basic information needed to take advantage of the most essential and commonly used Linux file commands. In this article, I’ll do the same with Linux system commands. As we learned in the previous article, everything is trea
So You Want to Become an Oracle DBA? Part 2 – Learning Oracle on your own
(Steve Callan) This is the second of a two-part series about how you can become an Oracle DBA in today’s almost non-existent DBA job market. This article focuses on inexpensive and effective means of learning Oracle. The bad news: short of someone else paying for your education, you can expect t
Oracle Background Processes
(Amar Kumar Padhi) An Oracle instance runs two types of processes – Server and Background. Server processes are created to handle requests from sessions connected to the instance. Background processes, as the name says, are processes running behind the scene and are meant to perform certain main
Oracle 10g: Putting Grids to Work
(Dan Kusnetzky and Carl W. Olofson) IDC believes that organizations wishing to move in an evolutionary way to Grid/Utility Computing architectures would be well advised to consider Oracle’s Oracle 10g family of products. Applications currently written for Oracle’s application server or data mana
