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 73673. 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 24144. 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 1949Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
920HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
979During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
941I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
832
What are the properties of a database?
What is hypermedia database?
What is tkprof and how can we use it?
What is a synonym for manipulation?
What are the various ingredients of sga?
Are null values the same as that of zero or a blank space?
What are bind variables and why are they important?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
How many tables can you join in sql?
what are the differences between require and include, include_once and require_once? : Sql dba
What is microsoft access made up of?
Explain the structure of objectid in mongodb.?
What is the difference between hashed file stage and sequential file stage in relates to datastage server?
What is data modelling in sql?
Can you explain various data region available in ssrs with their use?