Answer Posted / harikanthkoneti

yes...yes........ you can do it simply by updating that
table using rownum yar. see my example below.
SQL> create table test(sno number(2),sname varchar2(20));

Table created.

now if you have the data in the table like follows.

SQL> select * from test;

SNO SNAME
---------- --------------------
1 sdf
3 sdf
6 ewr
7 rt
90 drt

now just do the following simple statement.


SQL> update test set sno=rownum;

5 rows updated.


now here is the o/p for eliminating the gap generated by the
sequence.

SQL> select * from test;

SNO SNAME
---------- --------------------
1 sdf
2 sdf
3 ewr
4 rt
5 drt
then do the commit. thats all....................
now enjoy with this coding


suppose if you want to allocate the with any kind of series
of values for updating the table just follow the below
procedure

SQL> update test set sno=sql.nextval;

NOTE:sql is the sequence.

this statement will updates ur table with
what ever you given with the start with value and it ll
increment by which value you had given in the increment by
clause.

What is a system tablespace and when it is created?

972

---

Is oracle the best database?

964

---

What is dynamic proxy?

1009

---

What is a lookup table in oracle?

973

---

How to initialize variables with default values?

1244

---

What are the predefined tablespaces in a database?

1082

---

How to drop an existing table in oracle?

1058

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2969

---

What are named parameters?

1093

---

query optmization techniques and quwry analyser+projects+ppts

2421

---

How do I uninstall oracle 11g?

1120

---

What is a tns file?

997

---

Which environment variables are absolutely critical in order to run the OUI?

2120

---

What are the differences between primary key and unique key?

1010

---

How to connect to a local oracle 10g xe server?

992

---