What is the Difference between SQL and SQL*Plus?

sql sqlplus
krishna bhargavi picture krishna bhargavi · Jul 3, 2009 · Viewed 40.4k times · Source

What is the Difference between SQL and SQL*Plus?

Answer

Arnkrishn picture Arnkrishn · Jul 3, 2009

SQL* Plus is a command line tool proprietary to Oracle. You can send SQL queries to the server using the tool. It can also help you format the result of a query.

You should get a good head start on SQL*Plus here http://www.comp.nus.edu.sg/~ooibc/courses/sql/sqlplus.htm

SQL is the query language that is used to communicate with Oracle server to access and modify the data.

cheers

Related questions

How do I spool to a CSV formatted file using SQLPLUS?

I want to extract some queries to a CSV output format. Unfortunately, I can't use any fancy SQL client or any language to do it. I must use SQLPLUS. How do I do it?

Read More
Escaping ampersand character in SQL string

I am trying to query a certain row by name in my sql database and it has an ampersand. I tried to set an escape character and then escape the ampersand, but for some reason this isn't working and I'm …

Read More
how to increase sqlplus column output length?

I have some queries to find out the ddl of some objects from a schema. The result columns I am getting are truncated in the middle of the queries. How can I increase the width of the column? I tried …

Read More