| Author | Message | ||
     Kdnumber1 Side Hero Username: Kdnumber1 Post Number: 4649 Registered: 02-2009 Posted From: 76.24.180.51 Rating: N/A |
Reply ichina andariki Thanks......ma mgr ki kudaradu nuvvu report la adugutnnav ani cheppa...he satisfied | ||
| Maverick Hero Username: Maverick Post Number: 12715 Registered: 01-2008 Posted From: 192.146.101.71 Rating: N/A |
may not be the best..but works create or replace FUNCTION rowtranspose( p_in_stmt IN VARCHAR2, p_dlmtr IN VARCHAR2 DEFAULT ',' ) RETURN VARCHAR2 AUTHID CURRENT_USER AS TYPE c_refcur IS REF CURSOR; out_str VARCHAR2(4000); out_colval VARCHAR2(4000); c_dummy c_refcur; BEGIN OPEN c_dummy FOR p_in_stmt; LOOP FETCH c_dummy INTO out_colval; EXIT WHEN c_dummy%NOTFOUND; out_str := out_str || p_dlmtr || out_colval; END LOOP; CLOSE c_dummy; RETURN SUBSTR(out_str,2); EXCEPTION WHEN OTHERS THEN out_str := SQLERRM; IF c_dummy%ISOPEN THEN CLOSE c_dummy; END IF; RETURN out_str; END; Create the above function and then fire this sql SELECT distinct rowtranspose('SELECT DESCRIPTION FROM TABLE2') FROM DUAL UNION ALL select column1 ||','|| column2 ||','|| column3 FROM TABLE1; | ||
| Maharshi Junior Artist Username: Maharshi Post Number: 701 Registered: 02-2008 Posted From: 76.124.134.5 Rating: N/A |
idi konchem explan cheyi ..exact ga ela kavalao , danni batti cheppachu | ||
| Maverick Hero Username: Maverick Post Number: 12714 Registered: 01-2008 Posted From: 192.146.101.71 Rating: N/A |
is it for display or extracting data? second case aite, dump to 2 files..append the second one | ||
| Life_sucks Comedian Username: Life_sucks Post Number: 1469 Registered: 05-2008 Posted From: 148.168.40.4 Rating: N/A |
t1 metadata techukunte column headers vasthayi. tharvatha T2 rows ki map cheyyi. | ||
| Maharshi Junior Artist Username: Maharshi Post Number: 700 Registered: 02-2008 Posted From: 76.124.134.5 Rating: N/A |
Select col1 as 'SNO', Col2 as 'Name', Col3 as 'Sex' from T1 | ||
| Venkateswarlu Junior Artist Username: Venkateswarlu Post Number: 352 Registered: 01-2010 Posted From: 162.116.29.69 Rating: N/A |
I use Proc Sql in SAS .. To get heading, I use label statement.. Proc sql; create table T as select col1 label='SNO', col2 label='Name' from t1 ; quit; In this db, there's always someone watching you!!  | ||
| Kdnumber1 Side Hero Username: Kdnumber1 Post Number: 4648 Registered: 02-2009 Posted From: 65.120.124.222 Rating: N/A |
i hv 1 table t1(col1,col2,col3) 2nd table t2(colName,description), denilo rows like col1 - SNo col2 - Name col3 - Sex ippudu t1 nundi rows select chesukunte SNo, Name, Sex ani row headings ravali etta?? |
