Solved

sqlplus environment variables

Posted on 2004-04-29
4
2,667 Views
Last Modified: 2011-10-03
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
Comment
Question by:gla
  • 2
4 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 300 total points
ID: 10950158
If I understand the question:
set feedback off
0
 

Author Comment

by:gla
ID: 10950250
slightwv Yes you understand my question. And I accept you answer!
I am sorry for my english.
0
 
LVL 47

Expert Comment

by:schwertner
ID: 10950269
To see the column headings:


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


0
 
LVL 76

Expert Comment

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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now