/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

-1 vote154 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote197 views1 answer
Mysql update table from select on another table
SQL
0 vote189 views1 answer
Setval postgres example table id
SQL
1 vote188 views1 answer
Sql server cast date dd/mm/yyyy
SQL
16 votes195 views4 answers
Sort by sql
SQL
61 votes308 views6 answers
Mysql add column
SQL
5 votes202 views1 answer
Sql table columns
SQL
1 vote191 views1 answer
Give a column name to values generated from case statement in sql
SQL
0 vote197 views1 answer
Sql pad left 0
SQL
0 vote183 views10 answers
John the ripper mysql
SQL