Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8292 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
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
Can we configure two instances of CMS pointing to two different CMS system databases?
Explain about alerts in bos, under what situation we need to use alerts?
Can Bo generates the Report from the cubical data Explain?
What is the difference in creating filters in designer and business objects?
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 ?
how many reports have u created ? explain a few.
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
How to create Index to the table in the universe designer and how it improves the Query performence
what is universe null
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
explain in detail about type 3?
Is there any other repository domains rather than universe, security, document?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
