update column named "FROM" in oracle
[168 byte] By [Daiesha] at [2007-11-27 5:20:01] 
I have a column named "FROM" in oracle. If i updated that column i got Syntax error. What is the query to update such kinda of column name?Advance wishes.
You can escape the names so they do not get checked against reserved SQL word. Then you have to provide them in the right case. Maybe like this?'FROM'
BIJ001a at 2007-7-12 11:43:42 >
Oh rename the column already. Who names a column "FROM"? Do you have another one named "SELECT"?
cotton.ma at 2007-7-12 11:43:43 >
Java Essentials New Topic
Java Essentials Hot Topic
Java Essentials
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding