why do you have such a need? of course you can do it like these guys said. but, if you only need to change the order of a table then try

set order to yourOrder in youCursor