Tom, is it possible to create a column alias from a table value?

For example:

Table A below has COL_ID's that don't mean anything, but rather the COL_DESCRIPTIONS do.

COL_ID COL_DESCRIPTION
------ ---------------------------
BD1423 CUSTOMER_FIRST_NAME
BD9721 CUSTONER_LAST_NAME

Table B

BD1423 BD9721
------ ----------------------------
JOHN SMITH
BOB JONES

Table A is set up just to match the COL_ID with the column "name" in Table B in order to get the value of COL_DESCRIPTION to be
used as a column alias.

For Example:

COLUMN ALIAS
(is something like this possible?)
|
|
V
|--------------------------------------------------------|
select B.BD1423 (select A.COL_DESCRIPTION from A where A.COL_ID = "BD1423"), <-- I don't want to hard code to "BD1423" or "BD9721",
B.BD9721 (select A.COL_DESCRIPTION from A where A.COL_ID = "BD9721") do you know what I'm getting at?
from B

Results:

CUSTOMER_FIRST_NAME CUSTOMER_LAST_NAME
------------------- ------------------
JOHN SMITH
BOB JONES

Thanks for any help Tom!

create table cols (
  col_id varchar2(10),
  col_desc varchar2(30)
);

create table t (
  BD1423 varchar2(10),
  BD9721 varchar2(10)
);

insert into cols values ('BD1423', 'FIRST_NAME');
insert into cols values ('BD9721', 'LAST_NAME');

insert into t values ('John', 'Smith');
insert into t values ('Bob', 'Jones');

commit;

set serveroutput on
var c refcursor;

declare
  s varchar2(100);
  type arr is table of varchar2(30) index by varchar2(30);
  col_names arr;
begin
  for cur in (select * from cols) loop
    col_names(cur.col_id) := cur.col_desc;
  end loop;
  
  s := 'select BD1423 as ' || col_names('BD1423') || ', BD9721 as ' || col_names('BD9721') || ' from t';
  
  dbms_output.put_line(s);  
  
  open :c for s;
end;
/

select BD1423 as FIRST_NAME, BD9721 as LAST_NAME from t

print :c;

C
-
FIRST_NAME LAST_NAME  
---------- ---------- 
John       Smith      
Bob        Jones