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 |
what is normalization? : Sql dba
What is synchronized subquery?
Is sql a backend?
What are the main features of cursor?
What is query execution plan in sql?
What is the differnce between view and materialized view
What are the types of queries in sql?
How to read xml file in oracle pl sql?
What is program debugging?
What packages(if any) has oracle provided for use by developers?
What is duration in sql profiler trace?
Why we use joins in sql?