Is there any query in SQL to select only all the not null columns of a table?

0 ⤊

Is there any query in SQL to select only all the not null columns of a table?

I know only the table name and I want to select the notnull columns in the table.

2007-01-31 14:12:53 · 5 answers · asked by cobra 1 in Computers & Internet ➔ Programming & Design

5 answers

Are you saying that you do not know the column names? If you are you have to go to the data dictionary, in Oracle DBA_TAB_COLUMNS, to find out the column names.
Once you know the column names use
WHERE colname IS NOT NULL.

2007-02-02 03:35:26 · answer #1 · answered by Elizabeth Howard 6 · 0⤊ 1⤋

It has been a while since I did this stuff, but I think this will work.

SELECT *
FROM

Where = not null;

2007-01-31 14:18:29 · answer #2 · answered by Anonymous · 0⤊ 0⤋

SELECT *
FROM

Where IS NOT NULL;

2007-01-31 22:37:54 · answer #3 · answered by Serge M 6 · 0⤊ 0⤋

i think of the least difficult ingredient to do woulb be to union 2 queries into and then do the counts. occasion go with call, count selection(call) from ( go with chief as call from projects union go with assistant as call from projects the place assistant isn't null ) x team by using call

2016-11-23 19:02:01 · answer #4 · answered by artzer 4 · 0⤊ 0⤋

myersram is right but i think some advance is this:

SELECT *
FROM

Where != "";

Best of luck

2007-01-31 18:13:21 · answer #5 · answered by cool _ sim 2 · 0⤊ 0⤋

fedest.com, questions and answers