By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select @@version;
ORA-00936: missing expression
CREATE TABLE tb (
"S.ID" INTEGER,
"Name" VARCHAR(6),
"Age" INTEGER
);
INSERT INTO tb
("S.ID", "Name", "Age")
VALUES
('1', 'Adam', '21');
1 rows affected
INSERT INTO tb
("S.ID", "Name", "Age")
VALUES
('2', 'Mike', '23');
1 rows affected
INSERT INTO tb
("S.ID", "Name", "Age")
VALUES
('3', 'Daniel', null)
1 rows affected
INSERT INTO tb
("S.ID", "Name", "Age")
VALUES
('4', 'Josh', '');
1 rows affected
SELECT
"Name" || ' (' || "S.ID" || CASE
WHEN "Age" IS NULL OR TRIM("Age")='' THEN ''
ELSE '-' || "Age"
END || ')' as Details
FROM tb
| DETAILS |
|---|
| Adam (1-21) |
| Mike (2-23) |
| Daniel (3) |
| Josh (4) |