SQL & PL/SQL

1 error has occurred

Your session has timed out.

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to order IP address

cubeguyAug 20 2010 — edited Aug 23 2010

Version 10g

For sample data

	CREATE TABLE IP_ADDRESS
(
  IP_ADDR          VARCHAR2(15)                 PRIMARY KEY,
  IP_STATUS        VARCHAR2(5)                  NOT NULL,
  EQUIPMENT_TYPE   VARCHAR2(20)                 NOT NULL,
  EQUIPMENT_ID     VARCHAR2(20)
  )


Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.154.195', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.154.210', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.154.22', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.154.226', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.154.23', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.154.24', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.154.25', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.154.26', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.154.27', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.154.29', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.154.48', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.154.56', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.154.61', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.154.64', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.154.73', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.155.108', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.155.109', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.155.110', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.155.16', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.155.34', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.155.39', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.155.55', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.155.68', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.155.71', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.155.88', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.158.133', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.171.113', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.182.224', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.187.249', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.187.250', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.187.251', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.187.252', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.187.253', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.187.254', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.191.141', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.191.195', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.191.246', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.191.250', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.10', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.100', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.101', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.102', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.103', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.104', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.105', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.106', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.107', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.108', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.109', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.11', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.110', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.111', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.112', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.113', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.114', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.115', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.116', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.117', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.118', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.119', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.12', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.120', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.121', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.122', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.123', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.124', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.125', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.126', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.127', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.128', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.129', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.13', 'S', 'DSLAM_FTEL', NULL);
Insert into IP_ADDRESS
   (IP_ADDR, IP_STATUS, EQUIPMENT_TYPE, EQUIPMENT_ID)
 Values
   ('172.20.193.130', 'S', 'DSLAM_FTEL', NULL);

and i fire

SELECT IP_ADDR
	FROM Ip_Address
	WHERE Equipment_Type = 'DSLAM_FTEL'
	AND Ip_Status = 'S'
	ORDER BY Ip_Addr ASC;

when i fire the above query the ip_addr are not in order even i apply order by clause.

Could some help me please

This post has been answered by Frank Kulash on Aug 20 2010

Jump to Answer

Processing

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 20 2010

Added on Aug 20 2010

11 comments

2,880 views

SQL & PL/SQL

How to order IP address

Comments

Post Details