This parameter can be used in this situations as minimum value specified in a sequence declaration: CREATE SEQUENCE … MINVALUE .. value … …. can be used in flashback version query: This keywords instruct Oracle to retrieve all available data versions The age of the data available is determined by the undo_retention parameter SELECT … fields … FROM … table … VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE WHERE … conditions …
This parameter can be used in this situations as maximum value specified in a sequence declaration: CREATE SEQUENCE … MAXVALUE value ….. can be used in flashback version query: This keywords instruct Oracle to retrieve all available data versions. The age of the data available is determined by the undo_retention parameter SELECT … fields … FROM … table … VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE WHERE … conditions …
The ALL comparison condition is used to compare a value to a list or subquery. It must be preceded by =, !=, >, <, <=, >= and followed by a list or subquery. When the ALL condition is followed by a list, the optimizer expands the initial condition to all elements of the list and strings them together with AND operators, as shown below. SELECT … fields … FROM … table … WHERE sal > ALL (2000, 3000, 4000);
The ANY comparison condition is used to compare a value to a list or subquery. It must be preceded by =, !=, >, <, <=, >= and followed by a list or subquery. When the ANY condition is followed by a list, the optimizer expands the initial condition to all elements of the list and strings them together with OR operators, as shown below. SELECT … fields … FROM … table … WHERE sal > ANY (2000, 3000, 4000); note: The SOME and ANY comparison conditions do exactly the same thing and are completely interchangeable.
Oracle subquery is a sql query within another sql query. Some example: select tab.name, tab.surname from (select name, surname from customer where surname like ‘S%’) tab select id from myusers where (name, surname) in (select name, surname from customer where surname like ‘S%’) tab select (select ‘1’ from dual) from table.