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 can I create database in oracle?

958

Explain overloading. Can functions be overloaded?

934

Explain user account with reference to oracle.

926

How to define and use table alias names in oracle?

882

Is the After report trigger fired if the report execution fails ?

2876

How to rename a tablespace in oracle?

1032

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2292

What is logical backup in oracle?

966

What is oracle analytical function?

1028

How many file formats are supported to export data?

1135

How to assign data of the deleted row to variables?

1012

Give the constructs of a package, function or a procedure.

981

What is Trigger in Oracle?

1073

Please explain joins in oracle?

1007

What are the different types of trigger and explain its various uses and functions?

1007