1

Topic: To transform a line to a column title

for x in (select t.columns from t)
loop
--Whether it is possible to make that x.columns it was perceived in any way a line, and how a column title?
SELECT MAX (x.columns) from a;
end loop;

2

Re: To transform a line to a column title

javaq;
Only through dynamic SQL

3

Re: To transform a line to a column title

Kind  - Eh;
It is clear... It is possible an example?!

4

Re: To transform a line to a column title

javaq;
Through EXECUTE IMMEDIATE it is impossible

5

Re: To transform a line to a column title

javaq;
Then to begin with show - as did....

6

Re: To transform a line to a column title

Kind  - Eh;
LOOP
IF (x.column_name = ' ALMAZ05 ')
THEN
varch: = ' MAP.VG_MCA_INT. ' || x.columns;
EXECUTE IMMEDIATE ' SELECT MAX (' || varch || ') INTO myvar from MAP.VG_MCA_INT ';
dbms_output.put_line (myvar);
END IF;
end loop;

7

Re: To transform a line to a column title

javaq;
Esteem how to return values from dynamic SQL....