Need SQL Query: produce output of 100s, 1000s, etc. based on table data

[bharthi]

Hi Everyone,
Here i need your help, and this is my table

CREATE TABLE cont (contnumber VARCHAR2(10), rcptnum NUMBER, rcptamount NUMBER);
 
INSERT INTO cont
            (contnum, rcptnum, rcptamt
            )
     VALUES ('a123', 1, 120
            );
INSERT INTO cont
            (contnum, rcptnum, rcptamt
            )
     VALUES ('a123', 2, 260
            );
INSERT INTO cont
            (contnum, rcptnum, rcptamt
            )
     VALUES ('a123', 3, 300
            );
INSERT INTO cont
            (contnum, rcptnum, rcptamt
            )
     VALUES ('a123', 4, 380
            );
INSERT INTO cont
            (contnum, rcptnum, rcptamt
            )
     VALUES ('q123', 1, 1000
            );
INSERT INTO cont
            (contnum, rcptnum, rcptamt
            )
     VALUES ('q123', 2, 1500
            );
INSERT INTO cont
            (contnum, rcptnum, rcptamt
            )
     VALUES ('q123', 3, 2000
            );
INSERT INTO cont
            (contnum, rcptnum, rcptamt
            )
     VALUES ('q123', 4, 3500
            );
INSERT INTO cont
            (contnum, rcptnum, rcptamt
            )
     VALUES ('z123', 1, 150000
            );
INSERT INTO cont
            (contnum, rcptnum, rcptamt
            )
     VALUES ('z123', 2, 220000
            );
COMMIT ;

I Want The Output In SQL,

    contnumber   rcptamount
     a123         100
     a123         200
     a123         300
     q123         1000
     q123         2000
     q123         3000
     z123         100000
     z123         200000

That mean if 'rcptamount' in 100s, it should show as 100 ,200,300, if rcptamount in 1000s ,
it should show as 1000,2000,3000,if it is in lakhs ,it should be, 100000,200000 .
Please suggest me if there is any way in SQL.
I want like this ,take one 'contnum' for example,

    contnum | rcptnum | rcptamt
    -----------------------------
    a123     | 1      | 120 
    a123     | 2      | 130
    a123     | 3      | 180
 

a123 'Contnum' having Three 'rcptnum' 1,2 and 3. those 'rcptamt' in 100s like 120,130 and 180.
the contnum a123 having rcptamts in 100s,
so i need to display as

contnum | rcptamt
----------------
a123    | 100

Thank You.

[Rabbit]

I don't use oracle but I can give you the algorithm I would use.

1) Convert to a string if necessary. Some SQL engines require this, some do it automatically.

2) Take the first left character.

3) Append zeroes for the length of the string minus one.

4) Take the distinct of the results.