Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Avoiding TOO_MANY_ROWS errors in PL/SQL
- Oracle's PL/SQL language has two basic mechanisms for getting data from the database: SELECT and cursors. SELECT is designed to return a single row into local variables; cursors give you the ability to select multiple rows (i.e., a "rowset") and process them one at a time.When you use SELECT in...
- Tags: oracle, databases
- Blog posts 2007-07-31
- Compute the percentage of a total with Oracle's RATIO_TO_REPORT
- Many reports include a percentage of the report total on each line, in addition to the detail data being reported. For example, what percentage does each customer contribute to all of the orders placed in a month, or what percentage does each sales rep contribute to the total sales?The traditional...
- Tags: oracle, databases
- Blog posts 2007-07-17
- Copy Oracle's Automatic Storage Management files with DBMS_FILE_TRANSFER
- Oracle's Automatic Storage Management ASM, introduced in Oracle 10g, provides an alterative to raw disk devices for storing Oracle-related files. Like raw disks, ASM volumes called diskgroups have no filesystem and cannot be browsed directly at the operating system level. This makes maintenance a challenge because you cannot use the...
- Tags: storage, oracle, databases
- Blog posts 2007-07-10
- Multi-dimensional modeling in Oracle SQL
- A spreadsheet is often used as an example of a relational table. Its rows and columns are similar to the rows and columns in a database table. At the intersection of each row and column is a value.The difference is that, in spreadsheets, each cell can also contain a formula...
- Tags: databases, oracle, SQL
- Blog posts 2007-06-26
- Comparing SQL Server constraints and DML triggers
- Over the years, I have witnessed many developers be confused about when to use data-manipulation language DML triggers vs. when to use constraints. I have seen numerous occasions where both objects have been used incorrectly, which has led to problems. This article sheds some light on when to use constraints...
- Tags: Sql Developer, Sql
- Blog posts 2007-06-04
- Creative uses for COALESCE() in SQL Server
- Arthur Fuller shows you two unusual uses of the COALESCE function in SQL Server. For instance, you can generalize its use, as well optimize its performance and make its results constantly available. COALESCE accepts a series of values and a value to use in the event that all...
- Tags: Microsoft SQL Server, Listing B, Databases, Arthur Fuller, server, SELECT dbo.WholeName, SQL Server Newsletter, Problem, Column, COALESCE, Enterprise Software, Software, Data Management
- Technical articles 2007-05-14
- Create ZIP archives dynamically and on the fly with Perl
- This article is also available as a TechRepublic download, which contains the code listings in a copy-and-paste-friendly text format.Perl comes with a wide variety of both built-in functions and external modules to manipulate different file formats. In particular, it has the ability to dynamically create and read compressed ZIP archives...
- Tags: Programming, Perl, General, Code, Application Development
- Blog posts 2007-05-08
- Two approaches to recording shift work in SQL Server
- If you want to list employees' time sheet records in SQL Server by the shift, you should assume that an employee could begin work at any time between the start and stop times of the shift. Learn two ways to preserve the correct groupings in your list. Assume that...
- Tags: Microsoft SQL Server, Listing B, Databases, Arthur Fuller, server, SQL Server Newsletter, Shift, Enterprise Software, Software, Data Management
- Technical articles 2007-05-07
- Three ways to avoid Case Not Found errors in PL/SQL
- Unlike some languages, PL/SQL's CASE statement generates an error if none of the cases are matched. Bob Watkins presents three ways to code around this error. PL/SQL has a rich CASE functionality. The selector CASE statement lets you test the value of an expression (much as the DECODE...
- Tags: Oracle Corp., PL/SQL, Databases, Bob Watkins, Programming languages, PL/SQL CASE, CASE statement, clause, Oracle Tips Newsletter, Solution, Statement, Listing B, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2007-05-01
- Dealing with case and accents in SQL Server
- Collation describes the code page, case sensitivity, accent sensitivity, and language or alphabet in use. This SQL Server tip illustrates how you can force the use of any specific collation. Collation describes the code page, case sensitivity, accent sensitivity, and language or alphabet in use. I often see...
- Tags: Microsoft SQL Server, Listing B, Collation, Storage, Databases, Arthur Fuller, server, collation, database, SQL Server Newsletter, Alphabet, Row, Character Set, Hardware, Enterprise Software, Software, Data Management
- Technical articles 2007-04-30
- Working with .NET files via the Path class
- The .NET Path class, which allows you to work with file path values, uses string values to perform all of its operations. Learn how the class uses various properties and methods to perform operations. Developers often need to know certain aspects of a file such as the name,...
- Tags: Microsoft .NET, Middleware, Tony Patton, .NET, Microsoft development tools, Programming languages, Path class, .NET Newsletter, Microsoft .NET Framework, Class, Listing B, Path, Path String, Code Snippet, Listing D, Microsoft Windows, Application Servers, C#, Operating Systems, Software Development, Software/Web Development, Software, Enterprise Software
- Technical articles 2007-04-24
- Working with .NET files via the Path class
- Developers often need to know certain aspects of a file suchas the name, full path, drive, and file extension. The .NET Framework provideseasy access to these details via the Path class contained in the System.IO namespace.This article examines the various pieces of information available in the Pathclass with a focus...
- Tags: Software engineering/development
- Technical articles 2007-04-24
- Precisely control page and element backgrounds with CSS
- This article is also available as a TechRepublic download.Before CSS arrived, Web developers had limited control overpage and element backgrounds. Sure, they could use the background attribute totile an image over an entire page, and they could control the background colorof an image with the bgcolor attribute.But their control ended...
- Tags: Software engineering/development
- Technical articles 2007-04-19
- Accessing form data via JavaScript and the DOM
- The HTML Document Object Model DOM provides everything necessary to access the contents of an HTML page. Tony Patton examines the various ways to access page elements and describes how to create them. Accessing and manipulating the various elements on a Web page is a common endeavor that...
- Tags: Document Object Model, JavaScript, XML, Tony Patton, Web Development Zone Newsletter, Method, Web, HTML, Page, Object, Listing B, getElementById Method, getElementsByName Method, Listing C, Software/Web Development, Web Development
- Technical articles 2007-04-16
- Audit data using SQL Server 2005's COLUMNS_UPDATED function
- DBA Tim Chapman looks at how the SQL Server 2005 COLUMNS_UPDATED function works and then discusses how to parse out the field names. Auditing data changes in your production environment is very important, especially if you are dealing with confidential information. Besides tracking the data that has...
- Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Tim Chapman, COLUMNS_UPDATED, Databases, Enterprise software, sys.fn_IsBitSetInBitmask, trigger, update statement, audit, SQL Server Newsletter, Function, Auditing, Microsoft SQL Server 2000, Listing B, COLUMNS_UPDATED Function, System Function, Listing C, Software, Data Management
- Technical articles 2007-04-16
- CSS 101: Decide what to style with selectors
- Get more information about the many nuances of the CSS standard by learning about adjacent sibling and attribute selectors, as well as pseudo-classes and pseudo-elements. A CSS selector is made up of a pattern that is matched against all elements in the document tree. Its CSS rule is...
- Tags: Listing B, CSS, Tony Patton, CSS selector, selector, Web Development Zone Newsletter, Listing E, Scripting Languages, Software/Web Development, Web Development
- Technical articles 2007-04-09
- Comparing Oracle 10g column masking to relational views
- Thanks to the suggestion of TechRepublic member BrooklynPennyPincher, this Oracle tip compares two approaches to hiding column-level data on a report: the Virtual Private Database and relational views. In a previous tip, I described how a column's data could be masked hidden using Oracle 10g's Virtual Private Database...
- Tags: Oracle Corp., Oracle Application Server 10g, Listing B, Bob Watkins, Virtual Private Database, relational view, predicate, salary, Oracle Tips Newsletter, View, Benefits, Human Resources
- Technical articles 2007-04-02
- Create powerful interfaces by combining ASP.NET 2.0 data controls
- Learn how to combine ASP.NET 2.0's GridView control with a DetailsView or FormView control. This will allow a user to select an individual column from GridView and view or manipulate its contents with DetailsView or FormView. The past several columns have covered a selection of ASP.NET 2.0 data...
- Tags: Microsoft ASP.NET, GridView, DetailsView, Middleware, Databases, Tony Patton, .NET, Microsoft development tools, ASP.NET 2.0, Gridview Control, .NET Newsletter, Control, Data, Row, Property, Microsoft ASP.NET 2.0, User, Listing B, Data Control, FormView, CommandField'sButtonType Property, ControlParameter Element, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2007-03-27
- Easily manipulate data with the GridView control in ASP.NET 2.0
- Tony Patton recently introduced ASP.NET 2.0's GridView data control and covered the basics of using it. In part two of this series, he demonstrates how the GridView control makes it easy to view, edit, and delete data. Last week, I introduced ASP.NET 2.0's GridView data control and covered the...
- Tags: Microsoft ASP.NET, GridView, Middleware, Tony Patton, .NET, Microsoft development tools, ASP.NET 2.0, server control, HTML Text, TemplateField, .NET Newsletter, Data, Server, Microsoft ASP.NET 2.0, Listing B, SqlDataSource, SqlDataSource Element, Listing C, Listing D, Software Development, Software/Web Development, Enterprise Software, Software
- Technical articles 2007-03-06
- Easily manipulate data with the GridView control in ASP.NET 2.0
- Last week, I introduced ASP.NET 2.0's GridView data control and covered the basics of using it.This week, I go a step further by going into the details of working with thedata contained in the control. This includes viewing, editing, and deletingdata. Thankfully, the GridView control makes it easyto utilize these...
- Tags: Software engineering/development, server control, ASP.NET 2.0, Microsoft ASP.NET, Tony Patton, GridView, HTML
- Technical articles 2007-03-06
