select id,decode(id,'1','3','3','1'

if table named a is there
and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

Question Posted / lokeshwari

Answer Posted / lokeshwari

select id,decode(id,'1','3','3','1','2','4','4','2') from tb11;

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Determine if oracle date is on a weekend?

984

Show the cursor attributes of pl/sql.

998

Enlist some predefined exceptions?

998

What is the sql*loader? : aql loader

1006

What are all the common sql functions?

971

What are local and global Indexes and where they are useful.

1379

What is a full join sql?

983

how do you tune the slow running queries in oracle db , explain the methodology

2072

What does partition by mean in sql?

910

What type of database is cloud sql?

1046

Is sql sequential or random?

983

What is difference between cursor and trigger?

1021

State few characteristics of pl/sql?

931

What does the argument [or replace] do?

1017

How can we link a sql database to an existing android app?

983