non-random ramble

http://www.dba-oracle.com/t_alter_table_rename.htm

create table faq_tbl(
id number,
doc xmltype,
hits number)
XMLTYPE COLUMN doc
XMLSCHEMA "http://www.oracle.com/faq.xsd"
ELEMENT "FAQ"

alter table
SONGS
rename to
SONGS_HUGE;

AAAARRRHGG!!

This is so exciting, ive been waiting for years to hear something that actually makes *sense*.

www.waterfall2006.com