Answer / mohanraj

Match Pattern: LIKE
Diff Pattern: NOT LIKE
Except : NOT EQUAL TO (OR) NOT IN
Both : UNION

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%”

what is casual dimension?

1 Answers   CA,

---

could you please give me the diagram of BO 6.5 Architecture or explain about the tires?

6 Answers   PCS, Tech Mahindra,

---

GENARALLY HOW MANY REPORTS ARE CREATE FOR EACH ONE ?PLZ EXPLAIN AFEW FOR AUTOMOBILE PROJECTS?

4 Answers  

---

What is the strategies ? what is the need of the strategies?

2 Answers   IBM,

---

how to improve the performance of the report

3 Answers  

---

---

if we run a report it is taking so much time to display the report,what to do to increase th performance of the report

3 Answers  

---

how do u resolve contexts ?

6 Answers   Wipro,

---

What is meaning of fullpath client in business objects?

1 Answers   Atiric Software,

---

How can you access your repository with different user profiles?

2 Answers   TCS,

---

Is it possible to create a new calendar using BO? Ex:- Wants to create a calendar where the year starts with the 1feb - 25Feb. Next month from 26Feb - 14Mar.

1 Answers  

---

how to create dashboard reports

4 Answers   TCS,

---

Can i merge two dataproviders if they do not have common column?

3 Answers  

---