Oracle

Copy legacy Oracle tables with SQL*Plus

Tables with a LONG datatype cannot be copied via the CREATE TABLE AS SELECT syntax. They can, however, be copied with the SQL*Plus COPY command. This Oracle tip shows you how. Read more »

Render SQL*Plus output in HTML

SQL*Plus has traditionally been thought of as a plain text SQL query tool. But since Oracle 8i, it has also had the capability to render its output using HTML. Read more »

Encrypt backups using Oracle 10gR2's RMAN

No IT pros want their company to make headline news because of a data breach. You can make your data less vulnerable to theft by using a new feature in Oracle 10g Release 2 that lets you make encrypted backups via Recovery Manager. Read more »

Explore Oracle 10g's updated sample schemas

Each new release of Oracle database brings with it new features to explore. It can be a challenge to create adequate sample tables to play with a given feature. Read more »

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 »

Understanding roles in Oracle-stored procedures

Permissions in Oracle granted indirectly via roles are not available when compiling stored procedures, functions, and packages. Direct grants are required when creating these objects in the database. 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 »

Switching Oracle Portal to a new database is easier than Oracle Tech Support says

If you do not have to support an Oracle Portal, consider yourself lucky. We recently ran into a problem that forced us to quickly move to a new metadata database. Read more »

Avoid Oracle Portal at all costs

If your boss ever brings up the subject of Oracle Portal, you should run screaming from the building. It is easily one of the buggiest pieces of software I have ever encountered. Read more »

Sometimes a variables table is better than hard coding into a package

When writing PL/SQL packages, there are times where it's better to store a variable in a table instead of coding it into the package. It's most useful for a variable that you might want to change fairly often. Read more »

Log in


Sign up | Forgot your password?

Blogs

RSS feed

  • Staff Shadow chasing in browsers

    The punching and counterpunching continued in the ongoing web browser development bout. Each time one browser closes a feature gap, a new feature appears in one of the others -- how we ever put up with the years of browser stagnation, I'll never know. Read more »

    -- posted by Staff

  • Chris Duckett Safari gets Gears

    Since its release in May last year, Gears has supported only Internet Explorer and Firefox browsers. With the addition of Safari into the Gears fold, it closes the loop of major browsers to support Gears Read more »

    -- posted by Chris Duckett

  • Renai LeMay MyPerfect.com.au has potential

    Victorian Web start-up My Perfect has a strong story and rationale for why it will succeed. But it has to overcome some challenges and design flaws first. Read more »

    -- posted by Renai LeMay

What's on?