RE: Column Name

If you have 8i you can add new column name,populate with old column data,drop old column. Rick -Original Message- Sent: Tuesday, September 04, 2001 2:38 PM To: Multiple recipients of list ORACLE-L List, Is there any way to rename a column without changing the position of column?

RE: Column Name

But he doesn't want to change the position of the column. The only way I'd see to do this (don't know why it would ever be important) is to copy all the columns to the right of the old column along with the primary key to another table, drop them, do your step, add the columns back, populate the

Re: Column Name

Hamid, You could create a new table and select the values from the old table and then rename the new table after saving the old one. Be sure to check all packages, permissions, etc. Why the renaming of a column? Developers should not code positional dependency on columns in their code. They

Re: Column Name

In the short term: Rename XXX to YYY create view XXX as select {all the columns} from YYY; In the longer term - migrate to Oracle 9 Jonathan Lewis http://www.jlcomp.demon.co.uk Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of:

Re: Column Name

In the unsupported short term there are scripts around on the net for hacking COL$ and associated dictionary objects... Note: This is NOT an email advising you to do it. --- Jonathan Lewis [EMAIL PROTECTED] wrote: In the short term: Rename XXX to YYY create view XXX as select

RE: Column name

FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails using the old format will continue to be delivered until 30th June 2001. Roland It is quite normal to use the

Re: Column name

Yes you can use the same column name in a database and in a schema. The only thing is that you have to precede the field with the table name when you're joining 2 tables containing columns with the same name. Let's open a can of worm. There are 2 stands on this : 1. Something should have the

RE: Column name

the only concern is column ambiguity. Precede the field with the table name when you're joining tables. Sunil Nookala Dell Corp Austin, TX -Original Message- Sent: Friday, April 27, 2001 5:00 AM To: Multiple recipients of list ORACLE-L Can I use the same column name in the same

Re: Column name

The only duplication of column names that is not allowed in the same column name in the same table in the same schema. The column name ename can be in any table you create. ROR mª¿ªm [EMAIL PROTECTED] 04/27/01 06:00AM Can I use the same column name in the same database and in the same

Re: Column name

spool currently spooling to C:\WINDOWS\Desktop\huh.LST SQL create table test1 (f1 char(1)) 2 SQL / Table created. SQL ed Wrote file afiedt.buf 1* create table test2 (f1 char(1)) SQL / Table created. SQL ed Wrote file afiedt.buf 1* insert into test2 values ('2') SQL / 1 row created.

Re: Column name

I'd side with Stephan on this. Many folks think it necessary to preface foreign key columns with the short name of the parent table.column. Most of the time this is redundant. There are situations where it is necessary though: 1. inheriting 2 columns of the same name from different