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 73933. 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 24284. 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 1966Post New Fintellix SQL PLSQL Interview Questions
What are lazy/deferred loading and eager loading?
Is use case diagram static or dynamic?
What is the purpose of 'register' keyword?
What are the benefits of using css?
Explain replication factor (rf)?
give me the code to save all messages of inbox of gmail into a folder and notepad
i finished my B.sc garment production and chemical processing .now i am pursuing mba finance.suppose if interviewer asks me why did u study mba finance after ur B.Sc, what to answer.
write an interactive C program that will encode or decode a line of text.To encode a line of text,proceed as follows. 1.convert each character,including blank spaces,to its ASCII equivalent. 2.Generate a positive random integer.add this integer to the ASCII equivalent of each character.The same random integer will be used for the entire line of text. 3.Suppose that N1 represents the lowest permissible value in the ASCII code,and N2 represents the highest permissible value.If the number obtained in step 2 above(i.e.,the original ASCII equivalent plus the random integer)exceeds N2,then subtract the largest possible multiple of N2 from this number,and add the remainder to N1.Hence the encoded number will always fall between N1 and N2,and will therefore always represent some ASCII character. 4.Dislay the characters that correspond to the encoded ASCII values. The procedure is reversed when decoding a line of text.Be certain,however,that the same random number is used in decodingas was used in encoding.
What are routines in datastage? Enlist various types of routines.
Explain the contract review process followed in your project?
What are the two virtual tables available at the time of database trigger execution?
What are the advantages of gto over scr?
What is the difference between abstract & interface?
What is the difference between internet and isdn?
What billing models are supported on BlackBerry App World?