Submitted by devraj on Wed, 09/01/2021 - 19:11 Oracle FundamentalIntroduction to SQLTypes of SQL CommandsFeatures of Oracle DatabaseOracle Installation & SetupInstall Oracle XE 21C on Windows 10Download and Install Oracle SQL Developer for Windows 10Connect SQL Developer to Oracle Express DatabaseOracle DatabaseOracle Predefined User AccountsOracle Create UserAlter User Password OracleOracle TablesCreate Table OracleCreate Table As Select OracleDrop Table OracleOracle Global Temporary TableOracle Create Table Primary KeyOracle Foreign KeyComposite Primary Key in OracleOracle Check ConstraintOracle Altering StructureHow to Add Column in Existing Table in OracleOracle Drop ColumnAlter Table Modify Column OracleRename Column Name in OracleOracle Rename TableAlter Table Add Primary Key OracleDrop Primary Key OracleAdd Foreign Key in Oracle Alter TableHow to Drop Foreign Key in OracleOracle Basic QueriesOracle Insert StatementOracle: INSERT ALL statementOracle: Select StatementOracle: WHERE() ClauseOracle: FROM ClauseOracle: DESCRIBE CommandOracle: DELETE StatementOracle: DISTINCT ClauseOracle: Difference between DELETE, DROP and TRUNCATEOracle: AliasesOracle: ORDER BY ClauseOracle Built-in functionsCount in Oracle SQLOracle: MOD() FunctionOracle: Difference Between Count(*) and Count(1)Oracle OperatorsOracle Arithmetic OperatorsOracle SQL Set OperatorsOracle: UNION operatorOracle: Union AllOracle: INTERSECT OperatorOracle: MINUS operatorOracle: Logical OR OperatorOracle: Logical AND OperatorOracle: Logical Not OperatorOracle: Concatenation OperatorOracle: Comparison operatorsOracle: Bitwise OperatorsOracle: IS NOT NULL OperatorOracle: IS NULL OperatorOracle: All OperatorOracle: Any or Some OperatorOracle ConditionsOracle: Exists OperatorOracle: Between ConditionOracle JoinsOracle: Cross JoinOracle Natural JoinOracle: Inner JoinOracle: Anti JoinOracle: Left Outer Join Or Left JoinOracle: Right Outer Join Or Right JoinOracle: Full Outer Join or Full JoinOracle: Self JoinOracle: Difference between Natural join and Inner JoinOracle ClausesOracle: GROUP BY ClauseOracle: Having ClauseOracle ViewsOracle: CREATE VIEWOracle: Update VIEWOracle: DROP VIEWOracle MiscOracle: COMMIT statementOracle: ROLLBACK StatementOracle: Single and Multi Line CommentsOracle: REVOKE statementOracle: GRANT StatementOracle: SAVEPOINTOracle SubqueriesOracle: SubqueriesOracle: Types of SubqueriesCorrelated Subquery in OracleCase Study Employee DatabaseOracle Employee Database Case Study: Create TablesOracle Employee Database Case Study: Insert Data Into TablesOracle Employee Database Case Study: Basic QueriesOracle Employee Database Case Study: Where ConditionsOracle Employee Database Case Study: Order By ClauseOracle Employee Database Case Study: Group By & Having ClauseOracle Employee Database Case Study: JoinsOracle Employee Database Case Study: Set OperationsOracle Employee Database Case Study: Sub Queries
