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

What else can I help you with?

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

Related Questions

What is the difference between sqlplus and sqlserver?

what is the difference between sqlplus and sqlsever SQL*PLUS is oracle command line utility that allows access to Oracle databases sqlserver is a Microsoft RDBMS (database management system), vaguely based on a Sybase RDBMS if you are looking for SQL*PLUS like interface to SQL Server, the one one is SQLS*PLUS from www.memfix.com


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.


What is the difference between T-sql and sql?

T-SQL is Microsoft's version of the generic SQL langauge to be used with, for example, Microsoft SQL Server.


What is the difference between hql and sql?

one of the difference is HQL does not support distinct but SQL supports the distinct in the query


Difference between sql server 2003 sql server 2005?

There is no such thing as SQL Server 2003. Microft released SQL Server 2005 as the next version of SQL Server 2000.


What is the difference between quel SQL and qbe?

gand maro...is the answer


What are the differences between SQL statement to iSQL plus statement?

Structured Query Lanaguage(SQL) is a command language to communicate with oracle server.whereas SQL*PLUS is an oracle tool that recognises and submits sql statements to the oracle server for execution.


Difference between SQL Exception class and SQL Warning class?

sql exception which provides information on database access errors where as sql warning provides inforamation on database access warnings.


Difference between oracle 10g and sql in points?

god only knows


Which date function is used to find the difference between two dates in SQL?

datediff


Difference between SQL plus and ISQL plus?

iSQL*Plus is a browser-based implementation of SQL*Plus. You can use it to connect to an Oracle database system over the Internet to perform the same tasks as those that are performed through the SQL*Plus command line. The iSQL*Plus implementation uses a Web browser, an Oracle HTTP Server with the iSQL*Plus Server, and an Oracle database.


What is the deffrence between sqlserver and sqlplus?

SQL Server is Microsoft's relational database product. SQL*Plus is the command line tool to access Oracle's database product.