SQL*Plus is the interactive (low-level) user interface to the Oracle database management system. SQL*Plus is used to issue ad-hoc queries and to view the query result on the screen. Some of the features of SQL*Plus are:
• A built-in command line editor can be used to edit (incorrect) SQL queries. Instead of this line
editor any editor installed on the computer can be invoked.
• There are numerous commands to format the output of a query.
• SQL*Plus provides an online-help.
• Query results can be stored in files which then can be printed.
editor any editor installed on the computer can be invoked.
• There are numerous commands to format the output of a query.
• SQL*Plus provides an online-help.
• Query results can be stored in files which then can be printed.
Queries that are frequently issued can be saved to a file and invoked later. Queries can be parameterized such that it is possible to invoke a saved query with a parameter.
No comments:
Post a Comment