i don't want the message as 14 rows updated just it should
update what it will do
Answers were Sorted based on User's Feedback
Answer / ajexpert
You can acheive this by issuing a command
SET FEEDBACK OFF.
Hope this helps
Is This Answer Correct ? | 10 Yes | 0 No |
Answer / suneel
set feedback off;
this will help for u r question
Is This Answer Correct ? | 6 Yes | 0 No |
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 |
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 |
how to analyze tables with 'mysqlcheck'? : Sql dba
What is an oracle stored procedure?
Can we write create command in the plsql block?if possible how?
What are data types in pl sql?
How to return an array from java to pl/sql?
how do you login to mysql using unix shell? : Sql dba
what are the different functions in sorting an array? : Sql dba
How do I enable sql encryption?
What does select count (*) mean in sql?
What is trigger in sql?
difference between pl/sql table and normal pl/sql table
What is nosql vs sql?