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

2 Answers
5143 Views
Wipro, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the types of exception?

1147

How to create a table interactively?

1097

What are the parameters that we can pass through a stored procedure?

1069

How to connect ms access to oracle servers?

1011

What is a dead lock in oracle?

1128

What is a table in oracle?

985

What are the ways tablespaces can be managed and how do they differ?

2373

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2119

How to write a left outer join with the where clause in oracle?

1086

What is set verify off in oracle?

1107

How many memory layers are in the oracle shared pool?

1188

What are the different windows events activated at runtime ?

2902

What do you mean by a database transaction & what all tcl statements are available in oracle?

994

What is connection pool in oracle?

991

How do I know if oracle is installed on windows?

931