i don't want the message as 14 rows updated just it should update what it

i don't want the message as 14 rows updated just it should
update what it will do

Question Posted / arpitha2206

4 Answers
7847 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i don't want the message as 14 rows updated just it should update what it will do..

Answer / ajexpert

You can acheive this by issuing a command
SET FEEDBACK OFF.

Hope this helps

Is This Answer Correct ?

10 Yes

0 No

i don't want the message as 14 rows updated just it should update what it will do..

Answer / suneel

set feedback off;
this will help for u r question

Is This Answer Correct ?

6 Yes

0 No

i don't want the message as 14 rows updated just it should update what it will do..

Answer / vijay sultampur

SET FEEDBACK Off;

example
SQL> SET FEEDBACK Off;
SQL> select * from dual;

D
-
X
SQL> SET FEEDBACK ON;
SQL> /

D
-
X

1 row selected.

Is This Answer Correct ?

2 Yes

0 No

i don't want the message as 14 rows updated just it should update what it will do..

Answer / rajesh kumar gupta

Hi,
If you are faceing this issue with sql SERVER THEN ITS
SOLUTION IS
SET NOCOUNT ON : It avoids to diplay message
SEt nocount off : it allows to display message
suppose:
select * from temp1 (Incase 4 rows are there in the table
temp1)
it will prompt you a message as
(4 Row(s) affected)
if you have used
set nocount on

Is This Answer Correct ?

1 Yes

0 No

Post New Answer