Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between sub-query & co-related sub
query?answer ASAP.......
thanks in advance..............Prakash
- 3 Answers
- 20983 Views
- iFlex, Maintec, TCS, I also Faced
- E-Mail Answers
Answer Posted / soujanya
Nesting of queries, one within another, is termed as a Sub-
Query.
A sub query is executed once for the parent statement
whereas the correlated sub query is executed once for each
row of the parent query.
Example
Select deptno, ename, sal from emp a
where sal = (select max(sal) from emp
where deptno = a.deptno)
order by deptno
| Is This Answer Correct ? | 52 Yes | 9 No |
Post New Answer View All Answers
Explain the difference between detect alias and detect context?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
How to execute the plsql procedure from the report by clicking with mouse?
Explain about a tricky situation for which you found a very simple solution?
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
What is the difference between condition & filter?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
any difficulitis have you phase while creating bo reports and how did u solve it
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain difference between zabo and webi?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
how to create reports on screech?
Explain the data types present in bo and what happens if we implement view in the designer and report?
