oracle select all column multi table star
oracle table dot star
oracle table star
You can use syntax like
SELECT A.Column1, A.Column2 , B.* FROM TableXXX1 B
LEFT JOIN TableXXX2 A
ON B.Column1 = A.Column1
AND B.Coliumn2 = A.Column2
Also see this reference article:
https://oracletutorial.net/oracle-select-all-columns.html