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

Which version of sql do I have?

0 Answers  


When is the explicit cursor used ?

0 Answers  


What is the maximum number of rows in sql table?

0 Answers  


How do I view stored procedures?

0 Answers  


I have a table .in the table 100 recored is there .we have get the single row with out using clause..

3 Answers  


Are sql connections encrypted?

0 Answers  


what is global variable in package

3 Answers   Polaris,


Fetch an entire row from the employees table for a specific employee ID:

2 Answers  


how to create table with in the procedure or function?

2 Answers   Genpact, HCL,


What is pragma in sql?

0 Answers  


What is difference between mysql and postgresql?

0 Answers  


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.

8 Answers   IBM, Zensar,


Categories