oracle_seeker
May 14th, 2006, 12:47 PM
Hi all, new here:)
This is what I need to do. I have a table(say, TEST) in Oracle that contains a column of entries like this:
consnum
K-2-D-10A
K-2-D-10C
K-2-D-10D
K-2-D-10E
K-2-D-10F
K-2-D-10G
K-2-D-11A
K-2-D-11B
K-2-D-12I
K-2-D-12J
K-2-D-12A
K-2-D-12B
K-2-D-12C
K-2-D-12D
K-2-D-12E
K-2-D-12F
K-2-D-12G
K-2-D-12H
K-2-D-13B
K-2-D-13C
K-2-D-14E
K-2-D-14I
K-2-D-14A
K-2-D-14B
K-2-D-14C
K-2-D-14D
K-2-D-14F
K-2-D-14G
K-2-D-14H
K-2-D-14J
K-2-D-14K
K-2-D-15E
K-2-D-15A
K-2-D-15B
K-2-D-15D
K-2-D-16A
K-2-D-16B
K-2-D-16D
K-2-D-16E
K-2-D-17A
K-2-D-17B
K-2-D-17C
K-2-D-17D
K-2-D-17E
K-2-D-17F
K-2-D-17G
K-2-D-17K
K-2-D-18C
K-2-D-18A
K-2-D-19A
K-2-D-19B
K-2-D-1A
K-2-D-1B
K-2-D-1D
K-2-D-2J
K-2-D-2I
K-2-D-20A
K-2-D-20B
K-2-D-21I
K-2-D-21Q
K-2-D-21H
K-2-D-21O
K-2-D-21P
K-2-D-21A
K-2-D-21B
K-2-D-21C
K-2-D-21E
K-2-D-21F
K-2-D-21G
K-2-D-21J
K-2-D-21K
K-2-D-21L
K-2-D-21M
K-2-D-21N
K-2-D-21R
K-2-D-22A
K-2-D-22B
K-2-D-22C
K-2-D-22D
K-2-D-22E
K-2-D-22F
K-2-D-22G
K-2-D-22H
K-2-D-2F
K-2-D-2G
K-2-D-2H
K-2-D-3A
K-2-D-3B
K-2-D-3C
K-2-D-3D
K-2-D-3E
K-2-D-3F
K-2-D-4A
K-2-D-4B
K-2-D-5F
K-2-D-5A
K-2-D-5B
K-2-D-5C
K-2-D-5E
K-2-D-6D
K-2-D-6A
K-2-D-6E
K-2-D-7A
K-2-D-7B
K-2-D-7C
K-2-D-8A
K-2-D-8B
K-2-D-8C
K-2-D-8D
K-2-D-8E
K-2-D-9A
K-2-D-9B
K-2-D-9C
K-2-D-9D
K-2-D-9E
K-2-D-10B
K-2-D-16C
K-2-D-1C
K-2-D-5D
K-2-D-6B
K-2-D-6C
K-2-D-7D
K-2-D-7E
This is how the query output needs to look like after sorting:
consnum
K-2-D-1A
K-2-D-1B
K-2-D-1C
K-2-D-1D
K-2-D-2F
K-2-D-2G
K-2-D-2H
K-2-D-2I
K-2-D-2J
K-2-D-3A
K-2-D-3B
K-2-D-3C
K-2-D-3D
K-2-D-3E
K-2-D-3F
K-2-D-4A
K-2-D-4B
K-2-D-5A
K-2-D-5B
K-2-D-5C
K-2-D-5D
K-2-D-5E
K-2-D-5F
K-2-D-6A
K-2-D-6B
K-2-D-6C
K-2-D-6D
K-2-D-6E
K-2-D-7A
K-2-D-7B
K-2-D-7C
K-2-D-7D
K-2-D-7E
K-2-D-8A
K-2-D-8B
K-2-D-8C
K-2-D-8D
K-2-D-8E
K-2-D-9A
K-2-D-9B
K-2-D-9C
K-2-D-9D
K-2-D-9E
K-2-D-10A
K-2-D-10B
K-2-D-10C
K-2-D-10D
K-2-D-10E
K-2-D-10F
K-2-D-10G
K-2-D-11A
K-2-D-11B
K-2-D-12A
K-2-D-12B
K-2-D-12C
K-2-D-12D
K-2-D-12E
K-2-D-12F
K-2-D-12G
K-2-D-12H
K-2-D-12I
K-2-D-12J
K-2-D-13B
K-2-D-13C
K-2-D-14A
K-2-D-14B
K-2-D-14C
K-2-D-14D
K-2-D-14E
K-2-D-14F
K-2-D-14G
K-2-D-14H
K-2-D-14I
K-2-D-14J
K-2-D-14K
K-2-D-15A
K-2-D-15B
K-2-D-15D
K-2-D-15E
K-2-D-16A
K-2-D-16B
K-2-D16-C
K-2-D-16D
K-2-D-16E
K-2-D-17A
K-2-D-17B
K-2-D-17C
K-2-D-17D
K-2-D-17E
K-2-D-17F
K-2-D-17G
K-2-D-17K
K-2-D-18A
K-2-D-18C
K-2-D-19A
K-2-D-19B
K-2-D-20A
K-2-D-20B
K-2-D-21A
K-2-D-21B
K-2-D-21C
K-2-D-21E
K-2-D-21F
K-2-D-21G
K-2-D-21H
K-2-D-21I
K-2-D-21J
K-2-D-21K
K-2-D-21L
K-2-D-21M
K-2-D-21N
K-2-D-21O
K-2-D-21P
K-2-D-21Q
K-2-D-21R
K-2-D-22A
K-2-D-22B
K-2-D-22C
K-2-D-22D
K-2-D-22E
K-2-D-22F
K-2-D-22G
K-2-D-22H
A simple query like
select consname,consnum from TEST order by consnum
does not seem to work.
I've put spaces before and after the entries that need to be sorted/are sorted.
Any help would be appreciated.Thanks,
oracle_seeker:)
This is what I need to do. I have a table(say, TEST) in Oracle that contains a column of entries like this:
consnum
K-2-D-10A
K-2-D-10C
K-2-D-10D
K-2-D-10E
K-2-D-10F
K-2-D-10G
K-2-D-11A
K-2-D-11B
K-2-D-12I
K-2-D-12J
K-2-D-12A
K-2-D-12B
K-2-D-12C
K-2-D-12D
K-2-D-12E
K-2-D-12F
K-2-D-12G
K-2-D-12H
K-2-D-13B
K-2-D-13C
K-2-D-14E
K-2-D-14I
K-2-D-14A
K-2-D-14B
K-2-D-14C
K-2-D-14D
K-2-D-14F
K-2-D-14G
K-2-D-14H
K-2-D-14J
K-2-D-14K
K-2-D-15E
K-2-D-15A
K-2-D-15B
K-2-D-15D
K-2-D-16A
K-2-D-16B
K-2-D-16D
K-2-D-16E
K-2-D-17A
K-2-D-17B
K-2-D-17C
K-2-D-17D
K-2-D-17E
K-2-D-17F
K-2-D-17G
K-2-D-17K
K-2-D-18C
K-2-D-18A
K-2-D-19A
K-2-D-19B
K-2-D-1A
K-2-D-1B
K-2-D-1D
K-2-D-2J
K-2-D-2I
K-2-D-20A
K-2-D-20B
K-2-D-21I
K-2-D-21Q
K-2-D-21H
K-2-D-21O
K-2-D-21P
K-2-D-21A
K-2-D-21B
K-2-D-21C
K-2-D-21E
K-2-D-21F
K-2-D-21G
K-2-D-21J
K-2-D-21K
K-2-D-21L
K-2-D-21M
K-2-D-21N
K-2-D-21R
K-2-D-22A
K-2-D-22B
K-2-D-22C
K-2-D-22D
K-2-D-22E
K-2-D-22F
K-2-D-22G
K-2-D-22H
K-2-D-2F
K-2-D-2G
K-2-D-2H
K-2-D-3A
K-2-D-3B
K-2-D-3C
K-2-D-3D
K-2-D-3E
K-2-D-3F
K-2-D-4A
K-2-D-4B
K-2-D-5F
K-2-D-5A
K-2-D-5B
K-2-D-5C
K-2-D-5E
K-2-D-6D
K-2-D-6A
K-2-D-6E
K-2-D-7A
K-2-D-7B
K-2-D-7C
K-2-D-8A
K-2-D-8B
K-2-D-8C
K-2-D-8D
K-2-D-8E
K-2-D-9A
K-2-D-9B
K-2-D-9C
K-2-D-9D
K-2-D-9E
K-2-D-10B
K-2-D-16C
K-2-D-1C
K-2-D-5D
K-2-D-6B
K-2-D-6C
K-2-D-7D
K-2-D-7E
This is how the query output needs to look like after sorting:
consnum
K-2-D-1A
K-2-D-1B
K-2-D-1C
K-2-D-1D
K-2-D-2F
K-2-D-2G
K-2-D-2H
K-2-D-2I
K-2-D-2J
K-2-D-3A
K-2-D-3B
K-2-D-3C
K-2-D-3D
K-2-D-3E
K-2-D-3F
K-2-D-4A
K-2-D-4B
K-2-D-5A
K-2-D-5B
K-2-D-5C
K-2-D-5D
K-2-D-5E
K-2-D-5F
K-2-D-6A
K-2-D-6B
K-2-D-6C
K-2-D-6D
K-2-D-6E
K-2-D-7A
K-2-D-7B
K-2-D-7C
K-2-D-7D
K-2-D-7E
K-2-D-8A
K-2-D-8B
K-2-D-8C
K-2-D-8D
K-2-D-8E
K-2-D-9A
K-2-D-9B
K-2-D-9C
K-2-D-9D
K-2-D-9E
K-2-D-10A
K-2-D-10B
K-2-D-10C
K-2-D-10D
K-2-D-10E
K-2-D-10F
K-2-D-10G
K-2-D-11A
K-2-D-11B
K-2-D-12A
K-2-D-12B
K-2-D-12C
K-2-D-12D
K-2-D-12E
K-2-D-12F
K-2-D-12G
K-2-D-12H
K-2-D-12I
K-2-D-12J
K-2-D-13B
K-2-D-13C
K-2-D-14A
K-2-D-14B
K-2-D-14C
K-2-D-14D
K-2-D-14E
K-2-D-14F
K-2-D-14G
K-2-D-14H
K-2-D-14I
K-2-D-14J
K-2-D-14K
K-2-D-15A
K-2-D-15B
K-2-D-15D
K-2-D-15E
K-2-D-16A
K-2-D-16B
K-2-D16-C
K-2-D-16D
K-2-D-16E
K-2-D-17A
K-2-D-17B
K-2-D-17C
K-2-D-17D
K-2-D-17E
K-2-D-17F
K-2-D-17G
K-2-D-17K
K-2-D-18A
K-2-D-18C
K-2-D-19A
K-2-D-19B
K-2-D-20A
K-2-D-20B
K-2-D-21A
K-2-D-21B
K-2-D-21C
K-2-D-21E
K-2-D-21F
K-2-D-21G
K-2-D-21H
K-2-D-21I
K-2-D-21J
K-2-D-21K
K-2-D-21L
K-2-D-21M
K-2-D-21N
K-2-D-21O
K-2-D-21P
K-2-D-21Q
K-2-D-21R
K-2-D-22A
K-2-D-22B
K-2-D-22C
K-2-D-22D
K-2-D-22E
K-2-D-22F
K-2-D-22G
K-2-D-22H
A simple query like
select consname,consnum from TEST order by consnum
does not seem to work.
I've put spaces before and after the entries that need to be sorted/are sorted.
Any help would be appreciated.Thanks,
oracle_seeker:)