Re: SQL Plus Question

In article <eGZ17.91570$Md.24836186_at_typhoon.southeast.rr.com>, "Buck says...
>
>Chill, Sybrand.
>

describe now tries to use the entire line.

Your linesize is 1000

Make it smaller, like 80 and try it.

>
>
>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
>>
>>
>>
>>
>
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp