how can i select range of numbers between two numbers [message #378959] |
Sat, 03 January 2009 03:23  |
balajiags
Messages: 10 Registered: July 2007
|
Junior Member |
|
|
MY table is like
TABLE M_CUG_GROUP
--------------
CUG_CODE CHAR(4),
CUG_GROUP_DESC VARCHAR2(20),
NO_OF_DELS NUMBER(4),
FROM_TEL_NO NUMBER(8),
TO_TEL_NO NUMBER(8),
CRTN_BY VARCHAR2(14) NOT NULL,
CRTN_DT DATE NOT NULL,
MDFD_BY VARCHAR2(14),
MDFD_DT DATE
)
----------------
i want to select all numbers between from_tel_no( 22727500) to_tel_no (22727515) where cug_code=&cug_code
answer should be like this
telephone numbers
---------------
22727500
22727501
22727502
.
.
.
.
.
.
22727515
[EDITED by LF: disabled smilies in this message]
[Updated on: Sat, 03 January 2009 03:56] by Moderator Report message to a moderator
|
|
|
|