4. Using a set operator, display the creditor number of all
creditors who have ever been paid.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / anil
select * from TN where bal is not null;
intersect
select * from TN where bal is null;
Is This Answer Correct ? | 2 Yes | 6 No |
how to find full database size
1 Answers BirlaSoft, Consultancy,
Can Multiple instances be run on Single Machine???
Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??
Can a formula column referred to columns in higher group ?
How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?
What is data file?
ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?
How to load data through external tables?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
What is a dynamic performance view in oracle?
What are the four Oracle system processes that must always be up and running for the database to be useable?
What is a select query statement in oracle?