Swapping tuples using single, simple query

[prabhas]

I want to swap two tuples in a table, using a single , simple query.
No SELECT query allowed, no inner queries allowed.
No PL/SQL allowed.

Do you have any idea how to do this?

e.g. my current data in a table is:
ID - INFO
--- - --------
10 - ten
20 - twenty

after executing the query, contents of table in database should be:
ID - INFO
--- - --------
20 - twenty
10 - ten

Remember, this is to be done using single simple query only.
No PL/SQL blocks.

[Saii]

Can you post your query? Lets try to figure out whatz missing in that, if any.

[debasisdas]

Hi
prabhas
Welcome to TSDN.

You have reached the right place for knowledge shairing.

Here you will find a vast resource of related topics and code.

Feel free to post more doubts/questions in the forum.

But before that give a try from your side and if possible try to post what/how you have approached to solve the problem.

It will help Experts in the forum in solving/underestanding your problem in a better way.

Please follow the posting guidelines in every new post/reply.

[prabhas]

@ all above replies:
Sorry boss, i really don't have any idea.
This question was asked to me by my best friend, and she is not telling me the solution. [she want me to solve this]
but i m unable to solve this one, still fighting.