renaming tables, columns etc.... [message #370535] |
Fri, 17 December 1999 00:07 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Barry O'Sullivan
Messages: 1 Registered: December 1999
|
Junior Member |
|
|
I have a database whose tables, columns etc are written in French. I have English translations and want to implement them. What is the best way to do this?
Thanks for your help......
Barry
|
|
|
Re: renaming tables, columns etc.... [message #370544 is a reply to message #370535] |
Fri, 17 December 1999 07:15 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Paul
Messages: 164 Registered: April 1999
|
Senior Member |
|
|
Barry
You can
CREATE table ENGLISH_TABLE_NAME as
SELECT FRENCH_COL1 as ENG_COL1,
FRENCH_COL2 as ENG_COL2,
-- keep going till all columns listed
FROM FRENCH_TABLE_NAME;
Hope this helps,
Paul
|
|
|