Dynamically display column and data
All,
Please help me.. the following queries..How to display the queries vaules dynamically column and datas...
CREATE TABLE XL_LOAD1( SHEET_NR NUMBER(2), SHEET_NAME VARCHAR2(4000 BYTE), ROW_NR NUMBER(10), COL_NR NUMBER(10), CELL VARCHAR2(100 BYTE), CELL_TYPE VARCHAR2(1 BYTE), STRING_VAL VARCHAR2(4000 BYTE), NUMBER_VAL NUMBER, DATE_VAL DATE, FORMULA VARCHAR2(4000 BYTE));----------------------Insert into XL_LOAD1 (SHEET_NR, SHEET_NAME, ROW_NR, COL_NR, CELL, CELL_TYPE, STRING_VAL) Values (1, 'Bank', 1, 1, 'A1', 'S', 'COMPANY_ID');Insert into XL_LOAD1 (SHEET_NR, SHEET_NAME, ROW_NR, COL_NR, CELL, CELL_TYPE, STRING_VAL) Values (1, 'Bank', 1, 2, 'B1', 'S', 'BANK_CODE');Insert into XL_LOAD1 (SHEET_NR, SHEET_NAME, ROW_NR, COL_NR, CELL, CELL_TYPE, STRING_VAL) Values (1, 'Bank', 1, 3, 'C1', 'S', 'BANK_NAME');Insert into XL_LOAD1 (SHEET_NR, SHEET_NAME, ROW_NR, COL_NR, CELL, CELL_TYPE, STRING_VAL) Values (1, 'Bank', 1, 4, 'D1', 'S', 'AC_NO');Insert into XL_LOAD1 (SHEET_NR, SHEET_NAME,
0