Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-07-11 : 11:27:13
|
| Javed writes "Is it possible in Oracle Sql+ to Swap a Column with whole data????" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-07-11 : 15:42:23
|
why would you want to do that ??order of columns is meaningless from the querying point of view.Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-07-11 : 22:02:18
|
if you're using indexes to run through the columns in your apps, avoid doing this because once a column is either removed or added, you'll break your codeit is best (atleast from my point of view) to specify the column names when querying... though I admit, I did that sort of thingie in the past because it was faster and shorter to code  --------------------keeping it simple... |
|
|
|
|
|
|
About Swapping Columns