SQL Server: how to determine a column algorithm encryption

I was able to move the Java code to Oracle. I am writing this for people who are facing similar issue.

1. Log on to server where Oracle database is installed through Putty (command prompt in case of windows)
2. Place the Java file in server using WinSCP.

3. Find the Java compiler present in oracle home using command

   find / -name javac
   

4. Compile the Java file using Oracle's Java compiler as the Java version used by the database and Java version usually used will be different

   $ORACLE_HOME/jdk/bin/javac /home/vikram/EncrUtil.java
   

   Note: Instead of compiling on the database server, a .class or .jar file can be directly loaded into the database. But make sure to use the same version of Java as used by the database.

   To find the java version used by oracle

   $ORACLE_HOME/jdk/bin/java -version
   java version "1.5.0_17"
   Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_17-b03)
   Java HotSpot(TM) 64-Bit Server VM (build 1.5.0_17-b03, mixed mode)
   

5. Set ORACLE_HOME if it is not set

   export ORACLE_HOME=/database/ora11gr2/product/11.2.0/dbhome_1/
   

6. Add loadjava's directory in the path (that's the database's bin directory)

   export PATH=$PATH:$ORACLE_HOME/bin
   

   Note: In case class not found exception is found go through “loadjava” and check if path present is properly set or variables are defined is not define those

7. Load the class into the database

   loadjava -user <user>/<password>@xxx.xxx.xxx.xxxx:1521:<instance> \
            -thin –resolve /home/vikram/ EncrUtil.class
   

   • -resolve is used so that .class file can be resolved before loading into the database as its easy to debug Java outside database.
   • -thin is used for thin client

8. Once the class is loaded, create a wrapper function on top it, so that it can be used in database

   CREATE OR REPLACE FUNCTION TEST_DECRYPTOR(indata IN VARCHAR2)
   RETURN VARCHAR2 AS
   LANGUAGE JAVA NAME ' EncrUtil. decrypt (java.lang.String) return java.lang.String';
   CREATE OR REPLACE FUNCTION TEST_ENCRYPTOR (indata IN VARCHAR2)
   RETURN VARCHAR2 AS
   LANGUAGE JAVA NAME ' EncrUtil. encrypt (java.lang.String) return java.lang.String';
   

9. This function can then be used just like any other Oracle function:

   SELECT TEST_ENCRYPTOR('Vikram') FROM DUAL;
   

Don't confuse Oracle Advanced Security with encrypted SSL client connections to the database. The Advanced Security option is comprised of two main features, Data Radaction and Transparent Data Encryption. TDE is the encryption of data within tables, so that if someone captures the datafiles they won't be able to read table data in the clear inside the file.

An encrypted SSL connection between a client and the database is just part of the Oracle Net Services and is included with every version. The Oracle documentation explains how to set that up.

To answer your question, run this query:

SELECT sys_context('USERENV', 'NETWORK_PROTOCOL') as network_protocol FROM dual;

If you are connected via SSL you will get the response

NETWORK_PROTOCOL
----------------
tcps

If you get "tcp," then you are on a non-SSL connection.