In Oracle,there are many errors related to the use of NULL.On the basis of many Oracle data manipulation experiments,this article discusses the proper use of NULL,including the concept of NULL,the determining,data updates,its relationship with the index and the sorting.