| 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?
•••••
|
Archives - 2013