| October, 2002 |
|
|||||||||||||
|
All articles have been reprinted with the written consent of their respective authors.
| ||||||||||||
|
|||||||||||||
|
Getting SQL Query Results into an Excel
Spread Sheet This months script will help users get SQL query results into an Excel spread sheet. SET LINESIZE 999 VERIFY OFF FEEDBACK OFF SET MARKUP HTML ON ENTMAP ON SPOOL ON PREFORMAT OFF DEFINE table_name = &1 SPOOL &table_name..xls SELECT * FROM &table_name; SPOOL OFF SET MARKUP HTML OFF ENTMAP OFF SPOOL OFF PREFORMAT ON SET LINESIZE 80 VERIFY ON FEEDBACK ON REM Use this command to start Excel from char-mode sqlplus REM HOST start &table_name..xls REM Use this command to start Excel from GUI-mode sqlplus HOST start excel.exe &table_name..xls |
|||||||||||||
|
|||||||||||||
|
Installing & Configuring Oracle9i on the
Solaris Platform This paper will walk you through the steps of installing Oracle9i release 2 (Oracle version 9.2.0) in a Sun Solaris SPARC environment. About 90% of the material presented here applies to other platforms as well. Everything you read in this paper is hands on, roll-up-your-sleeves-and-get-busy material for Oracle users who want to get an Oracle database up and running quickly without reading hundreds of pages of documentation and “readme” files. These steps are meant to get you up and running
as fast as possible, while leveraging best practices in order to set up a
scalable, robust database environment that offers high performance. In order to
keep the steps reasonably simple this paper does not cover Real Application
Clusters (RAC), nor does it cover Oracle Internet Directory or Oracle Management
Server installation.
Click Here for
the paper.
|
|||||||||||||
|
|||||||||||||
|
Using UTL_SMTP I wrote this package to send email messages from PL/SQL. Using existing examples, I added the simple ability to pass a query in and return data in the text of the email. I also allow the passing in of a PL/SQL table for an address list. Click on the links below for the procedure and a sample execution.
Click
Here for the procedure.
|
|||||||||||||
|
|||||||||||||
|
Microsoft T-SQL Performance
Tuning - Part 2 This article is the second in a series that describes a variety of performance tuning techniques that you can apply to your Microsoft SQL Server Transact-SQL programs. In many cases, you could use the graphic user interface provided in Microsoft SQL Enterprise Manager or Microsoft SQL Query Analyzer to achieve the same or similar results to those described here. However, this series focuses on using Transact-SQL as the basis for our solutions. All examples and syntax are verified for Microsoft SQL Server 2000. Creating proper indexes is probably the single most critical aspect of T-SQL performance. Adding a new index can very often reduce response time of a query from hours to seconds. This article is all about choosing the best indexes and then analyzing their effectiveness. The SQL Server Optimizer can analyze and choose indexes for you, but it can only choose from existing ones. It is difficult to overstate how important good indexes are to query performance. Spend extra time analyzing and creating best indexes for any query that you expect to show good performance. There is another side of this coin. Poorly chosen indexes result in poor response time and immense aggravation of the same managers and users. Click
Here for the paper. |
|||||||||||||
|
|||||||||||||
|
Managing Risk - Part II Each month, Tom Mochal presents a set of project management tips and techniques for handling various aspects of planning and managing a project. Tom has over 23 years of IT experience. He has developed a comprehensive, scalable project management process called TenStep, which can be viewed at www.tenstep.com Risk refers to future conditions or circumstances that exist outside of the control of the project team that will have an adverse impact on the project if they occur. In other words, whereas an issue is a current problem that must be dealt with, a risk is a potential future problem that has not yet occurred. Click Here for tips
and techniques on managing risk. |
|||||||||||||
|
|||||||||||||
|
Free Seminar - Running Fast &
Lean with DB2 on the Mainframe
Free e-Seminars
Free United Kingdom e-Seminars
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
Interactive Crossword Puzzle: "Famous Animals"
|
|||||||||||||
|
|||||||||||||
We love getting white papers, tips, articles, and code examples/archives from our readers around the world. Send your submission to newsletter@quest-pipelines.com. If your article is published, we will mail you a FREE gift from Quest as a gesture or our appreciation. Our mission at Quest Software - RevealNet Labs is to anticipate the daily responsibilities and challenges faced by database professionals. Our products help thousands of people solve problems and implement solutions every day. This newsletter is designed to help facilitate the sharing of information among database professionals. It is currently circulated to 28,000 readers. About the Newsletter This newsletter is distributed to Quest Software - RevealNet Labs customers, prospects and friends who have subscribed to it from our website. If you would like to unsubscribe, please send a note to unsubscribe@quest-pipelines.com and we will make every effort to remove you from our list. Subscribe a Friend! Do you know someone who would like to receive the Pipeline Newsletter? If so, please enter their email address in the box below and click SUBMIT.
Past Issues of the Pipeline Newsletter
|
|||||||||||||
