Arunkumar Arjunan
Reputation: 382
How to truncate a column alone in oracle SQL?
How to truncate a specified column among all the columns in my table?
Upvotes: 3
Views: 40631
Answers (1)
Pரதீப்
Reputation: 93694
Just use a update statement without a where condition
Update tablename
set column ='' --or NULL
Upvotes: 17
Related Questions
- Trim table column length over x charcters
- Oracle 10g: truncate string
- Can I use TRIM and TRUNC function in oracle?
- Truncate SQL varchar column
- truncate integer
- Truncate table in Oracle
- Dynamically Trim Column Values
- sql loader truncate always the first column
- "Truncate" String Column in another column?
- oracle trim data in a table col