Connect MySQL with Oracle SQL Developer

Complete Connection guide of MySQL with Oracle SQL Developer. Connect MySql with Oracle SQL Developer step 1 : open Oracle SQL Developer . click Tools Tab Next click Preferences. step 2 : inside preferences select Database. step 3 : inside Database “Third Party JDBC Drivers step 4 : inside “Third Party JDBC Drivers” click Add […]

DeadLock in Oracle Database

A deadlock happens when two or more Transactions are waiting for resources locked by each other, resulting in all the Transactions being blocked. Let’s see , How to create deadlock in Oracle Database. Create Two Tables in same Schema. Open two SQL Developer IDE. CREATE TABLE Adam1 ( ID NUMBER(2) CONSTRAINT adam_col1_pk23 PRIMARY KEY, Name […]