Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

change column name 1

Status
Not open for further replies.
mkey

mkey

Programmer
Oct 3, 2001
288
CA
Hi all,
I have table with data and I need to change one of the column names. How should I go about doing this. I know that Oracle 8i will not allow me to change a column name which contains data.
Any thoughts will be greatly appreciated.
Thank you
bj
 
Sort by date Sort by votes
No can do.

You can follow mokeSQL's thread entitled "rename column with sql"
(thread 186-143320) in this forum for a discussion on an identical question.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Change format name with comma 1
Replies
3
Views
164
TheLazyPig
TheLazyPig
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
287
Livia8
Livia8
Andrzejek
  • Locked
  • Question
Modify columns - parts of virtual column 2
Replies
8
Views
1K
carp
carp
LarrySteele
  • Locked
  • Question
Trying to Transpose Columns to Rows w/ Field Names 1
Replies
9
Views
507
carp
carp
EM1107
  • Locked
  • Question
Insert date and time using UTC time in a DATE column
Replies
14
Views
921
EM1107
EM1107

Part and Inventory Search

Sponsor

Back
Top