Re: SQL Plus Question

Higher version client against lower version database! What would you expect?
Oracle is downwards compatible meaning you can run a lower version client against a higher version database without any problem, *not* the other way around.
There were problems way back with describe in a 8.0 client against a 7.3.4 database, so this happens all the time.

Regards,

Sybrand Bakker, Senior Oracle DBA

"Buck Turgidson" <jc_va_at_spamisnotcool.hotmail.com> wrote in message news:eGZ17.91570$Md.24836186_at_typhoon.southeast.rr.com...
> Chill, Sybrand.
>
>
>
> SQL*Plus: Release 8.1.7.0.0 - Production on Sun Jul 8 09:49:31 2001
> (NT 4.0 Workstation)
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
> With the Partitioning option
> JServer Release 8.1.6.1.0 - Production
>
>
>
>
>
> SQL> desc dual
> Name
> ---------------------------------------------------------------------
> ------------------------------
> DUMMY
>
>
>
> SQL> desc v$parameter
> Name
> ---------------------------------------------------------------------
> ------------------------------
> NUM
> NAME
> TYPE
> VALUE
> ISDEFAULT
> ISSES_MODIFIABLE
> ISSYS_MODIFIABLE
> ISMODIFIED
> ISADJUSTED
> DESCRIPTION
>
>
>
> SQL> show all
> appinfo is ON and set to "SQL*Plus"
> arraysize 15
> autocommit OFF
> autoprint OFF
> autorecovery OFF
> autotrace OFF
> blockterminator "." (hex 2e)
> btitle OFF and is the first few characters of the next SELECT
> statement
> cmdsep OFF
> colsep " "
> compatibility version NATIVE
> concat "." (hex 2e)
> copycommit 0
> COPYTYPECHECK is ON
> define "&" (hex 26)
> describe DEPTH 1 LINENUM OFF INDENT ON
> markup HTML OFF SPOOL OFF ENTMAP ON PREFORMAT OFF
> echo OFF
> editfile "afiedt.buf"
> embedded OFF
> escape OFF
> feedback OFF
> flagger OFF
> flush ON
> heading ON
> headsep "|" (hex 7c)
> instance "local"
> linesize 1000
> lno 5
> loboffset 1
> logsource ""
> long 80
> longchunksize 80
> newpage 1
> null ""
> numformat ""
> numwidth 10
> pagesize 14
> PAUSE is OFF
> pno 1
> recsep WRAP
> recsepchar " " (hex 20)
> release 801060100
> repfooter OFF and is NULL
> repheader OFF and is NULL
> serveroutput ON size 1000000 format WORD_WRAPPED
> shiftinout INVISIBLE
> showmode OFF
> spool OFF
> sqlblanklines OFF
> sqlcase MIXED
> sqlcode 0
> sqlcontinue "> "
> sqlnumber ON
> sqlprefix "#" (hex 23)
> sqlprompt "SQL> "
> sqlterminator ";" (hex 3b)
> suffix "sql"
> tab ON
> termout ON
> time OFF
> timing OFF
> trimout ON
> trimspool ON
> ttitle OFF and is the first few characters of the next SELECT
> statement
> underline "-" (hex 2d)
> USER is "SYSADM"
> verify ON
> wrap : lines will be wrapped
> SQL>
>
>
>
>
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:tkgmu4okh52hff_at_beta-news.demon.nl...
> >
> > "Buck Turgidson" <jc_va_at_spamisnotcool.hotmail.com> wrote in message
> > news:4lW17.91342$Md.24657494_at_typhoon.southeast.rr.com...
> > > This seems like a dumb question, but I can't get this to work.
 Under
> > > the old version of SQL Plus for Windows on 7.3, when you ran a
 query,
> > > you would get a dialog box with a "Cancel" button. So if a query
 of
> > > update hung, you could just cancel. In the 8i client version, I
 don't
> > > get a dialog box, and the menus aren't active during a query. So
 if I
> > > have a runaway query, I have to kill the SQL Plus session.
> > >
> > > One other irritation is doing a describe. In 7.3, it would return
 

> > > column names and the data types and whether it was null. Now, I
 just
> > > get back the columns. I cannot find any settings to change this.
> > >
> > > Any help on this would be appreciated.
> > >
> > >
> >
> > As usual in this group this is a post which lacks one important
 thing: an
> > *exact* specification of platform and version, other than just *8i*
> > I can't seem to understand why it is so difficult to type three
 digits and
> > two dots, and why this group is expected either to keep track of
 what
> > everyone is running, or this *guess* what someone is running
> > This is important as I can't seem to reproduce the behavior
 described in the
> > second question on Personal Oracle 8.1.5 for win 98.
> > As to your first question: whenever you set the pagesize to
 something very
> > high or zero, the cancel button will not appear anymore.
> >
> > Hth,
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> >
> >
> >
>
>
Received on Sun Jul 08 2001 - 10:21:31 CDT