How to Connect to Oracle Database in IntelliJ IDEA

Learn how to connect to and manage a database on Oracle Database Server right inside IntelliJ IDEA using the built-in Database tool which is very helpful and advanced - you can do almost everything with database without leaving the IDE.

In details, I will show you:
- Make connection to Oracle database
- Create a new table
- Manage data in a table
- Execute SQL statements

Software programs:
- Java Development Kit (JDK)
- IntelliJ IDEA Ultimate
- Oracle Database 18c Express edition

[fene]

Thanks a lot for these helpful details. I might not need to install any additional db utilities since intellij has so much db functionality. Are there any other db utilities you consider essential that do things intellij can't?

[ascar]

Thank you for your videos. This comment just to support Code Java.

[DharmendraKrGupta-tslj]

sir, I do all the things of this videos as well after that I want to write java program as well find, update, insert data to database from java code.
sir please give me any suggestion or refer any videos

[anonymousbot]

Thanks Nam . When is your new course coming . Eagerly waiting

[DharmendraKrGupta-tslj]

Sir How to do CURD operation with Jfrom as well as follow these videos
like you connect SQL in IntelliJ idea Database
help me

[DharmendraKrGupta-tslj]

Sir, how to make jdbc programm
please give me one example of fatching the data using oracle sql and java

[blaxminarayanpatra]

Is it possible to connect db in community version...

[codeklaudia]

My inteliJ does not have "Database" under "View" > "Tool Windows" :( Can someone help?