如何为oracle中的特定输入选择包含非空值的列名？

SELECT 
  CASE WHEN column1 IS NOT NULL THEN 'column1' 
       WHEN column2 IS NOT NULL THEN 'column2' 
       WHEN column3 IS NOT NULL THEN 'column3' 
       ELSE 'No non-null column found' 
  END AS selected_column
FROM your_table;

CREATE OR REPLACE FUNCTION get_non_null_columns
  RETURN VARCHAR2
IS
  v_columns VARCHAR2(4000);
BEGIN
  FOR c IN (SELECT column_name FROM all_tab_columns WHERE table_name = 'your_table')
  LOOP
    EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM your_table WHERE ' || c.column_name || ' IS NOT NULL' INTO v_count;
    IF v_count > 0 THEN
      v_columns := v_columns || c.column_name || ', ';
    END IF;
  END LOOP;
  
  IF v_columns IS NULL THEN
    v_columns := 'No non-null columns found';
  ELSE
    v_columns := RTRIM(v_columns, ', ');
  END IF;
  
  RETURN v_columns;
END;