OraFAQ Forum: Reports & Discoverer

Mon, 07 February 2005 03:28

anand kumar singh
Messages: 32
Registered: July 2003

Member

How to rename a table which already has some data.

Wed, 09 February 2005 05:16

John Smith
Messages: 25
Registered: February 2002

Junior Member

Why not try replicating the table:

Create table new_table as (select * from old_table).

Mon, 21 February 2005 09:52

SANDY
Messages: 60
Registered: April 1998

Member

Hi Friend,
U can use
Rename Oldtablename to newtablename;
Cheers
Sandy

Previous Topic:	sorting on summary column
Next Topic:	What is COA(certificate of analysis)? Is there any "Oracle standard COA print report'?

Goto Forum:

]

Current Time: Tue Nov 26 01:15:39 CST 2024