/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

3 votes178 views1 answer
How to uninstall microsoft sql server
SQL
3 votes165 views1 answer
Make a field auto_increment mysql
SQL
0 vote172 views1 answer
Mysql identified by syntax error
SQL
0 vote165 views1 answer
Like and not like together in sql
SQL
32 votes181 views6 answers
How to change column name in sql
SQL
0 vote235 views1 answer
Oracle convert int to date
SQL
0 vote162 views1 answer
Sql delimiter to columns
SQL
5 votes177 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
2 votes194 views1 answer
Oracle run_duration to number
SQL
8 votes161 views3 answers
Mysql alter table add index
SQL