Oracle Autonomous Transaction Example

Oracle Autonomous Transaction Example

In Oracle, an autonomous transaction can commit or rollback the data in the same session without committing or rolling back in the main transaction. PRAGMA (compiler directive) statement is used to define autonomous transaction in Oracle. The following is an…

How to Encrypt Password in Oracle?

How to Encrypt Password in Oracle?

Here I am giving an example to encrypt the password in Oracle using the DBMS_CRYPTO package. To demonstrate this, I have created the following table to store user ID (USER_ID) varchar2 data type and to store the encrypted password (ENC_PSW)…

How To Truncate Table In Oracle Procedure?

How To Truncate Table In Oracle Procedure?

In Oracle, TRUNCATE command is a DDL statement, so you can not execute it directly in Oracle Procedure. To execute DDL commands in Oracle procedure, use EXECUTE IMMEDIATE statement. The below is an example of truncating a table in Oracle procedure…

cx_Oracle - Python Tutorials

Here I am providing the list of cx_Oracle tutorials I have given on this blog for the Python programs. You will learn how to use the Oracle database as a backend for your Python applications by using the cx_Oracle library.…