There may be other errors in the code - haven't really checked, but you should get my point. Can I extract column data and number of columns and eventually column names in a way something like above?
declare cursor c_pr is select * from a_table; r_pr c_pr%ROWTYPE; begin open c_pr loop fetch c_pr into r_pr; exit when c_pr%NOTFOUND; for i in 1..r_pr.number_of_columns loop DBMS_OUPUT.put(r_pr.column(i)||chr(9)); end loop; DBMS_OUTPUT.put_line(''); end loop; close c_pr; end
|Batch script to move disabled user accounts to different OU||5||63|
|Adjust the position||3||45|
|Is there any way to copy all SSRS reports/datasets/data sources to new server?||3||51|
|simplest php form||3||57|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!