if-then-else functionality implicit type conversions, DATE data type IN operator multiple-row subqueries indexes function-based partitions regular expressions inequality conditions inequality operator (!=) inheritance of object types inline views aggregate queries, overcoming limitations of columns, hiding with WITH CHECK OPTION creating data sets DML statements errors 2nd execution global hierarchical queries, overcoming limitations of mimicking analytic queries with overview selective aggregation inner joins 2nd 3rd syntax INSERT statement DML join views partitions, specifying strings, converting to default date format inserting data (XML) instances storing XMLType International Standard ISO 8601 INTERSECT set operator 2nd interval data (date and time) INTERVAL DAY TO SECOND data type INTERVAL YEAR TO MONTH data type INTERVAL DAY TO SECOND data type INTERVAL literals INTERVAL YEAR TO MONTH data type IS ANY wildcard IS PRESENT condition ISO standards, dates overview weeks years ITERATION_NUMBER function