If you are an application developer, like someone developing a server-side application using Java or .NET or any other programming language which uses a database like Oracle and Microsoft SQL Server or a junior DBA, then you must learn these database technologies to effectively work in your Job. Even though your organization might have DBAs or Database Administrators to help you with the database, more often than not, it's application developers who end up writing SQL scripts to create data, upload data, query data, and writing complex stored procedures and triggers to implement application functionalities. DBAs job mostly does database installation, access control, security, and other database admin stuff.
Top 10 Oracle Database and PL/SQL Courses for Beginners in 2025 - Best of Lot [UPDATED]
Hello folks, if you are learning Oracle database and want to learn PL/SQL programming language and looking for the best resources like books, online courses, tutorials and articles then you have come to the right place. In the past, I have shared the best free SQL and database courses, PL/SQL books, and a few free Oracle courses, and this article will introduce you to the Oracle SQL database and how they work as well as the PL language and how you can use its commands to interact with the oracle SQL database in 2025.
Top 20 PL/SQL Interview Questions with Answers
Hello guys, if you are preparing for Oracle or PL/SQL Job or a Developer job where PL/SQL skills are needed and looking for frequently asked PL/SQL Interview Questions then you have come to the right place. Earlier, I have shared both best PL/SQL courses and best PL/SQL books and in this article, I am going to share popular PL/SQL Interview Questions you can revise before your interview. Preparing for PL/SQL Interview is not a rocket science and you can prepare for it the same way you prepare for other interviews.
Top 20 Oracle Database Interview Questions with Answers for 3 to 5 Years Experienced
Hello guys, if you are a developer or a database administrator and preparing for Oracle database interview and need common Oracle database questions for 1 to 5 years experienced then you have come to the right place. Earlier, I have shared tricky SQL query interview questions as well as popular database interview questions and in this article, I am going to share popular Oracle interview questions with answers. If you have used Oracle database for a couple of years or worked as Oracle database administrator then most likely you will know answers of all these questions but if you struggle to answer them then you can always go back and checkout these best Oracle database online courses to learn and revise key Oracle database concepts.
[Solved] Caused by: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number in Java and Oracle
Hello guys, if you are getting below error in your Java program and wondering how to solve this or just stuck then you have come to the right place. In this article, I will explain to you what causes the " java.sql.SQLSyntaxErrorException: ORA-01722: invalid number" error when you connect to an Oracle database from a Java program and how you can solve it.
But, first of all, let's take a look at the stack trace of this error which looks like below:
JDBC - How to connect Eclipse to Oracle Database - Step by Step Guide Example
Though I prefer Toad or Oracle SQL Developer tool to connect Oracle database, sometimes it's useful to directly connect Eclipse to Oracle using JDBC using its Data Source Explorer view. This means you can view data, run SQL queries to the Oracle database right from your Eclipse window. This will save a lot of time wasted during switching between Toad and Eclipse or Oracle SQL Developer and Eclipse. Eclipse also allows you to view the Execution plan in both text and Graphical mode, which you can use to troubleshoot the performance of your SQL queries.
Subscribe to:
Posts (Atom)