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
- 5148 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 can I get column names from a table in oracle?
What are the different types of modules in oracle forms?
What is a nvl function?
Explain the use of grant option in exp command.
What would you do with an in-doubt distributed transaction?
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
What does `(+)` do in a where clause?
Display Odd/ Even number of records?
Why cursor variables are easier to use than cursors?
Explain the features of oracle?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Oracle General 
