Quote:
Originally Posted by Shikhashah
Basically I want to change the column name to lowercase, I tried remaining the column but its not useful as it would take the duplicate columns.
|
Changing name = renaming. Not sure what you mean with "duplicate".
Quote:
Originally Posted by Shikhashah
How can I change the column name to lowercase?
|
Rename it. Oracle identifiers are case insensitive, interpreted as uppercase. When you want to use mixed case or include any special character except underscore (_), dollar sign ($) or pound sign (#), you have to put them between double quotes.
Code:
ALTER TABLE employee RENAME COLUMN address TO "address"
Note that you will have to
always use double quotes when referencing that column. Why do you want to do this at all????
(yes, those four question marks are intentional, because it is really
not a good idea. definitely
not)
You may read more facts about Oracle identifiers (they use the term "Object Names and Qualifiers", just search for it) in the same book I suggested you in the previous post.