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 are different types of indexes?

0 Answers  

explain the advantages and disadvantages of stored procedure? : Sql dba

0 Answers  

Can we use threading in pl/sql?

0 Answers  

explain mysql aggregate functions. : Sql dba

0 Answers  

Is delete faster than truncate?

0 Answers  

why sql is used as interpreter frequently rather than a compile?

1 Answers  

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

What is the clause we need to add in function body to return variable?

0 Answers  

What if we write return in procedure?

0 Answers  

What are types of joins?

0 Answers  

How exception is different from error?

0 Answers  

Can we rollback delete command?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories