Database

SELECT COL1, NVL2(NEXT_COL1, COL1 || '--' || (NEXT_COL1 - 1), NULL) COL2 
FROM (
  SELECT COL1
        ,LEAD(COL1, 1, NULL) OVER (ORDER BY COL1) AS NEXT_COL1 
    FROM (SELECT LEVEL*5 COL1 FROM DUAL CONNECT BY LEVEL < 5) 
  )
;

COL1	COL2
5	5--9
10	10--14
15	15--19
20	NULL

V. wrote:

A second lesson (still under development) would be coding against databases (creating a connection, SQL injection, ...)

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

ven753 wrote:

What could be the problem.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

aman wangde wrote:

The workflow is the data form nas,ftp,airbox

aman wangde wrote:

then it flow towards workstation is it possible ?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

DECLARE @FieldValue varchar(100);
SELECT @FieldValue = AffectedField FROM AffectedTable WHERE Key = @AffectedKey;

WITH E1(N) AS
(
    SELECT 1 
    UNION ALL SELECT 1 
    UNION ALL SELECT 1 
    UNION ALL SELECT 1
    UNION ALL SELECT 1 
    UNION ALL SELECT 1
    UNION ALL SELECT 1 
    UNION ALL SELECT 1 
    UNION ALL SELECT 1
    UNION ALL SELECT 1
),
cteNumbers (N) As
(
    SELECT
        ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) 
    FROM 
        E1 a, E1 b -- Cross-join = 100 rows
)
SELECT TOP(LEN(@FieldValue))
    N,
    Ascii(Substring(@FieldValue, N, 1)) As AsciiCode,
    Substring(@FieldValue, N, 1) As Character
FROM
    cteNumbers
ORDER BY
    N
;