How To Start the Command-Line SQL*Plus

Q

How To Start the Command-Line SQL*Plus? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool

✍: FYIcenter.com

A

If you Oracle server or client installed on your windows system, you can start the command-line SQL*Plus in two ways:

1. Click Start > All Programs > Oracle ... > Start SQL Command Line. The SQL*Plus command window will show up with a message like this:

SQL*Plus: Release 10.2.0.1.0 - Production on Tue ...

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL>

2. Click Start > Run..., enter "cmd" and click OK. A Windows command window will show up. You can then use Windows commands to start the command-line SQL*Plus as shown in the tutorial exercise below:

>cd c:\oraclexe\app\oracle\product\10.2.0\server\
>.\bin\sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Tue ...

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL>

2007-04-28, 5166👍, 0💬

How To Run Stored Procedures in Debug Mode
How To Run Stored Procedures in Debug Mode? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If have an existing stored procedure and you want to debug it interactively, you can use the debug feature provided in SQL Developer. The following exercise shows you how to start the debug mode: Open... 2007-04-28, 8307👍, 0💬

How To Set Up Breakpoints in Debug Mode
How To Set Up Breakpoints in Debug Mode? - Oracle DBA FAQ - Introduction to Oracle SQL Developer To debug a stored procedure, you need to set breakpoints at different statements in the code block, so that execution will be stopped at the statement marked with a breakpoint. When execution is stopped,... 2007-04-28, 8249👍, 0💬

How To Assign Debug Privileges to a User
How To Assign Debug Privileges to a User? - Oracle DBA FAQ - Introduction to Oracle SQL Developer In order to run SQL Developer in debug mode, the session must be connected with a user who has debug privileges. The following script shows you how to assign debug privileges: Connect to the default dat... 2007-04-28, 7404👍, 0💬

What Is a Connect Identifier
What Is a Connect Identifier? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool A "connect identifier" is an identification string of a single set of connection information to a specific target database instance on a specific Oracle server. Connect identifiers are defined and stor... 2007-04-28, 5880👍, 0💬

What Is SQL*Plus
What Is SQL*Plus? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool SQL*Plus is an interactive and batch query tool that is installed with every Oracle Database Server or Client installation. It has a command-line user interface, a Windows Graphical User Interface (GUI) and the iS... 2007-04-28, 5492👍, 0💬

What Happens If You Use a Wrong Connect Identifier
What Happens If You Use a Wrong Connect Identifier? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool Of course, you will get an error, if you use a wrong connect identifier. Here is an example of how SQL*Plus react to a wrong connect identifier: SQL> CONNECT fyi/retneciyf@WRONG; ... 2007-04-28, 5401👍, 0💬

What Do You Think about Oracle SQL Developer
What Do You Think about Oracle SQL Developer? - Oracle DBA FAQ - Introduction to Oracle SQL Developer To conclude this introductory FAQ collection, you should think about Oracle SQL Developer in comparison with other client tools like SQL*Plus and Oracle Web interface. SQL Developer is definitely be... 2007-04-28, 5181👍, 0💬

How To Start the Command-Line SQL*Plus
How To Start the Command-Line SQL*Plus? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If you Oracle server or client installed on your windows system, you can start the command-line SQL*Plus in two ways: 1. Click Start > All Programs > Oracle ... > Start SQL Command Line. The ... 2007-04-28, 5167👍, 0💬

How To Get Help at the SQL Prompt
How To Get Help at the SQL Prompt? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool Once SQL*Plus is started, you will get a SQL prompt like this: SQL>. This where you can enter commands for SQL*Plus to run. To get help information at the SQL prompt, you can use the HELP c... 2007-04-28, 5151👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.