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
- 7653 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 |
8. How much supervision have you typically received in your previous job?
Is it possible to join more than one universe in Business Objects? If its so how is that possible ? thanks in advance for the answers
Difference between Decode and Case?
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ? normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
how many reports have u created ? explain a few.
1 Answers InfoStep, Ness Technologies, TCS,
WHAT ARE THE VARIOUS PRODUCTS IN BO?
How toconnect one to one report?
can we cretae views in universe level?
What are the types(Specific Names) of Scheduling in BO?
How the universe is working for fetching data? when it's get connected with db or data source? what is micro cube and when it is created? Is micro cube reside in inside of the universe?
How to particiapte the columns availabe in the Derived tables in the Reporting window? How it's done?
Explain about a tricky situation for which you found a very simple solution?
Teradata 
