#PYTHON_TKINTER_WSL_VcXsrv_SQLPLUS_OracleExpressDB
Final Result
Frontend - Python Tkinter
Display Server X-Launch URL (https://sourceforge.net/projects/vcxsrv/)
-> export DISPLAY=192.168.0.133:0.0
HELLO WORLD PROGRAM
python3 -c "import tkinter as tk; root = tk.Tk(); root.mainloop()"
Host Machine - WSL Ubuntu 20.04 LTS
DB Client SQL Plus (WSL Ubuntu 20.04 LTS) - refer (https://askubuntu.com/questions/159939/how-to-install-sqlplus)
-
sudo apt-get install alien
sudo alien -i oracle-instantclient*-basic*.rpm
sudo alien -i oracle-instantclient*-sqlplus*.rpm
sudo alien -i oracle-instantclient*-devel*.rpm
sudo apt-get install libaio1
Create Oracle configuration file:
sudo sensible-editor /etc/ld.so.conf.d/oracle.conf
Put this line in that file:
/usr/lib/oracle//client/lib/
Note - for 64-bit installations, the path will be:
/usr/lib/oracle//client64/lib/
Update the configuration by running following command:
sudo ldconfig
Try to connect using:
sqlplus username/password@//dbhost:1521/SID or:
sqlplus testuser/password
Oracle DB (Docker) - https://hub.docker.com/r/gvenzl/oracle-xe
-- Way to connect Oracle Express DB sqlplus system/123@//localhost:1521/XEPDB1
DB Table
CREATE TABLE EMPLOYEES ( EMPLOYEE_ID NUMBER PRIMARY KEY, FIRST_NAME VARCHAR2(50), LAST_NAME VARCHAR2(50) NOT NULL, HIRE_DATE DATE, SALARY NUMBER(10,2), DEPARTMENT_ID NUMBER );
INSERT INTO employees (employee_id, first_name, last_name, hire_date, salary, department_id) VALUES (1001, 'John', 'Doe', SYSDATE, 5000, 10);
COMMIT;
SQL> DESc EMPLOYEES Name Null? Type
EMPLOYEE_ID NOT NULL NUMBER FIRST_NAME VARCHAR2(50) LAST_NAME NOT NULL VARCHAR2(50) HIRE_DATE DATE SALARY NUMBER(10,2) DEPARTMENT_ID NUMBER