How To Run SQL Commands in SQL*Plus

Q

How To Run SQL Commands in SQL*Plus? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool

✍: FYIcenter.com

A

If you want to run a SQL command in SQL*Plus, you need to enter the SQL command in one or more lines and terminated with (;). The tutorial exercise below shows a good example:

SQL> SELECT 'Welcome!' FROM DUAL;

'WELCOME
--------
Welcome!

SQL> SELECT 'Welcome to FYIcenter.com tutorials!'
  2  FROM DUAL
  3  ;

'WELCOMETOFYICENTER.COMTUTORIALS!'
-----------------------------------
Welcome to FYIcenter.com tutorials!

2007-04-29, 5116👍, 0💬

How To Generate Query Output in HTML Format
How To Generate Query Output in HTML Format? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If you want your query output to be generated in HTML format, you can use the "SET MARKUP HTML ON" to turn on the HTML feature. The following tutorial exercise gives you a good example: ... 2007-04-29, 5568👍, 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, 5414👍, 0💬

What To Do If DBA Lost the SYSTEM Password
What To Do If DBA Lost the SYSTEM Password? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If the DBA lost the password of the SYSTEM user account, he/she can go to the Oracle server machine, and run SQL*Plus on server locally with the operating system authentication method to ... 2007-04-28, 5261👍, 0💬

How To Run PL/SQL Statements in SQL*Plus
How To Run PL/SQL Statements in SQL*Plus? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If you want to run a single PL/SQL statement in SQL*Plus, you need to use the EXECUTE command as shown in the following tutorial example: SQL> SET SERVEROUTPUT ON SQL> EXECUTE DBMS_OUTPUT.P... 2007-04-29, 5137👍, 0💬

How To Connect a SQL*Plus Session to an Oracle Server
How To Connect a SQL*Plus Session to an Oracle Server? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool In order to connect a SQL*Plus session to an Oracle server, you need to: 1. Obtain the connection information from the Oracle server DBA. 2. Define a new "connect identifier" c... 2007-04-28, 5120👍, 0💬

How To Run SQL Commands in SQL*Plus
How To Run SQL Commands in SQL*Plus? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If you want to run a SQL command in SQL*Plus, you need to enter the SQL command in one or more lines and terminated with (;). The tutorial exercise below shows a good example: SQL> SELECT 'Welco... 2007-04-29, 5117👍, 0💬

How To Change SQL*Plus System Settings
How To Change SQL*Plus System Settings? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool SQL*Plus environment is controlled a big list of SQL*Plus system settings. You can change them by using the SET command as shown in the following list: SET AUTOCOMMIT OFF - Turns off the auto... 2007-04-29, 5042👍, 0💬

What Are SQL*Plus Environment Variables
What Are SQL*Plus Environment Variables? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool Behaviors of SQL*Plus are also controlled a some environment variables predefined on the local operating system. Here are some commonly used SQL*Plus environment variables: ORACLE_HOME - The... 2007-04-29, 5032👍, 0💬

How To Look at the Current SQL*Plus System Settings
How To Look at the Current SQL*Plus System Settings? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If you want to see the current values of SQL*Plus system settings, you can use the SHOW command as shown in the following tutorial exercise: SQL> SHOW AUTOCOMMIT autocommit OFF S... 2007-04-29, 4978👍, 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.