Tag: sqlplus

Features (4)

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 »

Serialise data with ANYDATA columns

With the ANYDATA data type and some dynamic SQL, it's possible to serialise as many tables as you wish into a single backup table using a single serialisation stored procedure. Find out how in this hands-on tip. Read more »

Ask Oracle: Using the INFORMATION_SCHEMA

In this article our Builder AU reader has a problem using the INFORMATION_SCHEMA. Oracle expert Richard Rendell gives his advice. Read more »

Log in

News and features

Latest
Popular
Features
Most Discussed

IBM's 'Microsoft-free' desktop saves '50%' on costs (4 hours, 0 minute ago)
With JavaFX, Sun seeks new coders, new revenue (20 hours, 56 minutes ago)
Python 3.0 out, breaks compatibility
Adobe cuts 600 amid slow CS4 sales
Windows 7 beta due in January?
Android to hit Australia on 29 Jan
More news »

Blogs

The festive season not so festive

This is still meant to be the festive season, isn't it? When they say you should show goodwill towards your fellow (hu)man, I don't think they meant redundancy payments. Read more »

-- posted by Staff
Tools for the Semantic Web

This blog post covers some of the technologies available for creating applications for the Semantic Web. Read more »

-- posted by Lana Kovacevic
Bridging the gap between programmers and the vision

A successful project will have a hard time flying if you don't walk through the game plan before writing a line of code. Read more »

-- posted by Brendon Chase

Videos

Quickly map drive letters in Windows XP

2008/10/01 13:30:44

Play the video
Google feeling the pinch?

2008/12/03 14:27:04

Play the video
How to Reset Windows passwords

2008/10/01 14:31:09

Play the video

What's on?

Space pr0n, patent karma and Yang out -- Club Builder

On Club Builder this week: how NASA plans to get the Internet into space, Jerry Yang is out the door at Yahoo and Brendan Eich discusses javascript engine competition.