=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM | Database Developer Tips March 13, 2002
Essential tools and advice for the enterprise database developer: http://searchDatabase.techtarget.com/tips/ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE DEVELOPER TIPS - Oracle: Application inventory script - Oracle: An example of dynamic SQL in PL/SQL - SQL Server: Table names with spaces - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Expert: Oracle, SQL Server, DB2 questions answered - NEW Online Event: Bill Inmon on the sorry state of metadata - Fabian Pascal answers your questions - Featured Topic: Spotlight on stored procedures ___________________________________________________________________ ********************** Sponsored by: Sybase *********************** Learn More About the Market Leading Embedded Database. There's an art to hiding genius in plain sight. And we've hidden a lot. SQL Anywhere(R) Studio 8.0 is self-tuning, self-administering and always ready to serve. For a free download or evaluation CD click here: http://ad.doubleclick.net/clk;3830722;6845045;i?http://www.ianywhere.com/hiddenonline ___________________________________________________________________ ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= APPLICATION INVENTORY SCRIPT | by Dixie Hill This Oracle script will dynamically get the number of rows, objects and their definitions, and descriptions of schema objects. Good to review after a database refresh. The script is run in a Windows/NT environment from SQL*Plus. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci804488,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DYNAMIC SQL IN PL/SQL | by Prashant Gijare Here's an sample PL/SQL script showing you how to use dynamic SQL. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci809890,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= TABLE NAMES WITH SPACES | by Sumit Singh Most books and other resources say that you can't have spaces in the name of a table. I say you can! Here's a little trick that will allow you to do it: just use brackets. create table [Data Report] ( -- your code for attribute -- ) [Data Report] is the name of the table. >> CLICK for the online version of the tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci809883,00.html __________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= COMPARING TREES IN THE NESTED SETS MODEL | by Joe Celko In his continuing series of advanced SQL tips, Joe offers some code that compares nodes and structures of trees in the Nested Sets model for hierarchies. http://www.searchDatabase.com/tip/1,289483,sid13_gci805976,00.html FINDING ASCII REPRESENTATIONS OF INTEGERS VIA SQL | by Karen Porter http://www.searchDatabase.com/tip/1,289483,sid13_gci804491,00.html You may sometimes want to include a carriage return or other character into an SQL statement. Single tics are especially confusing due to breaking them on and off to be effective. This tip shows you how to use the CHR() function to write single tics into SQL. If you forget what integer is required in the CHR() function, you can use the script to determine what integer you should use. A STORED PROCEDURE TO EXPORT/IMPORT DATA USING BCP | by Eli Leiba http://www.searchDatabase.com/tip/1,289483,sid13_gci804489,00.html Here is a SQL Server stored procedure that can be run from a master database to export or import a table to/from a given file path+name from/to a given database. SQL*PLUS FILE FINDER FOR WINDOWS | by Dusan Djuric http://www.searchDatabase.com/tip/1,289483,sid13_gci799189,00.html You are in an Oracle SQL*Plus session in Windows. Somewhere on your machine is the one script you need, but where? The script name is something like my*query.sql, but you're not sure. What do you do? Here's a handy way to find it fast. Hundreds more free tech tips submitted by members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html Share your knowledge, submit a tip, win a CENDYNE CD-RW PLAYER! http://searchdatabase.techtarget.com/tipsSubmit/1,289485,sid13,00.html ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | This week's toughest database questions answered Data warehousing: Can Informatica import metadata from other tools? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid455592_tax288372,00.html Oracle: Installing Developer 6i and Oracle 8 together http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid455594_tax289342,00.html SQL Server: Retrieving data via an HTML document through IIS http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid455597_tax285648,00.html Oracle: Advantages of upgrading from 7 to 8i or 9i http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid451937_tax289341,00.html SQL: Extracting the highest record in a group http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid454950_tax285649,00.html Hundreds more expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= LIVE EXPERT Q&A | Metadata: No longer a second-class citizen Who: Bill Inmon When: March 14, 2002 at 2:00 PM EST (19:00 GMT) THURSDAY! The father of the data warehouse discusses how the world of metadata has arrived in such a sorry state and why your organization must develop a metadata strategy to succeed. >> CLICK: http://searchdatabase.techtarget.com/onlineEvents/0,289675,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR INTEGRITY, NORMALIZATION, AND RELATIONAL MODEL QUESTIONS ANSWERED | Fabian Pascal's Against the Grain In this month's column, Fabian tackles some thorny questions asked during his "Live Expert Q&A" on searchDatabase last December. Read his typically irascible responses and forceful arguments on topics such as: * The difference between logical and business models * Denormalization and performance * The lack of full normalization technology among database vendors * Integrity constraints and SQL DBMS's * Normalization and data warehouses * Fabian's favorite RDBMS! Read the column here: http://www.searchDatabase.com/tip/1,289483,sid13_gci804576,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SPOTLIGHT ON STORED PROCEDURES | SearchDatabase Featured Topic Stored procedures increase the performance, flexibility and security of your DBMS. Here is a selection of our best tips and expert advice about coding effective Oracle, SQL Server and DB2 stored procedures and triggers. >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci809177,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIP MAILBOX (mailto:[EMAIL PROTECTED]) >> Submit your original tip here. TIM DICHIARA, Site Editor (mailto:[EMAIL PROTECTED]) >> Send your feedback and original articles. SARA CUSHMAN, Assistant Editor (mailto:[EMAIL PROTECTED]) >> Send your White Papers and favorite Web sites. ED PARRY, News Editor (mailto:[EMAIL PROTECTED]) >> Send your product announcements and poll ideas. TOM CLICK, Sales (mailto:[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 2002, 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.
