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
- 2 Answers
- 7599 Views
- Nucleus Software, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mohanraj
Match Pattern: LIKE
Diff Pattern: NOT LIKE
Except : NOT EQUAL TO (OR) NOT IN
Both : UNION
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
What are the steps to be taken to schedule the report?
What is Array bind size in universe? Plz
How to get top 5 rows of a selected column?
How we can resolve the loops by using the Aggrigate Awareness?
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
What is the difference between slice and dice and cross tab report?
Can more than 1 metric be applied on an analytic in business objects?
Explain the difference between union and group?
how many times can use the union operator in a report?
How will you test a BO report
Once the project is submited to the Client. Client says that report is taking long time to run? Where u need to check?
Can i use personal database connection to the Webintellegence reports?
Teradata 
