SQLPlus查看结果返回空行时，显示列标题方法

2023-7-14 14:58

25 字

2 分钟


SQL> select username from dba_users where username='ABC';

no rows selected

SQL> select listagg(username, ',') within group (order by username) username from dba_users where username='ABC';

USERNAME
--------------------------------------------------------------------------------

SQL> col username for a15
SQL> select listagg(username, ',') within group (order by username) username from dba_users where username='ABC';

USERNAME
---------------

SQL> col username for a15
SQL> col default_tablespace for a25
SQL> select listagg(username, ',') username, listagg(default_tablespace, ',') default_tablespace from dba_users where username='ABC';

USERNAME        DEFAULT_TABLESPACE
--------------- -------------------------

SQL>