Hi,
I'm wondering what the difference is if any between SQL Express and SQL Plus. I know SQL Plus is used with Oracle but not sure if SQL Plus is a modification of SQL Express or a totally different installation.
Thanks
A:
Sql Express is the express version of SQL Server. This can be used for development purpose. Sql Plus comes with Oracle. Its a command line tool to run PL/SQL scripts
Amitabh
2010-06-15 20:47:17
I installed Oracle but it didn't automatically install SQL Plus. Is there a way to install it as well when Oracle is installed?
Bruce227
2010-06-15 21:05:56
you can install Sql plus from http://www.oracle.com/technology/tech/oci/instantclient/index.html
Amitabh
2010-06-15 21:15:30
In looking at those installs I read that you have to have the SQL Plus version that matches Oracle. I'm using Oracle v10.20221 but I only found a zip that has the sqlplus.exe not an installation that links it to Oracle.
Bruce227
2010-06-16 00:43:49
Any SQL*Plus client equal to or greater than the database version you're connecting to should work fine.
Jeffrey Kemp
2010-06-16 06:04:16
+1
A:
SQL Plus is the command line interface to an Oracle instance, like SQL Server's SQLCMD.
Both Oracle and SQL Server refer to their free versions as Express.
OMG Ponies
2010-06-15 20:47:54
A:
SQL Plus is a console-like interface that can be used with any Oracle database ("Express" or otherwise). You can use it with Oracle's Express Edition or regular Oracle.
MS SQL Express is analogous to Oracle Express Edition.
I am not sure if there is an analogue to SQL Plus from Microsoft.
FrustratedWithFormsDesigner
2010-06-15 20:48:33