need query syntax [message #606412] |
Thu, 23 January 2014 09:11 |
rnemkul
Messages: 35 Registered: February 2006
|
Member |
|
|
i have a table accounts
having field
AC_CODE VARCHAR2(15)
MGR_AC_CODE VARCHAR2(15)
ACTYPE CHAR (1)
which contain data like that
ac_code mgr_ac_code types
1 N
1001 1 N
1001001 1001 N
1001001001 1001001 N
10010010010001 1001001001 T
10010010010002 1001001001 T
I need result like this
10010010010001 1 T
10010010010001 1001 T
10010010010001 1001001 T
10010010010001 1001001001 T
10010010010002 1 T
10010010010002 1001 T
10010010010002 1001001 T
10010010010002 1001001001 T
[Updated on: Thu, 23 January 2014 09:21] Report message to a moderator
|
|
|
|
Re: need query syntax [message #606416 is a reply to message #606412] |
Thu, 23 January 2014 10:13 |
|
Michel Cadot
Messages: 68643 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
What is the relation between input and output?
Post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.
|
|
|