Oracle SQL – Create Tablespace

Hi everyone, Today i will show you how to create tablespace on Oracle Database. I installed Oracle database with GRID

Read more

Oracle SQL Tutorial – System and User Privileges

Hi everyone, i want to show you schema subject, system and user privileges. it seems easy but required for dba

Read more

Oracle SQL Tutorials Chapter 7 ( Part 2 of 2 )

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

Read more

Oracle SQL Tutorials Chapter 7 ( Part 1 of 2 )

Chapter 7 – CREATING AND MANAGING TABLES Classify Main Database Objects Examining Table Structure Data Types of the Columns Creating

Read more

Oracle SQL Tutorials

Hi, I’m writing Oracle SQL articles and sharing with you. You can learn SQL by following my articles and trying

Read more

Oracle SQL Tutorials – Chapter 5

Chapter 5 – Selecting Data From Multiple Tables Usage of multiple tables in one query Combining tables – JOIN Different

Read more

Oracle SQL Tutorials – Chapter 4

Chapter 4 – Group Functions AVG Function SUM Function MIN Function MAX Function COUNT Function DISTINCT Function GROUP BY Statement

Read more

Oracle SQL Tutorials – Chapter 2 (Part 3 of 3)

OPERATOR PRECEDENCE   Let’s list the employees which JOB_ID is SA_REP or AD_PRES , and have salary more than 15000.

Read more