Sql | Database Star: Home

Difference Between CHAR, VARCHAR, and VARCHAR2 Data Types in Oracle

Feb 6, 2017 · 5 min read · sql ·

Oracle has several character data types that are commonly used and can also be confusing if you don't know the differences between them. Learn what they are and the differences between them in this article.

Oracle SQL List Tables in Database or Schema

Jan 30, 2017 · 3 min read · sql ·

Share on:

Do you need to list all tables in Oracle? There isn't an SQL list tables command, but you can learn how to show all tables in this article.

Oracle Triggers - The Complete Guide

Jan 23, 2017 · 27 min read · sql ·

Share on:

Oracle triggers are a handy but often misused function of the Oracle database. Learn all about them in this article.

What's The Difference Between Oracle ROWNUM vs Oracle ROW_NUMBER?

Jan 16, 2017 · 6 min read · sql ·

Share on:

Have you seen ROWNUM and ROW_NUMBER in Oracle and wondered what the difference is? Learn what they are and the differences between Oracle ROWNUM vs Oracle ROW_NUMBER in this article.

Oracle Certification Dumps Can Ruin Your Career

Dec 5, 2016 · 7 min read · sql ·

Share on:

Are you looking to get certified? Want to get your hands on some Oracle certification dumps for an exam to help you pass? That's a bad idea. I'll explain why in this article.

A Guide to the Oracle Data Types

Oct 24, 2016 · 21 min read · sql ·

Share on:

In this article, I explain what the different data types are in Oracle database and everything you need to know about them.

Overview of Oracle Character Sets

Oct 3, 2016 · 2 min read · sql ·

Share on:

This article will answer some of the common questions, and questions I had about Oracle character sets and how they relate to the Oracle database.

What Does SQL PARTITION BY Do?

Aug 29, 2016 · 4 min read · sql ·

Share on:

Have you ever seen the PARTITION BY keyword used in SQL queries? If so, do you know what it does and how to use it? Learn about the SQL PARTITION BY keyword and see some examples in this article.

Oracle 12c New Features for Developers

Aug 1, 2016 · 25 min read · sql ·

Share on:

Oracle 12c is Oracle's latest version of its database engine. Learn about all of the new Oracle 12c new features for developers in this massive guide.

How to Find the Row That Has the Maximum Value for a Column in Oracle

Jul 25, 2016 · 7 min read · sql ·

Share on:

Do you need to find the data for a row that has the maximum value for a specific column in Oracle? Learn how to do it and see some alternative answers in this article.