Interested to Buy Any Domain ? << Click Here >> for more details...
4. Using a set operator, display the creditor number of all
creditors who have ever been paid.
- 2 Answers
- 5151 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
What are the differences between char and nchar in oracle?
What is the database name in oracle?
How to handle a single quote in oracle sql?
what is the dual table in oracle?
What is columnar storage what is the advantage?
what is primary key and foreign key when and where have to use
How do we switch from init.ora file to asp file?
How to estimate disk space needed for an export job?
How to create a table in a specific tablespace?
how to handle exceptions in post production
What is STATSPACK tool?
How to name query output columns in oracle?
Oracle General 
