Author |
Message |
Dobbey
Mudiripoyina Bewarse Username: Dobbey
Post Number: 18116 Registered: 12-2009 Posted From: 198.228.228.167
Rating: N/A Votes: 0 (Vote!) | Posted on Tuesday, October 15, 2013 - 10:41 pm: |
|
Poddunne choosi chepthaa
|
Vusirikai
Yavvanam Kaatesina Bewarse Username: Vusirikai
Post Number: 8597 Registered: 10-2011 Posted From: 50.90.225.255
Rating: N/A Votes: 0 (Vote!) | Posted on Tuesday, October 15, 2013 - 10:39 pm: |
|
} Dobbey:
nee pindakoodura... Ne pindakoodu .. Select distinct manufacture||manfpartno from (select rpad(manufacture:'||vendorname,35,'') as manufacture ,rpad('mfrpartno:'||pryvebdor item,35,'') as manfpartno from supplier_v where business type ='manyufacture') a Ela ithey Emi vasthunde ... My 2 cents http://www.cooking-wonders.com/
|
Dobbey
Mudiripoyina Bewarse Username: Dobbey
Post Number: 18115 Registered: 12-2009 Posted From: 198.228.228.163
Rating: N/A Votes: 0 (Vote!) | Posted on Tuesday, October 15, 2013 - 10:13 pm: |
|
Asala naa query lo sub query ekkadundi
|
Vusirikai
Yavvanam Kaatesina Bewarse Username: Vusirikai
Post Number: 8596 Registered: 10-2011 Posted From: 50.90.225.255
Rating: N/A Votes: 0 (Vote!) | Posted on Tuesday, October 15, 2013 - 10:06 pm: |
|
Sub query lo symbol_of_king cheppindhe unchi.. Select lo concat cheyyi .. Select concat from (sub query) a Work avada? http://www.cooking-wonders.com/
|
Dobbey
Mudiripoyina Bewarse Username: Dobbey
Post Number: 18114 Registered: 12-2009 Posted From: 66.61.63.62
Rating: N/A Votes: 0 (Vote!) | Posted on Tuesday, October 15, 2013 - 10:02 pm: |
|
Gochi:
yaa
|
Gochi
Censor Bewarse Username: Gochi
Post Number: 81230 Registered: 07-2004 Posted From: 24.229.136.147
Rating: N/A Votes: 0 (Vote!) | Posted on Tuesday, October 15, 2013 - 9:57 pm: |
|
Em database dobbey baa...oracle aa.. |
Dobbey
Mudiripoyina Bewarse Username: Dobbey
Post Number: 18113 Registered: 12-2009 Posted From: 66.61.63.62
Rating: N/A Votes: 0 (Vote!) | Posted on Tuesday, October 15, 2013 - 9:48 pm: |
|
no bro.. i have to concat both columns and return as single string...second column for all the rows should start from same position..
|
Symbol_of_king
Kurra Bewarse Username: Symbol_of_king
Post Number: 2135 Registered: 12-2005 Posted From: 72.209.237.135
Rating: N/A Votes: 0 (Vote!) | Posted on Tuesday, October 15, 2013 - 9:45 pm: |
|
select distinct rpad('Manufacturer: '||vendor_name,35),rpad('Mfr Part No : '||primary_vendor_item,35) from PO_ASL_SUPPLIERS_V WHERE LOWER (vendor_business_type) = 'manufacturer' this is same as you provided...it should work |
Dobbey
Mudiripoyina Bewarse Username: Dobbey
Post Number: 18112 Registered: 12-2009 Posted From: 66.61.63.62
Rating: N/A Votes: 0 (Vote!) | Posted on Tuesday, October 15, 2013 - 9:17 pm: |
|
select distinct rpad('Manufacturer: '||vendor_name,35,' ') ||rpad('Mfr Part No : '|| primary_vendor_item,35,' ')||chr(10) from PO_ASL_SUPPLIERS_V WHERE LOWER (vendor_business_type) = 'manufacturer' ee query vadathanna.. first column , second column ki rpad chesi concat chestanna.. illa vasthandi result.. http://i44.tinypic.com/anzl7d.png second column fixed position nunchi start cheyadaniki emanna kuduruthundaaa?
|