| Author |
Message |
    
420
Bewarse Legend
Username: 420
Post Number: 10940
Registered: 12-2006
Posted From: 82.157.134.169
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 12:05 pm: |
|
Ravanabrahma:biryani adigina kochen ki answer try chesa kani naaku anthaga ardam kaala ela cheyyalo
Bemmi .. why fear . when I am here ..
Knit India,do not split India !
|
Sachinfan
Celebrity Bewarse
Username: Sachinfan
Post Number: 9288
Registered: 10-2010
Posted From: 66.151.103.9
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 11:22 am: |
|
Ravanabrahma:
iyala pivot anedi okati vuntadhi ani telsukunna... |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 15134
Registered: 06-2004
Posted From: 72.129.47.227
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 11:21 am: |
|
Sachinfan:SQL taadu anagane bemmam annai ee anukunetodini innalluMOVIEART--bemmi.adi
biryani adigina kochen ki answer try chesa kani naaku anthaga ardam kaala ela cheyyalo  |
Sachinfan
Celebrity Bewarse
Username: Sachinfan
Post Number: 9285
Registered: 10-2010
Posted From: 66.151.103.9
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 11:15 am: |
|
SQL taadu anagane bemmam annai ee anukunetodini innallu |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 15133
Registered: 06-2004
Posted From: 72.129.47.227
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 11:14 am: |
|
nenu trend set chesa ayithe  |
Sachinfan
Celebrity Bewarse
Username: Sachinfan
Post Number: 9281
Registered: 10-2010
Posted From: 66.151.103.9
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 11:08 am: |
|
Biryani:MOVIEART--bemmi.angry
baa eti gussa ayitannav? |
Biryani
Kurra Bewarse
Username: Biryani
Post Number: 870
Registered: 10-2010
Posted From: 167.121.100.2
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 10:30 am: |
|
420:
thnx annai
Onlymovies:
thanx anani idi kuda try chesi chusthanu |
420
Bewarse Legend
Username: 420
Post Number: 10939
Registered: 12-2006
Posted From: 82.157.134.169
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 10:29 am: |
|
waaakes ..
Knit India,do not split India !
|
Biryani
Kurra Bewarse
Username: Biryani
Post Number: 869
Registered: 10-2010
Posted From: 167.121.100.2
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 10:28 am: |
|
420:
I just used Table 2...but na DB is DB2.
even I used substr and the pivoted |
420
Bewarse Legend
Username: 420
Post Number: 10938
Registered: 12-2006
Posted From: 82.157.134.169
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 10:22 am: |
|
Biryani .. Bedar .. you just need to use only Table2 for your Rock and Roll
Knit India,do not split India !
|
420
Bewarse Legend
Username: 420
Post Number: 10937
Registered: 12-2006
Posted From: 82.157.134.169
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 10:20 am: |
|
select *
from
(
select C2 , substr(C2,0,2) C1 , 'C' || substr(C2,3,1) Col from Table2
)
PIVOT
(
MIN(C2) for COL in ('C1','C2','C3','C4')
)
this is the one liner code you need .. this works in 11G
Knit India,do not split India !
|
Biryani
Kurra Bewarse
Username: Biryani
Post Number: 868
Registered: 10-2010
Posted From: 167.121.100.1
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 10:11 am: |
|
Sachinfan:
 |
Sachinfan
Celebrity Bewarse
Username: Sachinfan
Post Number: 9277
Registered: 10-2010
Posted From: 66.151.103.9
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 10:09 am: |
|
|
Biryani
Kurra Bewarse
Username: Biryani
Post Number: 867
Registered: 10-2010
Posted From: 167.121.100.2
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 10:07 am: |
|
Vachindi second table lo inko column create chesa code vachelaga and then pivot chesa |
Onlymovies
Bewarse Legend
Username: Onlymovies
Post Number: 21005
Registered: 01-2009
Posted From: 199.173.226.229
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 9:56 am: |
|
biryani baa.. check the package that i gave, it might help
Prati malupunu gelichina gurutuga.. Mailu rallapai santakaalu cheyyanaa..
|
Onlymovies
Bewarse Legend
Username: Onlymovies
Post Number: 21004
Registered: 01-2009
Posted From: 199.173.226.229
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 9:56 am: |
|
sqlString := select column2 from table2 where column2 like 'column1%'
execute immediate sqlString BULK COLLECT INTO lFieldVal;
result = column1;
if lFieldVal.first is not null then
for indx in lFieldVal.first..lFieldVal.last LOOP
result := returnString || lFieldVal(indx);
END LOOP;
END IF;
insert into table3 (column3) values (result);
Prati malupunu gelichina gurutuga.. Mailu rallapai santakaalu cheyyanaa..
|
Biryani
Kurra Bewarse
Username: Biryani
Post Number: 866
Registered: 10-2010
Posted From: 167.121.100.1
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 9:52 am: |
|
420:
pivot chesthe second table ki ok but first table lo code kuda ravali kada ? |
420
Bewarse Legend
Username: 420
Post Number: 10936
Registered: 12-2006
Posted From: 82.157.134.169
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 9:51 am: |
|
Bedars .. its a smple Pivot query one liner , I say .. .
Knit India,do not split India !
|
Onlymovies
Bewarse Legend
Username: Onlymovies
Post Number: 21003
Registered: 01-2009
Posted From: 199.173.226.229
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 9:50 am: |
|
Biryani:avunu
i think package raasi, create cheyyachanukunta new table
Prati malupunu gelichina gurutuga.. Mailu rallapai santakaalu cheyyanaa..
|
Biryani
Kurra Bewarse
Username: Biryani
Post Number: 865
Registered: 10-2010
Posted From: 167.121.100.1
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 9:47 am: |
|
Onlymovies:
avunu |
Onlymovies
Bewarse Legend
Username: Onlymovies
Post Number: 21002
Registered: 01-2009
Posted From: 199.173.226.229
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 9:47 am: |
|
Biryani:table 1 lo if you have a code 01 then table 2 will have 4 corresponding values 011,012,013 and 014
so you need all the corresponding codes in a single row?
Prati malupunu gelichina gurutuga.. Mailu rallapai santakaalu cheyyanaa..
|
Biryani
Kurra Bewarse
Username: Biryani
Post Number: 864
Registered: 10-2010
Posted From: 167.121.100.1
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 9:45 am: |
|
420:
annai
table 1 lo if you have a code 01 then table 2 will have 4 corresponding values 011,012,013 and 014
so we need to join table 1 and table 2 such that rows in table 2 corresponding to table 1 needs to be pivoted.
note: table 1 lo codes dont have to be in sequence.
confuse chesana  |
Dobbey
Pilla Bewarse
Username: Dobbey
Post Number: 82
Registered: 03-2011
Posted From: 68.229.32.103
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 9:42 am: |
|
over partition by,rownum to cheyali baa
stewie raasadu monna oka oracle form lo recent ga
choosi ampittad lee inko ganta lo |
420
Bewarse Legend
Username: 420
Post Number: 10935
Registered: 12-2006
Posted From: 82.157.134.169
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 9:38 am: |
|
bedar your question is mixed .. are you looking for a pure cartesian product or a Pivot result .. can you be more specific on the columns in the result ..
then the answer is very very simpulu .
Knit India,do not split India !
|
Biryani
Kurra Bewarse
Username: Biryani
Post Number: 863
Registered: 10-2010
Posted From: 167.121.100.1
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, March 11, 2011 - 9:23 am: |
|
Naku rendu tables vunnayi
Table 1
01
02
.
.
99
Table2
011
012
013
014
021
022
023
024
.
.
.
991
992
993
994
ippudu I want to join these tables resulting the third table
Table 3
01 011 012 013 014
02 021 022 023 024
.
.
.
99 991 992 993 994
ila ravali ela join cheyyali kastha cheppandi |
Archives - 2011