Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 / swastik


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

Answer / lokeshwari

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

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

How can I delete duplicate rows?

0 Answers  

What is function and procedure in pl sql?

0 Answers  

What does cursor do in sql?

0 Answers  

What plvcmt and plvrb does in pl/sql?

0 Answers  

How does sql developer connect to oracle database?

0 Answers  




What is nested table in pl sql?

0 Answers  

What are the syntax and use of the coalesce function?

0 Answers  

What are different types of refreshment techniques of materialised view

2 Answers  

Give the structure of the procedure ?

1 Answers  

What are the different ddl commands in sql?

0 Answers  

What is sql in java?

0 Answers  

What are user defined stored procedures ?

3 Answers   BirlaSoft,

For more SQL PLSQL Interview Questions Click Here
Categories