Interested to Buy Any Domain ? << Click Here >> for more details...
you have two tables table 1 contains emp id,name and deptno
and tble 2 contains only depatment number some of the
depatment no of 1st table are not present in table 2 how
will you create a report only to get the departments of
which excess in table 1
- 4 Answers
- 8082 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / amutha
select empid,name,depno from table1,table2 where table1.deptno=table2.deptno(+)
| Is This Answer Correct ? | 3 Yes | 10 No |
Post New Answer View All Answers
How to restrict password to a user while sending a document in .pdf format
Can we configure two instances of CMS pointing to two different CMS system databases?
Explain what task is 98% of the required work of a business analyst?
Explain how many universes can be created in a project?
Explain about alerts in bos, under what situation we need to use alerts?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
What is the difference between user and versatile user?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Explain how we drill up week to month?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What is difference between custom hierarchy and report based hierarchy?
Explain how to execute the plsql procedure from the report by clicking with mouse?
What is the difference between absolute and relative div positioning?
What is the difference between the public object&schema object?
