SQL*Plus on Windows (Part 1)

Welcome to Part 1 in a series of articles on running SQL*Plus on the Windows platform.

Did you know that SQL*Plus under Windows is often preferred to its Unix equivalent?
There are many ways to configure SQL*Plus to suit your individual needs but today I’ll just cover one option that makes life that little bit easier (at least in my opinion).

Many beginner DBA’s (and some senior ones too!) often overlook the usefulness of a login.sql script.

We all have our favorite editors, I personally still float between Sublime Text and emacs, but the choice is truly down to personal preference. SQL*Plus on Windows defaults to notepad, as do most applications that use a text editor in the Windows environment, and we all know how useful that is; but its old and there are much better editors out there these days.

With a few choice commands and a bit of technical know-how you can change the default editor for SQL*Plus to something more DBA/Developer friendly.

Launch SQL*Plus on Windows from either the gui or a command prompt.

C:\>sqlplus /nolog

This will launch sqlplus.

Type:

ed login

By default This will launch you into notepad.exe and you will be editing a new file named “login.sql”, this file will be located in the directory you launched SQL*Plus from so remember where that was (the easiest way to do this is to create a shortcut to launch SQL*Plus which starts in the same directory every time, but this is something for another article).

Now this is where we define your preferred editor, so in my case, I like Sublime Text, therefore the line for setting my default SQL*Plus editor is as follows:

def _editor = “C:\Program Files\Sublime Text 3\subl.exe”

Editor

Save and close your file, then restart SQL*Plus.

Now when you type “ed” within SQL*Plus you will be thrown into your preferred editor.

This is just one of the changes that can be made in the login.sql; there are lots of others documented in the SQL*Plus reference documentation but this is my favorite change to make when first working on a new Windows environment.

Keep an eye out for further articles in my series on running SQL*Plus on a Windows platform.

Windows 10 – Change the default browser, it’s not difficult!!

You’re talking Rubbish!!!

I thought I’d write this article as I’m amazed at the backlash that Microsoft has been receiving about “How difficult” it is to change the default browser in Windows 10. I’ve never seen, in my opinion, so much poor biased journalism, and no I’m not a Microsoft “Fan Boy”, around a browser setting in an operating system.

I don’t think I’ve ever read an article about Apple shipping Safari as the default browser in OSX or being asked to give users another choice out of the box.

If you don’t like it change it. So with that in mind I thought I’d show you how to do it below. I hope you find this useful and don’t have any problems changing your browser.

How to change your default browser in Windows 10

Here in simple steps, with pictures, is how you change the default apps in Microsoft Windows 10 to something you do like, assuming you have downloaded and installed the software you want to use.

1. First step, using the Windows Menu, go to settings:

Settings Screen

2. Select the System option and you will see the screenshot below.

System Settings

 

3. Select the Default apps option.

Default Apps Option

 

4. Scroll down to the Web Browser (notice you can change other apps in this menu setting)

Web Browser

 

5. Click on the Web Browser and you will be presented with a list of alternatives, assuming you have installed some!

Browser Choices

6. Select the one you want and close the menu, Job Done!

I hope this helps those people out there that appear to be having trouble and shows you just how easy it is. Just because a company changes how a piece of software works doesn’t make it bad, in fact I see it as a sign of progress, and in fact I believe Microsoft have made a huge leap forward with Windows 10, and I hope they continue to innovate.