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 …

DATABASE TRANSACTIONS DB transaction is start with any of them; When DML command is running. When DDL command is running. When DCL command is running. Transaction is started when a …

Chapter 6 – DML (Data Manipulation Language) You can add, delete or update data, using the Data Manipulation Language. INSERT : Adding data to a table. UPDATE : Changing data …

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 …

Hi , if you have this error when you’re attempting to login with ‘admin’ user; You must apply below steps to unlock the ‘admin’ user. The user can be locked …

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. …

NUMERIC FUNCTIONS ROUND Let’s try some different usages of the ROUND function. SELECT ROUND (45.923), ROUND (45.943, 1), ROUND (45.924, 2), ROUND (44.923, -1), ROUND (55.923, -2) FROM DUAL;   …