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;

Describe Referential Integrity ?

1 Answers  

---

How remove data files before opening a database?

0 Answers  

---

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL

1 Answers   TCS,

---

What is oracle used for?

0 Answers  

---

Is there any function in oracle similar like group_concat of mysql?

0 Answers  

---

How to use in conditions in oracle?

0 Answers  

---

What is different bet native dynamic sql and Dbms_Sql?

4 Answers   Thermotech,

---

what is primary key and foreign key when and where have to use

5 Answers  

---

4. Using a set operator, display the creditor number of all creditors who have ever been paid.

2 Answers   Wipro,

---

What are the different types of record groups in oracle? Explain each of them

0 Answers  

---

What is the relationship among database, tablespace and data file?

0 Answers  

---

select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help

6 Answers  

---