StringsSecurityInOracle

Security of all strings with large and small lengths in Oracle

First Create bellow SPs in Oracle database :

1. BLOB_TO_CLOB.sql
2. CLOB_TO_BLOB.sql
3. CLOB_TO_CHAR.sql
4. CLOB_TO_RAW.sql

---

Create a temporary table to split large strings into small strings in an Oracle database :

1. TMP_SHRINK_LARGE_STRING.sql

---

Create bellow SPs in Oracle database for encrypt and decrypt string data :

1. FUNC_ENCRYPT.sql
2. FUNC_ENCRYPT_L.sql
3. FUNC_ENCRYPT_WITH_IV.sql
4. FUNC_DECRYPT.sql
5. FUNC_DECRYPT_L.sql
6. FUNC_DECRYPT_WITH_IV.sql