Retrieving Columns With Null Values

[SWETHAC]

Hi All

How to retrieve all the null columns in a table using PL/SQL



Thanks in advance
Swetha

[amitpatel66]

Hi All

How to retrieve all the null columns in a table using PL/SQL



Thanks in advance
Swetha

Make use of IS NULL Clause in WHERE condition to retrieve NULL columns from a particular table.

For Eg: SELECT * from <Table_Name> WHERE <Column_Name> IS NULL

You need not require PLSQL block here for this requirement. This can be achieved by a single SQL statement as shown above

[SWETHAC]

hi amit

i tried this but the error message says"column_name" invalid identifire....i have a table with 175 columns and some columns among this is populated with null values.....i need to retrieve the column names which is populated with null data...

thanks
swetha

Make use of IS NULL Clause in WHERE condition to retrieve NULL columns from a particular table.

For Eg: SELECT * from <Table_Name> WHERE <Column_Name> IS NULL

You need not require PLSQL block here for this requirement. This can be achieved by a single SQL statement as shown above

[amitpatel66]

hi amit

i tried this but the error message says"column_name" invalid identifire....i have a table with 175 columns and some columns among this is populated with null values.....i need to retrieve the column names which is populated with null data...

thanks
swetha

Use the below query to get NULL column names of a particular table

select * from ALL_TAB_COLUMNS where table_name = '<table_name>' WHERE nullable = 'Y'
 

[SWETHAC]

hi amit,

Thank u so much...the query is working

regards
swetha

Use the below query to get NULL column names of a particular table

select * from ALL_TAB_COLUMNS where table_name = '<table_name>' WHERE nullable = 'Y'