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 Table1 (ID, Value_1) AS
SELECT 11, 'abc' FROM DUAL UNION ALL
SELECT 22, 'def' FROM DUAL UNION ALL
SELECT 33, 'xyz' FROM DUAL;
3 rows affected

CREATE TABLE Table2 (ID, Date_1) AS
SELECT 11, DATE '2022-03-12' FROM DUAL UNION ALL
SELECT 11, DATE '2023-01-01' FROM DUAL UNION ALL
SELECT 22, DATE '2022-12-19' FROM DUAL UNION ALL
SELECT 22, DATE '2023-02-07' FROM DUAL UNION ALL
SELECT 33, DATE '2022-03-07' FROM DUAL;
5 rows affected

CREATE TABLE Table3 (ID, Length_1) AS
SELECT 11,  574 FROM DUAL UNION ALL
SELECT 11, 1029 FROM DUAL UNION ALL
SELECT 22, 9220 FROM DUAL UNION ALL
SELECT 33, 1093 FROM DUAL UNION ALL
SELECT 33,  876 FROM DUAL;
5 rows affected

SELECT t1.id,
       t1.value_1,
       t2.date_1,
       t3.length_1
FROM   table1 t1
       INNER JOIN (
         SELECT id,
                MAX(date_1) AS date_1
         FROM   table2
         GROUP BY id
       ) t2
       ON (t1.id = t2.id)
       INNER JOIN (
         SELECT id,
                MAX(length_1) AS length_1
         FROM   table3
         GROUP BY id
       ) t3
       ON (t1.id = t3.id)


ID
VALUE_1
DATE_1
LENGTH_1


11
abc
2023-01-01 00:00:00
1029

22
def
2023-02-07 00:00:00
9220

33
xyz
2022-03-07 00:00:00
1093


INSERT INTO table_name (value)
  SELECT createNumber(
           LPAD(LEVEL - 1, 44, LEVEL - 1)
         )
  FROM   DUAL
  CONNECT BY LEVEL <= 10;
ORA-00904: "CREATENUMBER": invalid identifier

INSERT INTO table_name (value)
  SELECT createNumber(
           LPAD(CHR(96+LEVEL), 44, CHR(96+LEVEL))
         )
  FROM   DUAL
  CONNECT BY LEVEL <= 6;
ORA-00904: "CREATENUMBER": invalid identifier

SELECT value, DUMP(value, 16) FROM table_name;
ORA-00942: table or view does not exist

ID	VALUE_1	DATE_1	LENGTH_1
11	abc	2023-01-01 00:00:00	1029
22	def	2023-02-07 00:00:00	9220
33	xyz	2022-03-07 00:00:00	1093