2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B
2 87063. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);
1 31484. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;
1 2725Post New Fintellix Interview Questions
HOW WE CAN MAKE THE DLIEVERY WHICH IS BLOCKED DUE TO CREDIT LIMIT.
What is the minimum distance to be maintained in between HT panel and LT panel and Instrument panel as per IEC and NEC standards?
Can you write a script to portray how set –x works?
What advice would you give to the customer to avoid bad debt?
How do I select a range of files in windows 10?
how will you check whether software is installed or not?
What are the different types of fits?
What are the advantages of external style sheets?
Tell me what do you mean by custom field in wordpress?
We have a WISPr application making an authentication request to a server running an authentication module. The client application is sending the User--Agent value, but the authentication application logs the User-Agent value as null, please explain the steps i should take to troubleshoot the issue. Please mention the steps by applying your knowledge of the OSI model.
What is meant by a bus?
ratings of lightning arrester
What are the 5 r's of managing behaviors?
Is the cloud connector sufficient to connect the sap cloud platform to an sap abap back end or is sap cloud platform integration needed?
What is jpa and spring data jpa?