/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

9 votes211 views6 answers
Sql insert into
SQL
4 votes183 views1 answer
Oracle table statistics last analyzed
SQL
0 vote186 views1 answer
Do postgresql
SQL
0 vote190 views1 answer
Sql server order by nulls last
SQL
2 votes147 views1 answer
Sql group by different columns
SQL
0 vote203 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote188 views1 answer
Selects all the columns from the sailors table
SQL
1 vote196 views2 answers
Begin transaction in sql
SQL
4 votes202 views1 answer
Sql data types
SQL
-1 vote203 views1 answer
Utf8_encode mysql
SQL