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



4. Using a set operator, display the creditor number of all creditors who have ever been paid...

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

4. Using a set operator, display the creditor number of all creditors who have ever been paid...

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

Post New Answer

More Oracle General Interview Questions

how to find full database size

1 Answers   BirlaSoft, Consultancy,


Can Multiple instances be run on Single Machine???

3 Answers  


Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??

1 Answers   BirlaSoft,


Can a formula column referred to columns in higher group ?

0 Answers   Oracle,


How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?

1 Answers   IBM,






What is data file?

0 Answers  


ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?

4 Answers  


How to load data through external tables?

0 Answers  


What view(s) do you use to associate a users SQLPLUS session with his o/s process?

0 Answers  


What is a dynamic performance view in oracle?

0 Answers  


What are the four Oracle system processes that must always be up and running for the database to be useable?

0 Answers  


What is a select query statement in oracle?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)