Hi
I'm using data federator.I would like to know if it allows
select statment in where clause.For example:
SELECT Employee, company, orgunit
FROM TAB_BIG
WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL
WHERE flag = X )
bye
No Answer is Posted For this Question
Be the First to Post Answer
how to solve the incompatible objects and how they are formed actually.
How toconnect one to one report?
what are the disadvantages of alias?
Suppose i have the sinario like this column1: e1,e2,e3,e4 : column2: 1,0,1,0 : column3: M,F,M,F : in this i want to disply 1 is male and 0 is female which is added to the another column like column 4 what is the process?
How to Shedule the reports in Xi R2
Table A, Table B is there, that colums are different like tabl A contian (A varchar(9), B varchar(2), date), table B contian(D varchar(10), E varchar(2), F date) , i want 2 compare mismath datatype length in both table, how? do you know any in built function?
how to improve the performance of the report
how do we apply sql query on selected variables?
where are objects are stored ?
How to display the top 5 records along with the additional records,plus their sub and grand totals to be display in the same block.
what is the necessity of oracle for business objects,why the interview panel is concentrating on oracle very much? Just we need the commands using select,joins? why they r asking about cursors,triggers etc..can any body answer me ..........Thanks in advance prakash
What is the drill up , drill down, drill by , drill trough ?