![]() ![]() For example, to rename a column labelled LAST_NAME with the heading "Family Name", enter the command: ![]() The SQL*Plus, SQL, and PL/SQL command languages are powerful enough to serve the needs of users with some database experience, yet straightforward enough for new users who are just learning to work with the Oracle Database. You can generate reports dynamically using the HTML output facility of SQL*Plus. You can use SQL*Plus to generate reports interactively, to generate reports as batch processes, and to output the results to text file, to screen, or to HTML file for browsing on the Internet. It enables you to enter and execute SQL, PL/SQL, SQL*Plus and operating system commands to perform the following:įormat, perform calculations on, store, and print from query results SQL*Plus has its own commands and environment, and it provides access to the Oracle Database. See the Oracle Call Interface Programmer's Guide for more information on the OCI Instant Client. SQL*Plus Instant Client connects to any available Oracle database, but does not require its own Oracle database installation. There is also the SQL*Plus Instant Client which is a stand-alone command-line interface available on platforms that support the OCI Instant Client. SQL*Plus is an interactive and batch query tool that is installed with every Oracle Database installation. SQL*Plus on the Oracle Technology Network at. ![]() You can connect to the default database you created during installation, or to another existing Oracle database. These instructions are to enable you to login and connect to a database after you have installed SQL*Plus. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |