answersLogoWhite

0

SQL*PLUS is a interface between user and Oracle database. It Provide an environment to use the SQL which is a query language to communicate with oracle database

User Avatar

Wiki User

12y ago

Still curious? Ask our experts.

Chat with our AI personalities

JordanJordan
Looking for a career mentor? I've seen my fair share of shake-ups.
Chat with Jordan
JudyJudy
Simplicity is my specialty.
Chat with Judy
ViviVivi
Your ride-or-die bestie who's seen you through every high and low.
Chat with Vivi

Add your answer:

Earn +20 pts
Q: Difference between sql and sql plus?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Basic Math

Difference between isql plus and sql plus?

Basically in isql we use browser and we can also use mouse here. But in sql we use terminal where we cannot use the mouse. Commands syntax are different from each other.


Difference between sql function and sql procedure?

Function is must be return the value but procedure cannot be returned, for more information please visit the link : http://youropensource.com


What is the difference between sql and Microsoft Excel?

SQL means Structured Query Language. It is a programming language which is mainly used for maintaining databases. Excel is one of the application developed by Microsoft to do calculations, graphs using spreadsheets.


What are the different sql special operators?

Special operators in sql server in not in between notbetween like not like is null


What is the difference between SQL and SQLPlus?

Structured Query Language, abbreviated as SQL, is a programming language. It is designed to manage data stored in relational databases. Various commands or operations like Select, Group by, Insert, Modify, etc, are implemented using SQL to fetch, retrieve or add data to the database. It can be used in correlation with other programming languages like Python or Java, to build applications. Any tool or application can communicate with the Oracle server using the command language SQL. Oracle SQL has numerous extensions. A SQL statement that you enter is saved in memory's "SQL buffer" and stays there until you write another SQL statement. An Oracle tool called SQLPlus identifies and sends SQL statements to the Oracle9i Server for execution. It has a built-in command language. It is a client program allowing users to enter SQL and PL/SQL commands and execute them. SQLPlus comes with the Oracle installation. It is commonly used to develop and run SQL and PL/SQL statements, scripts, and reports. SQL SQLPLus is a language used to access data from the Oracle server by talking with it. Recognizes SQL statements and sends them to the server Is based on American National Standards Institute (ANSI)-standard SQL Is Oracle's interface for running SQL statements proprietary? manipulates the database's data and table definitions. does not permit changing of database values employs a termination character to carry out directives right away. does not need termination characters and immediately carries out commands. Uses functions to perform some formatting Uses commands to format data