Java Connect to Oracle database Made Easy

Learn to write Java code that connects to Oracle database, insert a new row and get all rows from a table in Oracle database.

What you will learn:
- Create a table in Oracle Database XE using Oracle SQL Developer.
- Code the first Java project that connects to Oracle database express server, then insert a new row to a table. Use Oracle JDBC driver as a referenced Jar file in the classpath. Then close the connection
- Code the second project based on Maven. Make connection to Oracle database; get all rows from a table. Declare a Maven dependency for Oracle JDBC driver.

In addition, you will also learn:
- Understand how a Java program talks to a database server via JDBC API and JDBC driver.
- Understand Oracle JDBC driver (OJDBC): versions, database URL and driver types.
- Use Oracle SQL Developer tool to create a table with sequence and trigger for the primary column.

#jdbc #oracledatabase #javaprogramming #javatutorial #javatips

[ulyses]

thank you for this tutorial. I was able to perform on my own code and it works very easy. I will suscribe

[ruslan]

Thank you very much! Perfect explanation with code example, helped me a lot! Wish all the best!

[klmbI]

My English is poor.
I am using Intellij IDEA and and my DB.
But still I did it.

Thank you so much. I have not found this information anywhere else.

[kimivanbay-an]

thankyou this helps me even if im not a java developer

[galaxystardude]

Thank you! This was a great tutorial, very easy to follow!

[trieutruong]

Great instruction, thanks for your effort.

[julioprado]

thanks mate, it really worked for me!

[ЭдгарПрима]

Thank you very much! Special for resolve exceptions with JDBC driver

[DineshKumar-ipyb]

If the voice over is precise and clear this would be an great tutorial

[priyathakurl]

thanku so much! this vedio has solve my problem.

[sakthisakthi-wudt]

I have subscribed your channel and expecting more videos

[sakthisakthi-wudt]

Please create more videos how to fetch particular record at run time and particular column value write into excel sheet .

[mpvishnuprakash]

I am getting ORA-00942: table or view does not exist
But i have created emp table is oracle sql

[sakthisakthi-wudt]

Really I couldn't find any place this information, thanks

[sakthisakthi-wudt]

Create some videos how to write database particular cell data in Excel file and selenium automation testing with Java videos .

[robertb]

For the past week, I am unable to clear the error " ORA-00942: table or view does not exist". I have followed the exact same procedures via the tutorial.

[sakthisakthi-wudt]

How to fetch particular column cell value and how to validate database record data in eclipse

[prabeshrai]

Sir while modifying program, i got error "ORA-01008: not all variables bound" Please help me.

[MythicalCreatures]

I downloaded the.jar file. But I dont know how t include it in my eclipse workspace

[shadabahmad]

Still I'm getting ORQ-00942:table or view does not exist " This error please help me resolve this I'm stuck on this problem for last 3-4 days