Blog: DBS (Database Star)

208 blogs updated: 14 min. ago
Oracle SYS_EXTRACT_UTC Function Tips and Examples
In this article, I'll explain what the SYS_EXTRACT_UTC function does and show you some examples. Purpose of the Oracle SYS_EXTRACT_UTC Funct...
19-09-2017 21:41:18 DBS (Database Star) Oracle
Oracle Date Functions: The Complete Guide
There are many different date and time functions in Oracle, and they behave differently than other databases. Learn what they are and see so...
11-09-2017 13:16:51 DBS (Database Star) Oracle
Ultimate List of 32 Oracle SQL IDEs Compared
Are you looking to find the right SQL IDE to use for your Oracle development? Want to know how all of the available Oracle SQL editors compa...
21-08-2017 21:56:38 DBS (Database Star) Oracle
Ultimate Guide to Becoming a Business Analyst
Are you wondering what a business analyst is? Are you interested in becoming a business analyst? You've come to the right place. In this gui...
17-07-2017 22:53:07 DBS (Database Star) Oracle
Monthly Link Roundup – June 2017
In this roundup article, I share some of the best articles I've read recently on Oracle, database development, and software. Database Admini...
15-06-2017 21:57:12 DBS (Database Star) Oracle
Oracle SQL Indexes – The Definitive Guide
Indexes in SQL are an important part of the language. But why is that? What is an Oracle index? And why should you know about them? I'll cov...
14-05-2017 22:21:21 DBS (Database Star) Oracle
How to Escape Single Quotes in SQL
Do you need to escape special characters or escape a single quote in SQL? Learn how to do that in this article. What Is Escaping? When you a...
01-05-2017 13:35:29 DBS (Database Star) Oracle
What Is a Self Join?
A self join is a common solution to a specific table design in databases. Learn what a self join is and how to write queries against it in t...
24-04-2017 14:16:26 DBS (Database Star) Oracle
Oracle SQL IF Statement
Do you want to write an SQL IF statement? Learn how to do that in Oracle in this article. What's an IF Statement? In case you're not sure, a...
17-04-2017 14:15:42 DBS (Database Star) Oracle
ORA-20000 Cause and Solution
Have you gotten the ORA-20000 error when working with Oracle PL/SQL? Learn what causes it and how to resolve it in this article. ORA-20000 C...
12-04-2017 13:24:31 DBS (Database Star) Oracle

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.