Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-01400

Re: ORA-01400

From: Pete Johnson <P.Johnson_at_ste0426.x400.icl.co.uk>
Date: Tue, 10 Nov 1998 15:57:36 -0000
Message-ID: <364860a1.0@145.227.194.253> 





>  How can I learn which column has NULL value?


>


>Pavel


>uxid_at_artintel.cherkassy.ua


>


>


>





This has been a problem with Oracle since year dot. No - there is no-way  to
tell which is the offending column without dumping your data either to
screen (DBMS_OUTPUT) or another table then select the length (more
full-proof cos spots trailing spaces.


Received on Tue Nov 10 1998 - 09:57:36 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US