|
|
|
Re: Unable to get sql buffer facility [message #659341 is a reply to message #659338] |
Fri, 13 January 2017 02:59 |
|
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
What does not work in your example?
SQL> select *
2 from dept
3 /
DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
4 rows selected.
SQL> list
1 select *
2* from dept
SQL> run
1 select *
2* from dept
DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
4 rows selected.
Do like me, copy and paste your SQL*Plus session.
Before, Please read How to use [code] tags and make your code easier to read.
Also always post your Oracle version, with 4 decimals, as solution depends on it.
[Edit: use a multi-line command.]
[Updated on: Fri, 13 January 2017 03:01] Report message to a moderator
|
|
|
|
|
|
|
|
Re: Unable to get sql buffer facility [message #659347 is a reply to message #659346] |
Fri, 13 January 2017 03:39 |
cookiemonster
Messages: 13925 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
You don't need to activate the buffer, it's always on.
So either:
a) you're doing something wrong
b) your sqlplus install is broken somehow.
If you post your session we may be able to spot if it's (a).
|
|
|
|
|
|
Re: Unable to get sql buffer facility [message #659351 is a reply to message #659350] |
Fri, 13 January 2017 06:07 |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
Did you open a session of sql plus?
have you logged into sql plus?
have you executed a valid sql statement?
did you then issue the 'LIST' command?
All that will be on screen. Use your cursor to select the text, copy it then paste it here.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|