This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#.rst: | |
# FindOracle | |
# ---------- | |
# | |
# Configure Oracle libraries | |
# | |
# ORACLE_FOUND - system has Oracle OCI | |
# ORACLE_HAS_XML - Oracle has XDK support(thick client installed) | |
# ORACLE_INCLUDES - where to find oci.h | |
# ORACLE_LIBRARIES - the libraries to link against to use Oracle OCI |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import java.math.BigInteger; | |
import java.security.MessageDigest; | |
/** | |
* Compute SQL_ID for SQL string | |
* @author Ivan Brezina(ibre5041) | |
* | |
*/ | |
class OracleSQLID { | |
/** |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
set serveroutput on size unlimited | |
declare | |
v_ItemCount integer; | |
begin | |
SELECT count(*) | |
INTO v_ItemCount | |
FROM ALL_OBJECTS AO | |
WHERE AO.OWNER = '&USER' | |
AND AO.OBJECT_TYPE NOT IN ('INDEX', 'LOB') | |
AND AO.OBJECT_NAME NOT LIKE 'BIN$%'; |