Tell me one complex query in oracle ?
Answers were Sorted based on User's Feedback
Answer / prateek
select distinct sal from emp e1 where 3 = (select count(distinct sal) from emp e2 where e1.sal <= e2.sal);
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mahaboob basha
select users.user_id, users.email, max(classified_ads.posted)
from users, classified_ads
where users.user_id = classified_ads.user_id
group by users.user_id, users.email
order by upper(users.email);
| Is This Answer Correct ? | 0 Yes | 4 No |
can u any challenge your project?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is source qualifier transformation?
Define enterprise data warehousing?
Explain direct and indirect flat file loading (source file type) - informatica
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
How to join three sources using joiner? Explain though mapping flow.
Do you have knowledge in ralph kimball methodology
What is hash partition?
What is the difference between stop and abort in informatica
What is an MDDB? What is the difference between MDDBs and RDBMSs?
Target is zero file and how can you send the email?