| khubeb |
Posted: Jul 01, 2008 02:18:56 AM |
Total Post: 107
Joined: Apr, 2007
|
how we remove the first space from column..
A
---
bcd
i want o/p.
A
----
bcd |
|
|
 http://shaharear.blogspot.com |
| Posted: Jul 02, 2008 05:28:59 AM |  |
|
Total Post: 128
Joined: Apr, 2008
|
how we remove the first space from column..
A
---
bcd
i want o/p.
A
----
bcd
update table_name set a='bcd' where a=' bcd';
|
|
|
|
|
| positive |
| Posted: Jul 04, 2008 01:02:57 AM | |
|
Total Post: 483
Joined: Jun, 2008
|
http://neworacledba.blogspot.com/
|
|
|
|
|
| Gitesh |
| Posted: Jul 04, 2008 03:23:07 AM | |
|
Total Post: 322
Joined: May, 2005
|
You should need to set column legnth using col command
col <column_name> for a3
execute your query.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
