What did you try so far?

CREATE OR REPLACE FUNCTION xxc_coluimn
   RETURN VARCHAR2
AS
   v_date   VARCHAR2 (10);
BEGIN
   SELECT TO_CHAR (COLUMN_NAME)
     INTO v_date
     FROM user_tab_columns
    WHERE table_name = 'EMP' 
    AND column_name = 'HIREDATE';
   RETURN v_date;
END;

DECLARE
   v_column   VARCHAR2 (30);
   v_sql      VARCHAR2 (1000);
BEGIN
   SELECT xxc_coluimn (i.HIREDATE)
     INTO v_column
     FROM emp i;
v_sql := 'SELECT '||v_column||' FROM emp '
execute immediate v_sql;
dbms_output.put_line ('column value'||v_sql);
end;

   SELECT TO_CHAR (COLUMN_NAME)
     INTO v_date
     FROM user_tab_columns
    WHERE table_name = 'EMP' 
    AND column_name = 'HIREDATE';

SELECT xxc_coluimn (i.HIREDATE)
     INTO v_column
     FROM emp i;

I am trying to do is need to return that column all the data using dynamic query

What is the input? What is the output? It seems you want all the values of... of what?

Quote:
I am trying to do is need to return that column all the data using dynamic query


Loop on a cursor.

No inputs are there and i need to get all values of hiredate column