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
- 4993 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 |
How to define a procedure inside another procedure?
What is rich query?
How view is different from a table?
I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?
Hi Can any one tell me what are the API's used in requisition import.
Is oracle an open source?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What is a procedure in oracle?
Is insert autocommit in oracle?
What is a Public Synonyms ?
What is save point in oracle database?
which clause we are not used in where clause?
Oracle General 
