SQLPLUS 中的表格输出，在其他行中继续

Question

可以使用sqlplus向我显示查询的表格输出，如下所示：

columnA    columnB    columnC
--------   --------    ----------
is a tr    for me i   do you like
y that     s and ex    these
you hav    ample
e

我

正在尝试使用列，但无论如何我都看不到。谢谢！

Answer 1

列也可以，不是吗？

SQL> column cola format a10
SQL> column colb format a10
SQL> column colc format a10
SQL>
SQL> with test as
  2    (select 'is a try that you have' cola,
  3            'for me is an example'   colb,
  4            'do you like these'      colc
  5     from dual)
  6  select * from test;
COLA       COLB       COLC
---------- ---------- ----------
is a try t for me is  do you lik
hat you ha an example e these
ve

SQL>