Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE global_users (
  "USER" VARCHAR(10),
  status VARCHAR(8),
  description VARCHAR(20),
  updatedGoodsDate TIMESTAMP
)
INSERT INTO global_users ("USER", status, description, updatedGoodsDate)
VALUES ('Alice', 'ACTIVE', 'X', TIMESTAMP '2024-03-10 20:09:53');
1 rows affected

INSERT INTO global_users ("USER", status, description, updatedGoodsDate)
VALUES ('Beryl', 'ACTIVE', 'X', TIMESTAMP '2024-03-10 20:09:53');
1 rows affected

INSERT INTO global_users ("USER", status, description, updatedGoodsDate)
VALUES ('Carol', 'ACTIVE', 'X', TIMESTAMP '2024-03-10 20:09:53');
1 rows affected

INSERT INTO global_users ("USER", status, description, updatedGoodsDate)
VALUES ('Debra', 'ACTIVE', 'X', TIMESTAMP '2024-03-10 20:09:53');
1 rows affected

INSERT INTO global_users ("USER", status, description, updatedGoodsDate)
VALUES ('Emily', 'ACTIVE', 'X', TIMESTAMP '2024-03-10 20:09:53');
1 rows affected

INSERT INTO global_users ("USER", status, description, updatedGoodsDate)
VALUES ('Fiona', 'ACTIVE', 'X', TIMESTAMP '2024-03-10 20:09:53');
1 rows affected

INSERT INTO global_users ("USER", status, description, updatedGoodsDate)
VALUES ('Grace', 'ACTIVE', 'X', TIMESTAMP '2024-03-10 20:09:53');
1 rows affected

INSERT INTO global_users ("USER", status, description, updatedGoodsDate)
VALUES ('Haley', 'ACTIVE', 'X', TIMESTAMP '2024-03-10 20:09:53');
1 rows affected

INSERT INTO global_users ("USER", status, description, updatedGoodsDate)
VALUES ('Irene', 'ACTIVE', 'X', TIMESTAMP '2024-03-10 20:09:53');
1 rows affected

INSERT INTO global_users ("USER", status, description, updatedGoodsDate)
VALUES ('Julie', 'ACTIVE', 'X', TIMESTAMP '2024-03-10 20:09:53');
1 rows affected

INSERT INTO global_users ("USER", status, description, updatedGoodsDate)
VALUES ('Kelly', 'ACTIVE', 'X', TIMESTAMP '2024-03-10 20:09:53');
1 rows affected

INSERT INTO global_users ("USER", status, description, updatedGoodsDate)
VALUES ('Lydia', 'ACTIVE', 'X', TIMESTAMP '2024-03-10 20:09:53');
1 rows affected

INSERT INTO global_users ("USER", status, description, updatedGoodsDate)
VALUES ('Megan', 'ACTIVE', 'X', TIMESTAMP '2024-03-10 20:09:53');
1 rows affected

INSERT INTO global_users ("USER", status, description, updatedGoodsDate)
VALUES ('Naomi', 'ACTIVE', 'X', TIMESTAMP '2024-03-10 20:09:53');
1 rows affected

COMMIT;
SELECT "USER"
FROM   global_users
WHERE  status = 'ACTIVE'
AND    description IS NOT NULL
AND    updatedGoodsDate BETWEEN TIMESTAMP '2024-03-10 20:09:53'
                            AND TIMESTAMP '2024-03-10 20:09:53'
-- ORDER BY something
FETCH FIRST 13 ROWS ONLY


USER


Alice

Beryl

Carol

Debra

Emily

Fiona

Grace

Haley

Irene

Julie

Kelly

Lydia

Megan