Free

ORACLE SQL

CODE TEACHING

Lessons

Free

INTRODUCTION

USER

SCHEMA

DATA TYPE

Free

SQL TABLE

Free

Create Table

Free

CREATE TABLE AS

Free

DROP TABLE

Free

GLOBAL TEMP Table

Free

ALTER TABLE

Free

LOCAL TEMP Table

FUNCTION

SQL QUERY (SELECTING DATA)

WHERE

Free

ORDER BY

Free

GROUP BY & HAVING

Free

SQL Comparison Operators

DISTINCT Clause

Free

SELECT Statement

Free

INSERT , UPDATE, DELETE

Free

TRUNCATE

UNION

INTERSECT

MINUS Operator

EXCEPT Operator

Free

CONDITIONAL SELECTION

Free

AND Condition

Free

OR Condition

Free

AND-OR Condition

Free

LIKE Condition

Free

IN Condition

Free

BETWEEN

Free

NOT

Free

NULL and NOT NULL

Free

EXIST Condition

SUB-QUERY

Free

CONSTRAINT

Free

UNIQUE

Free

CHECK

Free

Not Null

Free

PRIMERY KEY

Free

FOREIGN KEY

JOINS

SEQUENCE

INDEX

Free

SQL Aliases

SQL VIEW