| Ramesh Joyisa |
Posted: Aug 10, 2007 07:55:28 AM |
Total Post: 246
Joined: Aug, 2007
|
| Can any one tell is there any possibility to change the column datatype in a View |
|
|
Mohammed Taj |
| Posted: Aug 11, 2007 12:36:42 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
Hi,
No, but why you want to change view datatype.
Regards
Taj
|
|
|
|
|
Garlapati |
| Posted: Aug 12, 2007 09:43:50 AM | |
|
Total Post: 30
Joined: Apr, 2007
|
Hai , View is nothing but logical representation of data from base table we cannot change column's datatype in view
|
|
|
|
|
Ramesh Joyisa |
| Posted: Aug 13, 2007 02:12:28 AM | |
|
Total Post: 246
Joined: Aug, 2007
|
when i use format functions to convert the column the variable type changes
|
|
|
|
|
Ramesh Joyisa |
| Posted: Aug 21, 2007 12:37:53 AM | |
|
Total Post: 246
Joined: Aug, 2007
|
I think we can use CAST for changing datatype of a column right?
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |