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
- 5230 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
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Explain the use of owner option in exp command.
What is a data lock in oracle?
How to count duplicated values in a column in oracle?
What is an external table?
What is the parameter mode that can be passed to a procedure?
How do we represent comments in oracle?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
How to bring a tablespace offline?
What is max rowid in oracle?
How is it different from a normal table?
Difference between varchar and varchar2 data types?
Differentiate between function and procedure in oracle.
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
