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

What is java oracle used for?

1002

Why is oracle database so popular?

978

What is query image?

964

Can you drop an index associated with a unique or primary key constraint?

999

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

964

What is oracle update statement with inner join ?

1032

what is the difference between functional dependecy and multilevel dependency?

2444

How to declare a local variable?

1095

what's query optimization and without use of IN AND Exist can we get another way data from query

2116

In oracle there is column command, how will you explain that?

1017

List the types of joins used in writing subqueries?

980

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2087

What is a tns file?

976

How to calculate date and time differences in oracle?

1019

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

1533