如何格式化我的oracle查询，使列不换行? [英] How do I format my oracle queries so the columns don't wrap?

问题描述

我已经尝试过了，但是不起作用:

I've tried this, but it doesn't work:

col * format a20000

我真的必须专门列出每一列吗?这是一个巨大的痛苦.

Do I really have to list every column specifically? That is a huge pain in the arse.

推荐答案

没关系，想通了:

set wrap off
set linesize 3000 -- (or to a sufficiently large value to hold your results page)

我找到的人:

show all

并寻找一些看似相关的选项.

And looking for some option that seemed relevant.

这篇关于如何格式化我的oracle查询，使列不换行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！