Answer / priyanka

update table1 set seq_no =rownum where 1=1;

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

Answer / manoranan sethy

create sequence s1
start with 1
/
create table t1
(
tid number
);
insert into t1 values (s1.nextval);
insert into t1 values (s1.nextval);
insert into t1 values (s1.nextval);
insert into t1 values (s1.nextval);
insert into t1 values (s1.nextval);

select rownum, tid from t1;

update t1 set tid=6 where rownum=1;


select rownum, tid from t1;

Answer / gourvendra singh

You can update the seqno which is having the rownum=1 only.
for eg:
If you have a table dept in scott user, you can try the
following command:-

update dept
set deptno=90
where rownum=1;

the above will update the record of the table which having
the rownum=1. and if you want to update some other record
then you have to make query to make the required record as
the first record of the table.

What is primary key and unique key?

0 Answers  

---

describe transaction-safe table types in mysql : sql dba

0 Answers  

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

0 Answers  

---

What is oracle sql developer?

0 Answers  

---

explain the difference between delete , truncate and drop commands? : Sql dba

0 Answers  

---

What sql database should I use?

0 Answers  

---

define primary key & secondary key?

2 Answers  

---

what are numeric data types? : Sql dba

0 Answers  

---

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers   CGI,

---

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

---

Mention what are different methods to trace the pl/sql code?

0 Answers  

---

How will you delete a particular row from a Table?

7 Answers   Cap Gemini,

---