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
- 5036 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 is procedure overloading in oracle?
How to open and close an explicit cursor in oracle?
what is difference between cartesian join & cross join even they give same result?
How to view the data files in the current database?
How to use "while" statements in oracle?
pls explain connect by prior with example and its real time use
What is rich query?
What are the differences between date and timestamp in oracle?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]
How to convert csv to table in oracle?
How to create a new tablespace in oracle?
Oracle General 
