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
- 5229 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 |
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is clusters ?
How to use like conditions in oracle?
How can we find the size of a database?
What is format trigger?
What are the common oracle dba tasks?
How to run the anonymous block again?
what are indexes..how many types of index's are there and what are they?
7 Answers Green Info Solutions, TCS,
How to write a query with a left outer join in oracle?
How to write date and time literals in oracle?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
How to drop a tablespace?
Oracle General 
