Setting for default column width?

Hello. Is there in Oracle's tool SQL*Plus a setting that sets all columns to be by default no more than a certain number of characters long? I am aware of the COLUMN command, but that doesn't work very well for me, since it has to be specified for each column of a query. It's really bugging me, 'cause this feature is available in Microsoft's Query Analyzer and it really helps to quickly take a look at a table's data without reading through unreadable wraps.

More explicitly, I would like something that could do this for every column of every result set returned by SQL*Plus: COLUMN COUNTRY_NAME FORMAT A10 Now select data cut off at 10th character, with no wrapping: SET WRAP OFF
SELECT * FROM HR.COUNTRIES; Looking at the first 10 characters of each column would give me a good idea of the data in that row.

vlad Received on Fri Jan 17 2003 - 00:41:32 CST