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
- 8283 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 |
Hi , can anybody explain me what is the need of migration ? and how to do it ? could plz explain me in detail?
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
what happens if cardinalities are not resolved?
Explain in detail about type 1?
what r the types of joins universe supports
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
when will use compatible and incompatible objects?
1 Answers Business Intelligence Analytics, iGate, TCS,
without creating the business view is there possible to create & generate the Crystal reports?
what is the difference between input file repository server and output file repository server ?
what is the difference b/w star and snowflack schema in dataware house?
what is report tracing in bo
How to Avoid the overlaping the blocks in WEBI.
Teradata 
