SQL & PL/SQL

Hi, guys.

Could you please help me to resolve the following problem:i have the following input table

WITH input_table
AS
  (
    select 1 A, 2 B, 3 C from dual
    union all
    select 4, 5, 6 from dual
    union all
    select 7, 8, 9 from dual
  )
SELECT *
FROM input_table;

I need to receive the following table using ONLY sql syntax (without any procedures):

WITH result_table
AS
  (
    select 7 A, 4 B, 1 C from dual
    union all
    select 8, 5, 2 from dual
    union all
    select 9, 6, 3 from dual
  )
SELECT *
FROM result_table;

Wait for your suggestons. Thanks.

Victor