Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

manipulating sqlplus result

Status
Not open for further replies.
lelo25

lelo25

Technical User
Nov 13, 2003
40
LB
Hello,
We are trying to display the following result :

ACCR_DB_C ACCR_CR_C SOLDEGLDB SOLDEGLCR
--------- --------- --------- ---------
000301050 -1.57
000303050 132

this way :

ACCR_DB_C ACCR_CR_C SOLDEGLDB SOLDEGLCR
--------- --------- --------- ---------
000301050 000303050 -1.57 132

it's about getting the balance of 2 different accounts at the same line

Is there any way ?
Please help
RGDS.
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

unixfreak
  • Locked
  • Question
sqlplus backspace through 'screen'
Replies
1
Views
319
Samthyr
Samthyr
mytechreg
  • Locked
  • Question
Run MS SQL stored procedure from Oracle 10g and store result in Oracle 10g table
Replies
10
Views
707
garani
garani
sonofsa
  • Locked
  • Question
Processing a result set output to a Table
Replies
8
Views
248
sonofsa
sonofsa
SDS100UK
  • Locked
  • Question
Inner Join on 3 tables resulting in Cartesian Product 1
Replies
8
Views
402
fredericofonseca
fredericofonseca
cantor001
  • Locked
  • Question
How to create a database object using SQLPlus from the operating system command line 1
Replies
3
Views
492
johnherman
johnherman

Part and Inventory Search

Sponsor

Back
Top