Do you need to insert or update data depending on if it already exists? You can do this with the MERGE statement in Oracle SQL. What is the MERGE Statement? The MERGE statement is a type of statement that lets you either insert data or update data, depending on if it already exists. It lets […]
An SQL join is a concept that allows you to retrieve data from two or more tables in a single query. It’s what makes databases so useful, and allows for data to be stored in separate tables and combined when it is needed. L<et’s take a look at what SQL joins are, how to use […]
There are a large number of tools available for Oracle SQL developers and DBAs to use. It’s hard to know which tools are useful, will help you get the job done, and are widely used so you can get support easily. However, there are people who have a lot of experience working with SQL, and […]
You want to avoid having bad data, right? Data that doesn’t make sense, is missing when it should be populated, or refers to other data that does not exist. We want to avoid these kinds of issues. How can we do that? We use constraints. In this article, I’ll explain everything you need to know […]
Oracle 18c has been released. What’s included? How does it impact you as a developer or a DBA? How can you get access to it to play around with some of the new features? Keep reading to find the answers to this, and more. What is Oracle 18c? Oracle 18c is Oracle’s latest version of […]
The software development industry has a lot of conferences. And Oracle is no different. Conferences can help you learn new topics and features on a specific feature, and help you meet people who work with the technology. If you like, you can also speak or present at conferences. Are you interested in going a conference […]
So, you’re interested in becoming a database developer? Great news! I’ll show you the path you can take, what skills are needed, and much more, in this article. But first, let’s start with some basics. You might already know what a database developer is, but I’ll explain it anyway, in case you’re not sure. If […]
Do you need to use sine, cosine, or tangent functions in your queries or database code? Oracle has plenty of those functions you can use. Learn how to use them and see some examples in this article. What Are The Mathematical Functions? The mathematical functions are those that calculate the sine, cosine, and tangent of […]
Oracle’s two INTERVAL data types are used to store a period of time. There are a few functions that convert data into these data types. Learn how to use them and see some examples in this article. What Are the Oracle INTERVAL Functions? There are four INTERVAL functions that I’ll cover in this article. Here’s […]
Read Full Article
Read for later
Articles marked as Favorite are saved for later viewing.
Scroll to Top
Separate tags by commas
To access this feature, please upgrade your account.