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
- 5085 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 privilege is needed for a user to connect to oracle server?
How to compare dates in oracle sql?
How can we view last record added to a table?
Give the various exception types.
What is an oracle transaction?
How to drop a tablespace?
Use of an integrity constraint is better to validate data. Explain
Explain drop constraint oracle?
What are the various oracle database objects?
State all possible different index configurations a table can possibly have?
What is the difference between formal parameters and actual parameters?
What is a database table in oracle?
How to convert times to characters in oracle?
How to work with data objects interactively?
Differentiate between pre-select and pre-query?
