update emp_test a set empno=7469 where (select empno from (select rownum r

Write one update command to update seqno field of a table
on the basis of row number.

Question Posted / rk

Answer Posted / rk

update emp_test a set empno=7469 where (select empno from
(select rownum r,empno from emp_test) where r=6 )=a.empno

use seqno in place of empno

Is This Answer Correct ?

5 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the current version of sql?

1005

what are the differences between char and nchar? : Sql dba

1097

What is a variable in sql?

981

What is the difference between a procedure and a function?

1084

How many types of literals are available in pl sql?

1099

Determine if oracle date is on a weekend?

1026

What is cartesian join in sql?

1097

How to rename a table?

998

How can you save or place your msg in a table?

986

What mean sql?

992

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1022

Is primary key an index?

985

How can I change database name in sql?

1051

Can you load data into multiple tables at once? : aql loader

1056

Explain what is sql?

1097