SQL Language (MOSC)

MOSC Banner

Dynamically display column and data

edited Aug 15, 2020 3:05AM in SQL Language (MOSC) 3 commentsAnswered

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center