Re: SQLPLUS question - SQL*Plus: Release 10.2.0.4.0
From: Lyall Barbour <lyallbarbour_at_sanfranmail.com>
Date: Mon, 24 Aug 2009 14:16:34 -0500
Message-Id: <20090824191634.ADC2A1CE833_at_ws1-6.us4.outblaze.com>
it looks like sql*plus is doing exactly what it's supposed to by your example... >.> Can you detail out your problem a little more?Lyall
SYSAUXSQL> select tablespace_name
2
SQL> l
1* select tablespace_name Thanks, Roger Xu
Date: Mon, 24 Aug 2009 14:16:34 -0500
Message-Id: <20090824191634.ADC2A1CE833_at_ws1-6.us4.outblaze.com>
it looks like sql*plus is doing exactly what it's supposed to by your example... >.> Can you detail out your problem a little more?Lyall
- Original Message ----- From: "Roger Xu" To: oracle-l_at_freelists.org Subject: SQLPLUS question - SQL*Plus: Release 10.2.0.4.0 Date: Mon, 24 Aug 2009 14:03:19 -0500
Hi Experts, In my SQL*Plus session, if I press Enter twice, it goes
back to the prompt. How do I change this kind of behavior? SQL>
select tablespace_name
2 from dba_tablespaces
3 where tablespace_name = 'SYSAUX';TABLESPACE_NAME
SYSAUXSQL> select tablespace_name
2
SQL> l
1* select tablespace_name Thanks, Roger Xu
-- Be Yourself _at_ mail.com! Choose From 200+ Email Addresses Get a Free Account at www.mail.com! -- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 24 2009 - 14:16:34 CDT