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
- 7063 Views
- Nucleus Software, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
8. How much supervision have you typically received in your previous job?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
Can anybody tell me what are the tuning problems?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
What is the functional & architectural differences between business objects and web intelligence reports?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
Explain about alerts in bos, under what situation we need to use alerts?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
What is the difference between condition & filter?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Is there any other repository domains rather than universe, security, document?
What is thumbnail?
Give some information on report bursting?
Explain when to use local filter and when to use global filter?
