Create Table tb_test
(
 Id Number,
 Name Varchar2(64)
);

Create Or Replace View vw_tb_test(l_id,l_name)
As
Select Id,Name From tb_test;

SQL> Select
  2   table_name,
  3   column_name
  4  From dba_tab_columns a
  5  Where table_name='VW_TB_TEST'
  6    Order By column_id;

TABLE_NAME                     COLUMN_NAME
------------------------------ ------------------------------
VW_TB_TEST                     L_ID
VW_TB_TEST                     L_NAME