Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

a table has 2 classifications
1)liabilities
2)earnings
this liabitity has 2 elements with 2 input values
and
the earnings have 2 elements with 2 input values
i wrote a query so that my input is
liability savings amount1 amount2
xxxx null xxxxxx 0
xxx1 null xxxxx1 0
null yyyy 0 yyyy
null yyy1 0 yyy1
my problem is
--when i developed a report(d2k) with this data
my o/p is
liabilities,amount1,savings,amount2
xxxx xxxxxx
xxx1 xxxxx1
yyyy yyyy
yyy1 yyy1
how could i move this savings,savings values 2 palces up.
can any body provide me witha better solution

Question Posted / guest

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

What are the possible values for the boolean data field?

0 Answers  

What is trigger in pl sql with examples?

0 Answers  

Can procedure in a package be overloaded?

1 Answers   HCL,

overloading of stored procedure is possible in oracle?

3 Answers   Nelco,

What are packages in pl sql and also explain its advantages?

0 Answers  

table - new_no old_no 2345 1234 3456 2345 5678 4567 output sud be -new_no 1234 2345 3456 4567 5678

2 Answers  

What is nvl function?

4 Answers   Cap Gemini,

What is forward declaration in pl sql?

0 Answers  

what the meaning of sql

8 Answers  

How do we tune the code?

2 Answers  

Why do we need view in sql?

0 Answers  

what are the limitations of identity column? : Transact sql

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories