SQL*PLUS Introduction - Using a Special Character in Windows

To check if a font contains a particular character, for example, the Euro sign, enter the character's decimal number equivalent in the SQL*Plus command-line interface. For example, the decimal number equivalent for the Euro sign is 128, so you would enter Alt+0128 (hold Alt while pressing 0, 1, 2 and 8 in the numeric keypad) to display it. If it appears correctly, the font contains the Euro sign, otherwise you need to try another font.

You can use the Windows Character Map utility to view the characters available in a font. Character Map also shows the decimal number equivalent for extended ASCII characters. You access the Character Map utility by selecting Start, Programs, Accessories and then clicking Character Map.

SQL*PLUS Introduction Continued (Using the Mouse to copy text to the command prompt)

1. Right click on the command prompt.
2. Select Mark.
3. Left Click from the mouse and drag on the text you want to copy.
4. Right click from the mouse where you want to paste.

SQL*PLUS Introduction

SQL*Plus (or sqlplus) is a command prompt tool used to write SQL queries or PL/SQL blocks.
The editor seems like:


The window of sqlplus can be opened by either of the following ways:
1. Type cmd in run window of Windows. After opening it, type sqlplus.
2. Type sqlplus in run window of Windows.

When SQL*Plus starts, it displays before SQL*Plus starts:

1. The Date and Time
2. The SQL*PLUS version
3. Copyright information

The default prompt for SQL*Plus is:

SQL>