Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.
3 9297source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?
4 10332what is the difference between keys.enter and keys.return in selenium? i have used both and both performed enter.
1 6551i want to create a crosstab report where product will be on rows year on column and revenue on measure. based on the users selection in value prompt, if user select the August 15, crosstab year column should display values for aug 15, aug 14, aug 13 and aug 12 i.e for last for years but same month. how could we achieve this?
1 3328What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.
4 7291While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
1825How to you define your goals in life? Do believe in making plans and strategies for the future or believe in grabbing opportunities as they come?
910Mention any three good or bad qualities that your friends would tell us about you. How accurate do you think they are in their observations? (If Yes or No, please explain why.)
938Post New JPMorgan Chase Interview Questions
I want to ensure that once a child record has been added to a master-detail relationship, it cannot be deleted. How can we achieve this using the declarative capability of the platform ?
What is sync in websphere application server?
What is the use of gacutil.exe?
how will you rename a vg?
What are the aggregate objects in the data dictionary? : abap data dictionary
y do v use single anteena in radar any other reason except cost???
How to customize the trace output?
What is the height of ESMA card?
What is the difference between name based and ip based virtual hosting?
Are you willing to work irrespective of your domain and field of expertise?
Explain fault?
explain end to end scenario's for online Money transfer in Banking Domain?
What is intellij?
how would you convert a secondary server into a primary server ?
How do I split an excel spreadsheet into multiple files?