title image


Smiley Re: welche Spalten sin NULL
Hi,



ist einfach ein simples SQL:

select * from tab where col1 is null or col2 is null or col3 is null ...



Das ganze kann man natürlich noch verfeinern:

select nvl(col1,'Ist NULL'),nvl(col2,'Ist NULL')... where col1 is null or col2 is null...



Dim



Zitat Tom Kyte:
I have a simple philosophy when it comes to the Oracle Database: you can treat it as a black box and just stick data into it, or you can understand how it works and exploit it as a powerful computing environment.

OTN's "Greatest Hits" CD

SQL-Tips.de Das SQL-Wiki


geschrieben von

Login

E-Mail:
  

Passwort:
  

Beitrag anfügen

Symbol:
 
 
 
 
 
 
 
 
 
 
 
 
 

Überschrift: