Use Oracle DB from IDE

1. Eclipse -> Windows -> Show View -> Other -> Data Source Explorer
2. Right click on Data Source Explorer ->  Database Connections -> new
3. On new Connection Profile,

  1). on Connection Profile, Select "Generic JDBC", and next

  2) on Specify a Driver and Connection Detail, Click "New Driver Definition" icon

        a. Under Name/Type tab, click “Generic JDBC Driver”, input Driver name

       b. Under jar List tab , Click JAR List, and click Add JAR/ZIP, find the JAR dependency and add it

       c. Click “Properties” tab , the input value correspondingly

                 d. click ok and next

4. On New Connection Profile -> General, input password, and test connection

5. Create new SQL file using previous creating JDBC connection.

Right clicking - > New -Others -> SQL Development -> SQL File