[PYH 16] Oracle database connectivity with Python (creating, insert tables) HINDI

Опубликовано: 25 Июнь 2022
на канале: The Academician
71
0

Oracle (DBMS) using Python
Source code: https://github.com/TheAcademcian/Pyth...

Step 1: Install Database Express Edition from https://www.oracle.com/in/downloads/
https://www.oracle.com/in/database/te...

Step 2: Oracle Instant Client Downloads for Microsoft Windows (x64) 64-bit
https://www.oracle.com/in/database/te...

unzip the file and store it into a file. C:\oracle\instantclient_21_6

Step 3: Set the path:
Edit the system envionment variable -- click on environment variables -- click on path -- store "C:\oracle\instantclient_21_6" and click OK

Step 4: Install cx_Oracle using "pip install cx_Oracle"
Create a table students where attributes are roll, name, age and add, Inserting a data into the student table, Insert more than one data into the student table, Enter the data using key board, Display all the content of the student database, Display age in order, Display data of any particular roll number, Display recordwise, Update a table, Delete, Conditional delete, Delete the student table