Re: SQL Plus Discontinued?

Ryan wrote:

> "Daniel Morgan" <damorgan_at_exesolutions.com> wrote in message
> news:3EA0A5C3.51526C57_at_exesolutions.com...
> > "Pirvu, Radu" wrote:
> >
> > > Hi,
> > >
> > > Yes, I know what a pundit is. Anyway in our case it would be quite
> difficult
> > > to get someone from within the corporation - not a pundit - to comment
> on it
> > > ;)
> > > Anyway, I asked the question on Metalink, but did not get an answer yet
> :o
> > >
> > > Previously Oracle discontinued the quite reliable installer in text mode
> > > with the silly and buggy GUI runInstaller they are using now, making it
> > > impossible to install the product on a server without X and there can be
> > > added other inconveniences ...
> > >
> > > Not mentioning other hazardous decisions ...
> > >
> > > br
> > >
> > > /radu
> > >
> > > "TurkBear" <john.greco_at_dot.state.mn.us> wrote in message
> > > news:l6l0avo5jv34ebrpqkuca7jgraarhm5ud6_at_4ax.com...
> > > >
> > > > remember a pundit is just someone from out-of town..
> > > >
> > > > Oracle rarely commits commercial suicide and de-supporting a
> command-line
> > > interface language would be just that...
> > > >
> > > >
> > > > "Pirvu, Radu" <radu.pirvu_at_pp.inet.fi> wrote:
> > > >
> > > > >Let's hope so ... That's not what some pundits are saying ...
> > > > >
> > > > >"TurkBear" <john.greco_at_dot.state.mn.us> wrote in message
> > > > >news:utg0avosfjdn177vvg1rbjviavhn5fsnos_at_4ax.com...
> > > > >>
> > > > >> Oracle has stated that the WINDOWS version of SqlPlus (
> sqlplusw.exe
> > > > >recently, plus33w.exe in older versions)
> > > > >> is being supplanted by iSql - so for a GUI interface to SqlPlus (
> not
> > > > >something I find very useful) you will need to go with
> > > > >> iSql ...SqlPLus run from the command line
> > > > >>
> > > > >> sqlplus user/pass_at_tnsnamesalias
> > > > >>
> > > > >> will still and probably always be available...
> > > > >>
> > > > >>
> > > > >>
> > > > >>
> > > > >> "Pirvu, Radu" <radu.pirvu_at_pp.inet.fi> wrote:
> > > > >>
> > > > >> >It cannot be the same thing: 'browser based' means that you need
> to
> > > have
> > > > >a X
> > > > >> >server running.
> > > > >> >
> > > > >> >I used this iSQL plus in 9i and it really sucks :(
> > > > >> >
> > > > >> >
> > > > >> >"Ryan" <rgaffuri_at_cox.net> wrote in message
> > > > >> >news:2%Una.128807$yh1.7622484_at_news1.east.cox.net...
> > > > >> >> there is a browser based SQLPLUS that is going to replace it
> > > according
> > > > >to
> > > > >> >> something I read. its gonna be the same thing.
> > > > >> >> "Pirvu, Radu" <radu.pirvu_at_pp.inet.fi> wrote in message
> > > > >> >> news:OTSna.263$Nb3.188_at_read3.inet.fi...
> > > > >> >> > Hi,
> > > > >> >> >
> > > > >> >> > There is a rumour going around between many people using
> Oracle
> > > that
> > > > >SQL
> > > > >> >> > pLus will be discontinued starting with Oracle 10.
> > > > >> >> >
> > > > >> >> > Can somebody confirm or deny it?
> > > > >> >> >
> > > > >> >> > Anybody does anything more about this subject?
> > > > >> >> >
> > > > >> >> > Many Thanks,
> > > > >> >> >
> > > > >> >> > /radu
> > > > >> >> >
> > > > >> >> >
> > > > >> >>
> > > > >> >>
> > > > >> >
> > > > >>
> > > > >>
> > > > >>
> > > > >> ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet
> > > > >News==----
> > > > >> http://www.newsfeed.com The #1 Newsgroup Service in the World!
> >100,000
> > > > >Newsgroups
> > > > >> ---= 19 East/West-Coast Specialized Servers - Total Privacy via
> > > Encryption
> > > > >=---
> > > > >
> > > >
> > > >
> > > >
> > > > ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet
> > > News==----
> > > > http://www.newsfeed.com The #1 Newsgroup Service in the World!
> >100,000
> > > Newsgroups
> > > > ---= 19 East/West-Coast Specialized Servers - Total Privacy via
> Encryption
> > > =---
> >
> > If you search the archives of the c.d.o. usenet groups for this year on
> google
> > you will find postings from Alison Holloway of Oracle.
> >
> > Alison is the person at Oracle responsible for SQL*Plus and based on her
> > postings, which you can locate and read, and private
> > communications I can state as follows:
> >
> > 1. SQL*Plus Windows is deprecated as of 10i.
> > 2. SQL*Plus command line will remain for all platforms to support users as
> well
> > as Perl, KSH, etc. scripting.
> > 3. isQL*Plus, currently available in 9i will be the standard user
> interface.
> >
> > Daniel Morgan
> >

>

>

iSQL*Plus, as far as I can see, has more functinality than SQLPLUSW.EXE it is replacing.

The command line SQL*Plus can be used for shell scripting by starting it with parameters. This is well documented just about everywhere in the SQL*Plus on-line manuals. Here is a short example I picked up somewhere.

#!/bin/ksh

get_date () {
sqlplus -s << EOF
user/password
select sysdate from dual;
EOF
}

get_date > xxx.txt

Daniel Morgan Received on Sun Apr 20 2003 - 19:36:08 CEST