How to set multiple column widths in a single command in Oracle?

Question

I want to set the width of different columns of a table in a single query but am unable to do so.

I tried the below query but it did not work

column Name format a10, trn_id mail a25 ;

I got an error, missing expression.

How can I do this?

Ben · Accepted Answer · 2012-12-24 08:15:10Z

3

The syntax for COLUMN in SQL*Plus is, to quote from the documentation:

COL[UMN] [{column | expr} [option ...]]

There is no option to perform this on multiple columns, which means your syntax is incorrect. I can only suggest that you list each column separately.

column name format a10
column tm_id format a25

One thing to bear in mind; this is not a query. It is a command to format output only.

answered Dec 24, 2012 at 8:15

Ben

53.1k36 gold badges133 silver badges156 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to set multiple column widths in a single command in Oracle?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related