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
- 4984 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How to store only time; not date and time?
What is proxy method?
How to use subqueries with the exists operator in oracle?
Can multiple cursors being opened at the same time?
Explain a synonym?
What are transaction isolation levels supported by oracle?
What do you understand by database schema and what does it hold?
How to best split csv strings in oracle 9i?
How many types of cluster table in Oracle?
How to display row numbers with the records?
How to define a variable of a specific record type?
Which is better Oracle or MS SQL? Why?
What are oracle functions?
How to save query output to a local file?
