• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2676
  • Last Modified:

sqlplus environment variables

I have the following problem

in sqlplus command line I execetute the following

set heading off;

and the system not result to me the column headers;


I dont know the environment variable that not result to me for example "no rows select";


any idea;


George
0
gla
Asked:
gla
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
If I understand the question:
set feedback off
0
 
glaAuthor Commented:
slightwv Yes you understand my question. And I accept you answer!
I am sorry for my english.
0
 
schwertnerCommented:
To see the column headings:


Set linesize 10000
Set pagesize 500
set trimspool on
Set heading on
Set echo on
set underline '-'


0
 
slightwv (䄆 Netminder) Commented:
Never apologize for bad English.  I can guarantee your English is 100% better than my attempt at any other language.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now