News (4)

UK govt to monitor all telecoms

UK internet service providers will be invited to tender for a British government scheme to monitor all internet communications and telecommunications in the country. Read more »

GPL3 welcomed by IBM, Red Hat, Novell, MySQL

Sixteen years after releasing GPL2, Richard Stallman and the Free Software Foundation launched GPL3 over the weekend. Read more »

Public debate on GPL 3 draft begins

The Free Software Foundation on Monday released the first public discussion draft of the General Public Licence version 3, shedding light on proposed reforms to the document's patent and digital rights management provisions. Read more »

Government backs renegade open source licence

The federal government's recently-launched open-source content management system does not meet industry standards, local software developers and a leading IT lawyer claim. Read more »

Features (58)

Control null data in Oracle using the ORDER BY clause

NULL data, which is sometimes called "absent" data, can be difficult to work with in relational databases. Learn how to control null data in Oracle using the ORDER BY clause. Read more »

Iterating through tables and databases in SQL Server

We look at two very useful stored procedures that live in the master database but are not mentioned in SQL Server Books Online. These system procedures come in very handy for jobs such as determining the space used, the number of rows, the indexes on the user tables, and so on. Read more »

Generate dynamic SQL statements in SQL Server

When you need to solve a tricky database problem, the ability to generate SQL statements is a powerful tool -- although you must be careful when using it. This article explores how you can use this functionality to generate SQL statements on the fly. Read more »

Executing queries with phpMyAdmin

This tutorial shows you how to construct and execute queries using phpMyAdmin. Read more »

Set named restore points for easier flashback in Oracle 10gR2

The MERGE statement, introduced in Oracle 9i Release 2, is often called an "upsert" because it can both update and insert rows in the same pass. Rows that don't already exist in the data warehouse are inserted, and rows that do exist are updated. Read more »

SQL basics: SELECT statement options

Master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier. Read more »

Ask Oracle: How do I set up a Virtual Private Database?

Want to set up a virtual private database? Oracle guru Richard Rendell answers our Builder AU reader's question that will get your database up and running in no time. Read more »

10 tips for sorting, grouping, and summarizing SQL data

Arranging SQL data that you can effectively analyse requires an understanding of how to use certain SQL clauses and operators. These tips will help you figure out how to build statements that will give you the results you want. Read more »

How do I ... reject alpha characters in a SQL Server character column?

Enforcing your data's integrity is probably the single most important issue you face when designing a database. Validating user input is one way of keeping bad data from making its way into your analyses and reports. Read more »

Is SQL a standard anymore?

For many companies, SQL standard conformity is an important consideration when choosing a relational database management system (RDMS), so why is this standard considered optional for database manufacturers? Read more »

More Clause, Database Features Results

Log in


Sign up | Forgot your password?

Blogs

RSS feed

  • Staff A first look at Windows 7 beta

    In this week's Roundup we show you a preview of Windows 7 beta, cover news from the annual Macworld and more. Read more »

    -- posted by Staff

  • Staff Opera's new SDK: Better browsing on the Wii?

    Opera has thrown a little more love at device developers by announcing an updated version of its software development kit on Wednesday at CES. Read more »

    -- posted by Staff

  • Staff 2008: Time to call stumps

    It's another year down but some things never change. That was shown this week as Internet Explorer remained under fire from yet another zero-day exploit. In other news, we set a hard drive on fire and Apple cans its involvement with MacWorld. Read more »

    -- posted by Staff

What's on?