| Author |
Message |
oas_public
Joined: 12 Apr 2007
Posts: 2
|
|
 Integration in sqlplus (not sqlplusw) |
 |
Is it possible to integrate into sqlplus?
I mean the commandline version from sqlplusw.
I try it without success.
Regards Dietmar
|
|
| Thu Apr 12, 2007 10:27 am |
  |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
No, it is not possible.
sqlplus is command line tool, not an editor
|
|
| Thu Apr 12, 2007 10:36 am |
|
|
oas_public
Joined: 12 Apr 2007
Posts: 2
|
|
| |
|
Ok thanks.
regards Dietmar
|
|
| Thu Apr 12, 2007 10:42 am |
|
|
jimmyb
Joined: 19 Mar 2010
Posts: 2
Country: United States |
|
| |
|
 |
|
No, it is not possible.
sqlplus is command line tool, not an editor |
sqlplusw is not an editor either; and sqlplusw is no longer distributed with Oracle 11g.
|
|
| Fri Mar 19, 2010 11:36 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
Too bad for Oracle. The majority of Oracle professionals still use it and keep copying it from previous versions. :)
By the way, SQL Assistant does support integration with sqlplusw although with a limited set of functionality.
|
|
| Fri Mar 19, 2010 11:50 pm |
|
|
jimmyb
Joined: 19 Mar 2010
Posts: 2
Country: United States |
|
| |
|
|
|
Too bad for Oracle. The majority of Oracle professionals still use it and keep copying it from previous versions. :)
By the way, SQL Assistant does support integration with sqlplusw although with a limited set of functionality.
|
I think Oracle dropped SQLPLUSW because they want people to use SQL Developer, which is distributed with 11g.
Does SQL Assistant work with Oracle SQL Developer?
|
|
| Sat Mar 20, 2010 12:35 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
No, it does not. SQL Developer is not a Windows application, it is a Java application that doesn't use Windows interface (windows controls, edit boxes, messages) etc... As a result, not cr5oss-application integration, ore extensions is possible.
And you cannot be used to run automated processes on the server side, like nightly batch jobs, nor you can use it to run non-interactive reports and do many other administrative task. . You can schedule automated processes from DBMS_SCHEDULEr, but that is not the same thing, different user accounts, separate maintenance requiring sys admin and dba working together, etc…, the list goes on and on. I don't even list here backward compatibility with billions of existing applications, books, training materials, etc.. most of which refer to sqlplus.
I don't know why Oracle dropped sqlplus in 11g, but from my point of view, that is really silly decision. Maybe they will rethink it in some future maintenance release or version.
|
|
| Sat Mar 20, 2010 9:37 am |
|
|
|
