/SQL/How to increase the width of the screen in oracle

How to increase the width of the screen in oracle

When selecting data from Oracle tables, the default line width can often be shorter than the lines of
data you wish to view. This causes the text to wrap around, making it very hard to read. To avoid
this problem you can change the Oracle default settings to increase the width of the lines, using the
set command.
Eg. At the SQL*Plus command line, type:
set linesize 200 - this will change the line width to 200 characters.
You could try a few different line size settings unitl you find the size that suits you

Similar codes

4 votes229 views1 answer
How to drop a database in sql server when it is in use
SQL
1 vote205 views1 answer
Postgresql datetrunc too slow
SQL
1 vote202 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
0 vote203 views2 answers
How to add CHECK constraint to a column in postgres
SQL
6 votes194 views4 answers
Mysql update set
SQL
0 vote229 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
11 votes180 views1 answer
Oracle view ddl
SQL
1 vote171 views1 answer
Firebase bigquery cloud message
SQL
6 votes194 views2 answers
Mysql interval 1 day
SQL
8 votes180 views3 answers
Alter table auto_increment
SQL