Arranging nos in a serial order

[shivaniem]

I am doing a project in VB6 using oracle 8i i.e SQL plus as backend .
I have created a database with employee addresses.
while adding data through vb it was in a serial order. but in between when i deleted few records and added a new recored, the new record occupied the space of the deleted record. i dont want it in that way.
As when i view the table it is very shabby and confusing and if i want to take a report also the serial nos are not in order.

How to make the nos be in order.
HELP please.

[sandipmohod]

I am doing a project in VB6 using oracle 8i i.e SQL plus as backend .
I have created a database with employee addresses.
while adding data through vb it was in a serial order. but in between when i deleted few records and added a new recored, the new record occupied the space of the deleted record. i dont want it in that way.
As when i view the table it is very shabby and confusing and if i want to take a report also the serial nos are not in order.

How to make the nos be in order.
HELP please.

Hi
are u adding a serial no. field, then use order by serial no.

if not, add a field which will contain the time stamp,
order by this field.

[shivaniem]

Hi
are u adding a serial no. field, then use order by serial no.

if not, add a field which will contain the time stamp,
order by this field.

Can you please tell me the query.

My table name is dummy. its fields are
sno-serial no, name, designation, address,city,state,country,pincode,ph.

I have added and deleted almost 19 addresses.

when i give this query
select sno from dummy order by sno;

The order is in this way
1
10
11
12
13
14
16
17
18
19
2
3
4
5
7
8
9

[pcool911]

convert the serial_no into number datatype "to_number(serial_no)" and then order it

[sandipmohod]

May be the type of the serial no. is playing some trick
go by this

select A.sno,A.name, A.designation, A.address,A.city,A.state,A.country,A.pincode,A.ph
from
(select to_number(trim(sno)),name, designation, address,city,state,country,pincode,ph from tablename) A

order by A.sno

so try this.

Can you please tell me the query.

My table name is dummy. its fields are
sno-serial no, name, designation, address,city,state,country,pincode,ph.

I have added and deleted almost 19 addresses.

when i give this query
select sno from dummy order by sno;

The order is in this way
1
10
11
12
13
14
16
17
18
19
2
3
4
5
7
8
9