What is the equivalent oracle operators for following BO
Operators where we use in prompt:
a. Different from pattern b.Match pattern
c. Both and d.Except
Answer Posted / sunder
Except:
(
SELECT DEPT.DEPTNO, DEPT.DNAME, DEPT.LOC, EMP.ENAME
FROM DEPT, EMP
WHERE ( EMP.DEPTNO=DEPT.DEPTNO )
MINUS
SELECT DEPT.DEPTNO,DEPT.DNAME,DEPT.LOC,EMP.ENAME
FROM DEPT,EMP
WHERE ( EMP.DEPTNO=DEPT.DEPTNO )
AND EMP.ENAME = 'JONES')
Both:
(
SELECT DEPT.DEPTNO,DEPT.DNAME,DEPT.LOC,EMP.ENAME
FROM DEPT,EMP
WHERE ( EMP.DEPTNO=DEPT.DEPTNO )
AND EMP.ENAME = 'ADAMS'
INTERSECT
SELECT DEPT.DEPTNO,DEPT.DNAME,DEPT.LOC,EMP.ENAME
FROM DEPT,EMP
WHERE ( EMP.DEPTNO=DEPT.DEPTNO )
AND EMP.ENAME = 'ALLEN'
)
Match Pattern: LIKE “ABC%”
DFFERENT PATTERN: NOT LIKE “ABC%”
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Which versions are used in the bo dashboard work?
Explain when we use aggregate awareness function in designer?
how to create reports on screech?
How can you first report in Business Objects by using broadcast agent?
What is the difference between datawarehousing and businessintelligence?
What is object stores?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
When to use local filter and when to use global filter?
What is the difference between condition & filter?
What is report template in b.o?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
Explain how many universes can be created in a project?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
Explain is there any other repository domains rather than universe, security, document?
What is aggregate table and aggregate fact table ... Any examples of both?