AnithaLetchumi

 Profile Answers by AnithaLetchumi 

• Jul 27th, 2011

 

Hi, I don't think there exists predefined pseudo column for column number in oracle. I have done a procedure, which creates a view for displaying data from Mth to Nth column in a table. Hope it helps.

Code
span style="font-style: italic;">-- USER_TAB_COLUMNS -> contains Columns of user's tables, views and clusters 


-- create a cursor, that has all the column names and it's corresponding column number.


'table_name'-- Fetch the columns that's between the given criteria


','-- Create a view to display the data between the columns.


'CREATE OR REPLACE VIEW myview AS SELECT '' FROM table_name'-------------------------------------------------------------------------------------------------------------------------


-- specify the column numbers to display the data in between.


-------------------------------------------------------------------------------------------------------------------------