Oracle SQL

Hi , in this article I will tell you about the joins . We use Join to join two tables .The JOIN-related column values must be in two tables . …

Hi , In this article , I will tell you about group functions .Group functions , when we do a query in the table if we write this query using …

Hi , In this article , I will tell you what the number functions , date functions , and nested functions are . LARGE SMALL CHARACTER CONVERSION FUNCTIONS LOWER : …

Hello , In this article, I will tell you about the expressions that form the basis of sql and how to give aliases to columns. NULL EXPRESSION Null values are …

Hi, What is sql in this article? , What are the sql rules of writing? We will find answers to such questions . WHAT IS SQL (STRUCTURED QUERY LANGUAGE) ? …

Hi, I will explain SQL Statement Processing in Oracle Database in this article.

Hi everyone, Today i will show you how to create tablespace on Oracle Database. I installed Oracle database with GRID , so i created ASM disk that means data files …

Hi everyone, i want to show you schema subject, system and user privileges. it seems easy but required for dba SCHEMA : Schemas are called database objects aggregated together. A …

CREATING TABLE WITH SUB-QUERIES With this method, table is created automatically with the column types that result from a query. While the table is created, data that came from the …

Chapter 7 – CREATING AND MANAGING TABLES Classify Main Database Objects Examining Table Structure Data Types of the Columns Creating a Simple Table Understanding How Schema Objects Work DATABASE OBJECTS …