- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi J-Serge,
Thank you for quick reply.
I created a new column and tried to copy the data from one column to another using decode (Source expression) but getting failed where i have to query it.
Can you please elaborate the step-2 with an example as it will be really helpful.
So if not the case, the directive is:
1. create a new column.
2. copy (insert casting-converting instruction(col2) select col1 SQL query) the current values of col1 casted/converted (using Convert, decode, and all the sql functions depending on your engine) into col2 column
3. suppress the col1 column.
Regards,
Venu
Views
Replies
0 Likes
Total Likes