Hello All,
I want to know how to sort ascending or descending varchar values.
This is my field and values
Filling_s_no varchar2;
Table:
Id Filling_s_no name
1 1.1.1 X
1 1.1.10 X
1 1.1.5 X
1 1.1.2 X
1 1.2.1 X
1 1.2.0 X
Now I want to sort my table like this format
Id Filling_s_no name
1 1.1.1 X
1 1.1.2 X
1 1.1.5 X
1 1.1.10 X
1 1.2.0 X
1 1.2.1 X
I tried with this query but am unable get the solution.
select * from TCD_EX_Tab where id=1 order by Filling_s_no ASC;
Can anyone help me?
sasikrishnasamy
0
Newbie Poster
skaa
0
Light Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.