Tag Archives: oracle sql tutorial

Hi , In this article I will tell you how to use data dictionary views , what is a data dictionary . DATA DICTIONARY Database information is information about all …

Hi , in this article , I will tell you about user creation and user access . USER ACCESS Each user is logged into the system with their user name …

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 …

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 …

Hi, I’m writing Oracle SQL articles and sharing with you. You can learn SQL by following my articles and trying example SQL’s. Here are the SQL Tutorials, I highly recommend …

Chapter 5 – Selecting Data From Multiple Tables Usage of multiple tables in one query Combining tables – JOIN Different Types of SQL Join Left Outer Join Right Outer Join …

Chapter 4 – Group Functions AVG Function SUM Function MIN Function MAX Function COUNT Function DISTINCT Function GROUP BY Statement HAVING Statement   One row functions can be applied to …

CONVERSION FUNCTIONS TO_CHAR (DATE) TO_CHAR(date, ‘format’) It’s case-sensitive and must be written between quotes. It must contain a valid date format. Let’s list the hire dates of employees like below. …