1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

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

Question Posted / sathish arichandran

Answers were Sorted based on User's Feedback



What is the equivalent oracle operators for following BO Operators where we use in prompt: a. Diff..

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

What is the equivalent oracle operators for following BO Operators where we use in prompt: a. Diff..

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

Post New Answer

More Business Objects Interview Questions

What is ment by For each For all function. In which case we use the option in BO?

2 Answers   IBM, TCS,

Can anybody explain me the following Authodications? Enterprise,LDAP,Standalone,Windows AD and Windows NT ?

1 Answers  

whats the diff between break and section

4 Answers   TCS,

can any one tell me how to create a new universe from scrach with step by step process.

4 Answers   HCL,

what is projection function in SAP BO

1 Answers   Cap Gemini,




Please Send to my e-mail Interview Questions With Answers , Technical Test Questions With Answers and Code Snippets Of Business Objects - Dev , Business Objects - Reporting Analysis .

3 Answers   AOL,

Example Country Name is like India/UK or ALL In parameter I selected India or UK it should show only perticular country details in BO.If i select ALL in parameter.It should show both country data in different tables.

6 Answers   TCS,

What are the Errors in BO Pls Explain with Examples

2 Answers   iFlex, Tech Mahindra,

how to limit number of rows in a report in business objects using webi?

3 Answers   Cap Gemini, TCS,

what are the day to day activities of BO administrator ?

0 Answers   TCS,

Explain is data mart?

0 Answers  

Hi All, If anyone of you had very Latest & Authentic BUSINESS OBJECTS - XI Certification Dumps for the below Codes, can you please forward it to me, its really very urgent to me SABE 201, SABE 301, SABE 401, SABE 501V3.0 Thanks Mohan

3 Answers  

For more Business Objects Interview Questions Click Here
Categories