| Garlapati |
Posted: Nov 27, 2007 08:35:00 AM |
Total Post: 30
Joined: Apr, 2007
|
Hai I have a problem here
I had a table with Cuid Custmem
A1 AA
A2 BB
A3 CC
i want to display that data like there rows power theree
like permutations 2 power 3
2*2*2=8 combination from that table
EX
A1AA
A1BB
A1CC
A2AA
A2BB
A2CC
A3AA
A3BB
A3CC
AAA1
BBA2
plz reply this it is very urget
thanq |
|
|
 Murtuja |
| Posted: Nov 28, 2007 12:38:51 AM |  |
|
Total Post: 857
Joined: Jan, 2006
|
create table perm (c1 varchar2(2),c2 varchar2(2))
insert into perm values ('A1', 'AA')
insert into perm values ('A2' ,'BB')
insert into perm values ('A3' ,'CC')
select * from perm
select a.c1,b.c2 from perm a,perm b
order by 1,2
So when you are going to start work by yourself ??
|
|
|
|
|
| Garlapati |
| Posted: Nov 28, 2007 01:25:36 AM | |
|
Total Post: 30
Joined: Apr, 2007
|
hai Manuj thaq very much for u r reaply and it is good
but i want to retrive data dynamically from table
if my table have only two columns but if it increase i want to display data dynamically when it is changed. with combinations of rows
ex : col1 col2 col3
1 2 3
4 5 6
i want to display my data like combination of
1 2 3
1 3 2
2 1 3
2 2 3
3 1 2
|
|
|
|
|
| Garlapati |
| Posted: Nov 28, 2007 05:33:22 AM | |
|
Total Post: 30
Joined: Apr, 2007
|
hai i want to retrive data like if i have 2 columns with C1,C2
and it contains 3 rows like a a1
b b1
c c1
it is 3 power 3 =27 times with combination of all the rows dynamically if rows increased then i have display like 1strow power 2nd row=result
plz send it is very urgent
thanq
|
|
|
|
|
| Murtuja |
| Posted: Nov 28, 2007 07:26:20 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
select a.c1,b.c2 from perm a,perm b,perm c
order by 1,2
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
