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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

i don't want the message as 14 rows updated just it should
update what it will do

Question Posted / arpitha2206

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

What is sql injection owasp?

0 Answers  

How can you tell the difference between an index and a view?

0 Answers  

Explain the difference between triggers and constraints?

0 Answers  

What is the difference between nvl function, ifnull function, and isnull function?

0 Answers  

Does sql use python?

0 Answers  

The in operator may be used if you know the exact value you want to return for at least one of the columns.

0 Answers  

What is the purpose of primary key?

0 Answers  

What are string functions in sql?

0 Answers  

Can a trigger call a stored procedure?

0 Answers  

what is timestamp in mysql? : Sql dba

0 Answers  

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS

7 Answers   Polaris,

How to use transactions efficiently : transact sql

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories