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

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

Question Posted / anil

Answer Posted / anil

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

Is This Answer Correct ?

2 Yes

6 No

Please Help Members By Posting Answers For Below Questions

How to write date and time literals in oracle?

1043

What is the max number of columns in an oracle table?

1046

How to add a new column to an existing table with a default value?

1056

What is oracle latest version?

1151

How to name query output columns in oracle?

1240

What is meant by an index?

1221

How to estimate disk space needed for an export job?

1105

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2367

What is the difference between translate and replace in oracle?

1216

What is ADDM Advisor in Oracle?

1224

How to check your oracle database 10g xe installation?

1047

How much memory your 10g xe server is using?

1153

What is Virtual Private Database in Oracle?

1150

Which environment variables are absolutely critical in order to run the OUI?

2173

How to rename an index in oracle?

1169