Blog: DBS (Database Star)

208 blogs updated: 36 min. ago
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
TNSNAMES.ORA File – The Complete Guide
The TNSNAMES.ORA file is an important file when working with Oracle. Learn all about what it is, its location, and how to create and edit it...
10-04-2017 13:21:11 DBS (Database Star) Oracle
ORA-12514 Cause and Solution
Are you getting an "ORA-12514: TNS:listener does not currently know or service requested in connect descriptor" error? Learn what causes it ...
07-04-2017 14:01:50 DBS (Database Star) Oracle
Oracle ROWIDTOCHAR Function with Examples
In this article, I'll explain what the ROWIDTOCHAR function is and how to use it. Purpose of the Oracle ROWIDTOCHAR Function The ROWIDTOCHAR...
05-04-2017 13:49:36 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.