Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8044 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 do u mean by merged dimensions in Business Objects
2 Answers Business Intelligence Analytics, TCS,
can anybody tell me about issues faced while creating reports
1 Answers Accenture, Tech Mahindra,
How we drill up week to month?
What is the user Object ? What is the need of it?
could you please give me the diagram of BO 6.5 Architecture or explain about the tires?
Can some one say abt "ALL" in prompt .. How to get the word "ALL" in the prompt along with the list of values? Plz give me the steps?
Pls say any one... how will u create a report using oracle stored procedure? could u pls send me the step.....
HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
date format in report like (22/5/2010 "3:20:15 am") like this i want to remove 3:20:15 remove from report how can we do this in bo xi r2
What are the general issues in migration process?
What is the error that occurs while detecting the cardinalities in the universe pane if we create a join between the normal table and the aggregate table...
Teradata 
