4. Using a set operator, display the creditor number of all
creditors who have ever been paid.
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
Difference between varchar and varchar2 data types?
How to define an oracle sub procedure?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What are the ways tablespaces can be managed and how do they differ?
How to use "while" statements in oracle?
Explain the difference between sql and oracle?
What are the built-in functions used for sending Parameters to forms ?
How to define a data field as not null?
What is a trigger oracle?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
Which are the five query types available in oracle?
How to store only time; not date and time?
What is a table in oracle?
How to convert csv to table in oracle?
What is meant by a deadlock situation?