=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM | Database Developer Tip September 26, 2001 Essential explanations and code for the database developer. Our collection of over 200 free tips can be found at: http://searchdatabase.techtarget.com/tips/ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE DEVELOPER TIPS - Developer Tip: Java and stored procedures - Developer Tip: Why use stored procedures? - Developer Tip: SELECT DISTINCT queries and derived tables 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Featured Book-of-the-Week - Win a Toshiba DVD Player - Best Web Links for database developers ___________________________________________________________________ ************* SPONSORED BY: PostMaster Direct ******************** G E T T H E I N F O Y O U W A N T T O D A Y What do YOU want in your e-mailbox? How about FREE info and offers about computers, networking, wireless devices, finance and lots more? Visit http://searchdatabase.techtarget.com/postmasterDirect/1,289639,sid13,00.html, choose the topics that interest you, and you'll get the e-mail you want. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= CALLING JAVA STORED PROCEDURES FROM TRIGGERS | by Jeffrey Tarnok Triggers are often employed to handle pre- and post-data manipulation language (DML) processing and can be used to facilitate complex constraint requirements. Oracle supports the use of Java in the database as a non-proprietary, powerful programming language. Coupling triggers and Java stored procedures can satisfy platform-independent database programming policies and often complicated application-related DML processing requirements. Here's an example of a trigger that calls a Java stored procedure. >> CLICK for the full tip... http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci772163,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= WHY USE STORED PROCEDURES? | by Parthasarathy Mandayam Stored procedures offer several distinct advantages over embedding queries in your Graphical User Interface (GUI). Your first thought may be: "Why tolerate the added development overhead?" After seeing the advantages, you may change your mind. >> CLICK for the full tip... http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci755947,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SELECT DISTINCT QUERIES AND DERIVED TABLES | by Cade Bryant As most database admins and developers know, SELECT DISTINCT queries are quite resource-intensive, especially if you are querying a large table. Even if there are only three or four distinct values in the table, DBMS's such as SQL Server must still search the entire table to get those. Cade was faced with this challenge recently: he needed to query distinct values on a column in a huge table, and he knew that all values would be represented within the first thousand records. Here's how he did it. >> CLICK for the full tip... http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci754605,00.html ____________________________________________________________________ :::::::::: DON'T MISS THESE IMPORTANT MESSAGES AND LINKS ::::::::: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= THIS WEEK'S FEATURED BOOK | searchDatabase.com Bookstore Title : Understanding SQL and Java Together Authors: Jim Melton & Andrew Eisenberg With the growth of Java and the rise of database-powered Web applications, the need to use Java with SQL is clear. Until now, authoritative coverage of the techniques available to meet these challenges and reap their benefits -- both programming and career benefits -- didn't exist. "Understanding SQL and Java Together" examines all the standards for combining SQL and Java. It shows you exactly how to use their features to write efficient and effective code supporting Java access to SQL data in a variety of ways. You'll gain a thorough understanding of the relationship between SQL and Java, which will allow you to write static and dynamic SQL programs in Java, merge Java code with SQL databases and SQL code, and use other data management techniques wherever appropriate. http://www.digitalguru.com/DigitalGuru/product_detail.asp?catalog_name=Books&category_name=&product_id=1558605622&partner_id=77 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= WIN A TOSHIBA DVD PLAYER! | Submit your Tip Share your knowledge, help your peers, and compete to win a $200 DVD player. Submit your SQL, Java, PERL, C++, Oracle, SQL Server, or DB2 tips today. Hurry: Contest ends September 30th! http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz764692_cts764388,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DATA WAREHOUSING | Best Database Web Links NEW: Hundreds of hand-picked and reviewed resources about every aspect of data warehousing and business intelligence, including ETL, data quality, ROI, OLAP, star schemas, and much more: http://searchdatabase.techtarget.com/bestWebLinks/0,289521,sid13_tax281567,00.html ____________________________________________________________________ :::::::::::::::::: SEARCHDATABASE.COM CONTACTS :::::::::::::::::::: TIM DICHIARA, Site Editor ([EMAIL PROTECTED]) >> Send us your original articles and best practices. ____________________________________________________________________ ED PARRY, News Editor ([EMAIL PROTECTED]) >> Send in your product announcements and poll ideas. ____________________________________________________________________ GABRIELLE DERUSSY ([EMAIL PROTECTED]) >> Sponsor this or any other TechTarget newsletter. ____________________________________________________________________ ___________________________________________________________________ :::::::::::::::::::: ABOUT THIS NEWSLETTER ::::::::::::::::::::: Created by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2001, All Rights Reserved. If you no longer wish to receive this newsletter simply reply to this message with "REMOVE" in the subject line. Or, visit http://searchDatabase.techtarget.com/register and adjust your subscriptions accordingly. If you choose to unsubscribe using our automated processing, you must send the "REMOVE" request from the email account to which this newsletter was delivered. Please allow 24 hours for your "REMOVE" request to be processed.