Thursday, September 15, 2005

What all new Oracle users should know about SQL Plus

Ok, I realize anyone who’s used oracle much will already know this, but I still get asked this question a lot. Usually it's from people who know SQL, but haven't worked a lot with Oracle.

If you are using SQL Plus with Oracle, you may be surprised by the odd way it displays results. This is because by default SQL Plus assumes your screen is only 80 characters wide, and 14 rows tall, and wraps accordingly.

You can fix this by entering the following in SQL Plus:
set pagesize 50000 
set linesize 32767

By default those values are 14 and 80 respectively. 32767 is the maximum size for linesize and 50000 is the maximum size for pagesize.

Tuesday, September 06, 2005

The Register printed my letter

He he, it's not much, but hey, The Register, my favorite IT news site printed my letter. Just search for Aric on this page: Letters Page