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
- 4998 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
How would you begin to troubleshoot an ORA-3113 error?
What is a select query statement in oracle?
What's dateware house and what's clustor with practicle example
What is oracle rowcount?
Explain an exception and its types?
Are truncate and delete commands same? If so why?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What is the difference between view and materialized view in Oracle?
Difference between pre-select and pre-query
How to install oracle odbc drivers?
What is the data pump import utility?
What privilege is needed for a user to delete rows from tables in another schema?
How to connect to the server with user account: sys?
Explain how are indexes update?
What is the maximum number of triggers that can be applied to a single table?
