Michael, This is well described in the documentation: https://docs.oracle.com/cd/E11882_01/server.112/e41084/sql_elements002.htm#SQLRF00214 -- Best regards, Sayan Malakshinov Oracle ACE Associate http://orasql.org