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
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
what will be the contents for a functional requirements specifications
any difficulitis have you phase while creating bo reports and how did u solve it
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
What are the data types present in bo? What happens if we implement view in the designer and report?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Which versions are used in the bo dashboard work?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain about a task that really tested your analytical abilities?
What is the difference between datawarehousing and businessintelligence?
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...
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
What is object stores?
what is the difference b/w the refresh and buffered data?