oracle select all column multi table star

  • 21
  • 0

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