Stay organized with collections
    
    
      
      Save and categorize content based on your preferences.
    
  
  
    
  
  
  
  
    
    
    
  
  
    
    
  
  
NClob
  public
  
  
  
  interface
  NClob
  
  
      implements
      
        Clob
      
  
  
  
    
  The mapping in the JavaTM programming language
 for the SQL NCLOB type.
 An SQL NCLOB is a built-in type
 that stores a Character Large Object using the National Character Set
  as a column value in a row of  a database table.
 
The NClob interface extends the Clob interface
 which provides provides methods for getting the
 length of an SQL NCLOB value,
 for materializing a NCLOB value on the client, and for
 searching for a substring or NCLOB object within a
 NCLOB value. A NClob object, just like a Clob object, is valid for the duration
 of the transaction in which it was created.
 Methods in the interfaces ResultSet,
 CallableStatement, and PreparedStatement, such as
 getNClob and setNClob allow a programmer to
 access an SQL NCLOB value.  In addition, this interface
 has methods for updating a NCLOB value.
 
 All methods on the NClob interface must be fully implemented if the
 JDBC driver supports the data type.
Summary
| Inherited methods | 
|---|
| 
    From interface
      
        
          java.sql.Clob
        
      
      
  
  
  
    | 
        abstract
        
        
        
        
        void | 
      free()
      This method frees the Clobobject and releases the resources the resources
 that it holds. |  
  
  
    | 
        abstract
        
        
        
        
        InputStream | 
      getAsciiStream()
      Retrieves the CLOBvalue designated by thisClobobject as an ascii stream. |  
  
  
    | 
        abstract
        
        
        
        
        Reader | 
      getCharacterStream()
      Retrieves the CLOBvalue designated by thisClobobject as ajava.io.Readerobject (or as a stream of
 characters). |  
  
  
    | 
        abstract
        
        
        
        
        Reader | 
      getCharacterStream(long pos, long length)
      Returns a Readerobject that contains a partialClobvalue, starting
 with the character specified by pos, which is length characters in length. |  
  
  
    | 
        abstract
        
        
        
        
        String | 
      getSubString(long pos, int length)
      Retrieves a copy of the specified substring
 in the CLOBvalue
 designated by thisClobobject. |  
  
  
    | 
        abstract
        
        
        
        
        long | 
      length()
      Retrieves the number of characters
 in the CLOBvalue
 designated by thisClobobject. |  
  
  
    | 
        abstract
        
        
        
        
        long | 
      position(String searchstr, long start)
      Retrieves the character position at which the specified substring
 searchstrappears in the SQLCLOBvalue
 represented by thisClobobject. |  
  
  
    | 
        abstract
        
        
        
        
        long | 
      position(Clob searchstr, long start)
      Retrieves the character position at which the specified
 Clobobjectsearchstrappears in thisClobobject. |  
  
  
    | 
        abstract
        
        
        
        
        OutputStream | 
      setAsciiStream(long pos)
      Retrieves a stream to be used to write Ascii characters to the
 CLOBvalue that thisClobobject represents,
 starting at positionpos. |  
  
  
    | 
        abstract
        
        
        
        
        Writer | 
      setCharacterStream(long pos)
      Retrieves a stream to be used to write a stream of Unicode characters
 to the CLOBvalue that thisClobobject
 represents, at positionpos. |  
  
  
    | 
        abstract
        
        
        
        
        int | 
      setString(long pos, String str, int offset, int len)
      Writes lencharacters ofstr, starting
 at characteroffset, to theCLOBvalue
 that thisClobrepresents. |  
  
  
    | 
        abstract
        
        
        
        
        int | 
      setString(long pos, String str)
      Writes the given Java Stringto theCLOBvalue that thisClobobject designates at the positionpos. |  
  
  
    | 
        abstract
        
        
        
        
        void | 
      truncate(long len)
      Truncates the CLOBvalue that thisClobdesignates to have a length oflencharacters. |  | 
 
 
  
  
    
  
 
  
    
      
      
    
    
      
    
    
  
       
    
    
      
    
  
  
  Content and code samples on this page are subject to the licenses described in the Content License. Java and OpenJDK are trademarks or registered trademarks of Oracle and/or its affiliates.
  Last updated 2025-02-10 UTC.
  
  
  
    
      [[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-02-10 UTC."],[],[]]