How to Print 1 to 10 Without Using Loop in PL/SQL?
Here I am giving an example to print 1 to 10 without using the loop in PL You can print up to any number by changing the value 10 to any number, for example, 100. PL/SQL Program to Print 1…
How to Validate Credit Card Number and Identify Its Type Using PL/SQL?
Here I am giving an example of PL/SQL stored function to validate the Credit Card number and identify its type, whether it is a Visa, MasterCard or American Express Credit Card. I am checking the Credit Card number using the…
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…
How to Check if File is Image Using PL/SQL?
In this blog post, I am sharing a function with which you can check if a file is an image file or not using PL The program will check the file by reading its header not the extension name of…
How to Save BLOB as File in PL/SQL?
Here I am giving an example to save BLOB data as a file in PL BLOB data you can get it from the table having BLOB column, or you can get it from a file on the disk. PL/SQL Function…
How to Get BLOB from File in PL/SQL?
Below I am giving a function example to get the BLOB from a file in PL PL/SQL Function to Get BLOB from a File The following function will read a file and will return the BLOB data type of the…
How to Create Log File in Oracle Using PL/SQL?
You have a PL/SQL program, and you want to log information in a text file of each step of your code. Here is an example to create a log file in Oracle using PL Create Log File in Oracle Using…
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.…
Python - Read CSV Columns Into List
In this tutorial, you will learn how to read CSV columns into a list in Python. I am giving the following examples: Read CSV Columns into list and print on the screen. Read and Print specific columns from the CSV using…
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…
How to Import CSV Into Oracle Table Using Python?
In this tutorial, I am giving some examples of importing a CSV file into Oracle table using Python. You will learn how to use csv.reader and csv.DictReader methods to load data from CSV file. The following are the examples. Import…
How to Export CSV from Oracle Table in Python?
In this tutorial, I am giving an example to export CSV file from Oracle table in Python. I am using CSV module to write the data and using the cx_Oracle module to interact with Oracle database. Earlier I have written…
Python Program to Update Table in Oracle
The below is an example of Python program to update a table in Oracle. I am using the cx_Oracle library in the program to connect to the Oracle database and to update the SCOTT user's EMP table. If you don't…
How to Determine Python Program Run Directly or Through Import?
In Python, use __name__ attribute to determine a Python program runs directly or through an import. Below I am giving an example. Python __name__ Attribute Example Attribute __name__ always returns __main__ if a Python program is running directly else it…
Python Program to Display Employee Details
The below is an example of a Python program to display employee details. In this program, it will ask the user to input employee number, then it will query the database table for that employee and will print the details.…
Python Function Example To Insert a Record in Oracle Table
Here I am giving an example of Python function to insert a record in Oracle table using the cx_Oracle library. Python Function Example To Insert A Record in Oracle Table Using CX_Oracle In the following Python function insert_dept, it will…
How to Call Oracle Function in Python?
In this tutorial, you will learn how to call Oracle function in Python. I am giving an example by using cx_Oracle library callfunc function in the Python program. The following are the syntax details and the sample programs. CX_Oracle callfunc…
How to Call Oracle Stored Procedure in Python?
In this blog post, I am giving an example to call Oracle stored procedure in Python. Example include calling a stored procedure with IN-OUT parameters. I am using cx_Oracle library callproc function to call the Oracle procedure. To let you test this…