SQL*Plus (MOSC)

MOSC Banner

Remove the null columns in query output

edited May 10, 2012 5:16AM in SQL*Plus (MOSC) 14 commentsAnswered
 Hello,
How can i remove the null columns in query output like ..

 the data in my table is like this 
col1-----col2------col3-----col4-----col5
a--------null-------1-------null------null
b--------w---------2-------null------null
c--------null-------3--------null------null
d--------x---------null------null------null
e--------y---------4--------null------null

here all the data in col4 and col5 is null so i dont want these columns in output
 ( the data may chnage so in future the columns also change)  
i want to extarct data like this 

col1------col2------col3
a---------null--------1
b---------w---------2
c---------null--------3
d---------x----------null
e---------y----------4

Thanks,
Raj

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