Answer / ajexpert

You can acheive this by issuing a command
SET FEEDBACK OFF.

Hope this helps

Answer / suneel

set feedback off;
this will help for u r question

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.

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

What steps server process has to take to execute an update statement?

0 Answers  

---

When you have to use a default "rollback to" savepoint of plvlog?

0 Answers  

---

What are different types of keys?

0 Answers  

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

2 Answers  

---

What is normalization in sql?

0 Answers  

---

What is data abstraction in sql?

0 Answers  

---

Does sql full backup truncate logs?

0 Answers  

---

What is over () in sql?

0 Answers  

---

Are pl sql variables case sensitive?

0 Answers  

---

Is oracle and sql same?

0 Answers  

---

Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')

2 Answers  

---

how to get help information from the server? : Sql dba

0 Answers  

---