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

Illustrates skipping the first line (header row) from a CSV file.

Python - How to Skip First Line in CSV?

When working with CSV files in Python, it is common to encounter files that include a header row as the first line. This header typically contains the column names, which you might not want to process as data. In such…