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 sql profiling in oracle?
What is dense_rank?
There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?
Why do we use set serveroutput on?
What is a temporal data type?
What is sql key?
What is sql analyzer?
Why stored procedure is better than query?
What is sqlcontext?
Can I create table without primary key?
what is data manipulation language? : Sql dba
Write the command to remove all players named sachin from the players table.