sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?
3 10489If we execute an query in MLOAD it's ran successfully, my questions is after successfully ran MLOAD. In error tables we can see anything there! is it possible than what are they?
3 6221Difference between 4.7c and ECC 6.0 in security aspect? I tried in many website but still not able to find the correct one.
2 8714I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
2297I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
6 15457i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80
12 18223different b/w Direct assigment and indirect role in bi security whn will go direct assignment
2 12400Post New CTS Interview Questions
Where to use new keyword other than create instance?
How do you sort data in java?
What is ou? Explain its uses?
hi all can any body explain how to write the script for finding the mandatory fields which are having [red Astrik sign (*)]
How to use like conditions in oracle?
How can looping be done over a list of hosts in a group, inside of a template?
What are Private Mappings?
What is the difference between an hdfs block and input split?
What's the difference between windows 10 and windows 10s?
Why you are selected software testing as career ?
What is sorting php?
Is integer immutable in java?
What is left join and right joins?
What is the difference between per-action and shared?
What is algorithm in c++ programming?