Answer / srinivas

select credit_number from table where paid <> 1

[NOTE: Here we can use boolean value to paid field, if paid is success 1 inserted and if not paid then insert 0].

From above query , there is displays credit numbers with never paid.

Answer / anil

select * from TN where bal is not null;
intersect
select * from TN where bal is null;

What is sharded cluster?

0 Answers  

---

Do View contain Data ?

10 Answers  

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---

how do get database name at sql prompt?

3 Answers  

---

when i run my query on yesterday it is fast but today it is slow why?

1 Answers  

---

---

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

0 Answers   Cisco,

---

What are the values that can be specified for OPTIMIZER MODE Parameter ?

1 Answers  

---

What is an oracle wallet?

0 Answers  

---

I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?

2 Answers   Zensar,

---

you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??

2 Answers   BirlaSoft,

---

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

1 Answers   Oracle,

---

How to get maxsal , minsal, ename department wise in single query

0 Answers  

---