Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



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

More SQL PLSQL Interview Questions

Does mysql_real_escape_string prevent sql injection?

0 Answers  


I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

15 Answers   Wipro,


What is embedded sql what are its advantages?

0 Answers  


what is rollback? : Sql dba

0 Answers  


Are stored procedures faster than queries?

0 Answers  


How to write a query to show the details of a student from students table whose

0 Answers  


Is pl sql and postgresql same?

0 Answers  


What is difference between stored function and application function?

0 Answers  


Write a unique difference between a function and a stored procedure.

0 Answers  


Can a table contain multiple primary key’s?

0 Answers  


Explain the uses of a database trigger?

0 Answers  


where are cookies actually stored on the hard disk? : Sql dba

0 Answers  


Categories