Solved

HOWTO: Remove "Rows will be truncated" msg

Posted on 2000-04-24
8
8,374 Views
Last Modified: 2016-09-02
I am selecting from a table with big columns (eg varchar2(2000)).

When there are no recs retrieved, SQL*Plus will echo "Rows will be truncated".

How can I remove that?

Thankyou!
0
Comment
Question by:Judy_M
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 

Expert Comment

by:olka
ID: 2746326
try "set feedback off"
olka
0
 

Expert Comment

by:jacorb
ID: 2746411
you can use 'set long 2000' before selecting from the table.
0
 

Expert Comment

by:wren2000
ID: 2747317
If you are running from a script, I have found that additional blank lines at the end of the script will cause this message. You might try to edit your script and ensure that there are no blank lines at the end of the script.

Good Luck!
Karen.
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

Author Comment

by:Judy_M
ID: 2748253
olka,jacorb,wren2000, thanks for replying.

Set feedback off didn't work.
set long 2000 didn't work.
Keeping file with no trailing blanks didn't work.
0
 
LVL 4

Expert Comment

by:dda
ID: 2748872
What OS are you running SQL*Plus?
What is the Oracle version?
What exactly does it say?
Post "show all" output here (at sqlplus prompt type "show all")
0
 
LVL 1

Accepted Solution

by:
jyhuang earned 50 total points
ID: 2749267
try "set termout off" if you run from a script file.
0
 

Author Comment

by:Judy_M
ID: 2749649
Thanks for the proposal.

But I solved the prob using dda's hint to show all. After set wrap on, the mesg was gone :)
0
 

Expert Comment

by:hemant Khandare
ID: 41781357
Thanks for comments .

I was also stuck dud to this but got resolved after addition of  "set wrap on"  statement in code.

thanks a lot.

Hemant
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

738 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