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 |
Which version of sql do I have?
When is the explicit cursor used ?
What is the maximum number of rows in sql table?
How do I view stored procedures?
I have a table .in the table 100 recored is there .we have get the single row with out using clause..
Are sql connections encrypted?
what is global variable in package
Fetch an entire row from the employees table for a specific employee ID:
how to create table with in the procedure or function?
What is pragma in sql?
What is difference between mysql and postgresql?
have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)