Monthly Archives: ottobre 2013

Oracle Glossary: MAXVALUE
  • 31
    Ott

Oracle Glossary: MAXVALUE

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   ......

Read More
How to Deinstall Oracle Clusterware Home Manually [ID 1364419.1]
  • 28
    Ott

How to Deinstall Oracle Clusterware Home Manually [ID 1364419.1]

Applies to: Oracle Server - Enterprise Edition - Version 10.2.0.1 and later Information in this document applies to any platform.   Goal In 11gR2, deinstall is the recommended tool to deinstall an Oracle Clusterware(Grid Infrastructure) home, however it does not apply to certain scenarios or fails in some cases. This notes provides instruction to manually remove current/active clusterware...

Read More
Oracle Glossary: ALL
  • 22
    Ott

Oracle Glossary: ALL

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...

Read More
Oracle Glossary :ANY
  • 14
    Ott

Oracle Glossary :ANY

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...

Read More