Understanding SQL Language Basics for Oracle

Q

Where to find answers to frequently asked questions on SQL Language Basics for Oracle?

✍: FYIcenter.com

A

Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL Language Basics for Oracle. Clear answers are provided with tutorial exercises on data types, data literals, date and time values, data and time intervals, converting to dates and times, NULL values, pattern matches.

What Is SQL Standard in Oracle

Categories of Data Types in Oracle

Oracle Built-in Data Types in Oracle

Differences between CHAR and NCHAR in Oracle

Differences between CHAR and VARCHAR in Oracle

Differences between NUMBER and BINARY_FLOAT in Oracle

Differences between DATE and TIMESTAMP in Oracle

Differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND in Oracle

Differences between BLOB and CLOB in Oracle

ANSI Data Types in Oracle

Text Literals in Oracle

Numeric Literals in Oracle

Date and Time Literals in Oracle

Date and Time Interval Literals in Oracle

Convert Numbers to Character Strings in Oracle

Convert Character Strings to Numbers in Oracle

Convert Dates to Character Strings in Oracle

Convert Character Strings to Dates in Oracle

Convert Times to Character Strings in Oracle

Convert Character Strings to Times in Oracle

What Is NULL Value in Oracle

Use NULL as Conditions in Oracle

Concatenate Two Text Values in Oracle

Increment Dates by 1 in Oracle

Date and Time Differences in Oracle

Use IN Conditions in Oracle

Use LIKE Conditions in Oracle

Use of Regular Expression in Oracle

⇒ What Is SQL Standard in Oracle

⇐ Show Execution Statistics Reports in Oracle

⇑⇑ Oracle Database Tutorials

2020-05-29, 1660👍, 0💬