How to execute SQL using command window in oracle

To execute SQL in the Oracle command window: Open the command window. Connect to the database: connect username/password. Enter the SQL statement and press Enter to execute. View the results. Enter exit to exit the command window.

Execute SQL using Oracle Command Window

To execute SQL using the Oracle command window, perform the following steps:

1. Open the Oracle Command Window

• In Windows: From the Start menu, select All Programs > Oracle - Home Name > Oracle Command Window
• In macOS/Linux: Open the terminal and enter "sqlplus"

2. Connect to the database

• Enter the following command, where "username" is your username and "password" is your password:

   <code class="sql">connect username/password</code>

3. Enter and execute SQL statements

• Enter the SQL statement at the command window prompt. For example, the following statement creates a table called "employees":

   <code class="sql">CREATE TABLE employees (id NUMBER, name VARCHAR2(50), salary NUMBER);</code>

• Press Enter to execute the statement.

4. View the results

• If the statement is executed successfully, the command window will return the result. For example, the following statement will display records in the "employees" table:

   <code class="sql">SELECT * FROM employees;</code>

• Press Enter to display the results.

5. Exit the Oracle Command Window

• Enter the following command to exit the Oracle command window:

   <code class="sql">exit</code>

hint:

• Make sure to connect to the database with the correct username and password.
• SQL statements are case sensitive.
• You can end SQL statements with a semicolon (;), but are not required.
• The command window also supports other commands, such as "desc" for describing the table structure and "set" for changing session settings.

The above is the detailed content of How to execute SQL using command window in oracle. For more information, please follow other related articles on the PHP Chinese website!