- 1-Types of users in Oracle
- 2-Types of Oracle Clients
- 3-How to connect to SQL*PLUS
- 4-How to Create user using SQL*PLUS
- 5-what are User Privileges
- 6-What is a Schema
- 7-Create Table using SQL*PLUS
- 8-How to grant Object privileges to specific user
- 9-REVOKE Object Privilege From a user
- 10-Revoke system Privilege from a specific user
- 11-How to Lock and Expire account
- 12-Know Oracle Users and User Tables
- 13(1)-How can I know my System or Object Privileges
- 13(2)-How to grant or revoke all System or Object Privileges
- 15-How can a regular user to grant Object Privileges
- 16-How can a regular user to grant System Privileges
- 17-How Can HR and SYS USERS select any Table Data
- 18-How To Drop USER
- 19-How to Create user using oracle SQL Developer
- 20-How to create table using Oracle SQL Developer
- 21-How can I know the number of connected and make user disconnected
- 22-How to make disconnected user Connected
- 23-What are ROLES and Granting
- 24-Can any user create role
- 25 - Can User grant update on specific column
- 1- Can HR grants select on specific columns to Ramy
- 2-What and Why Views
- 3-Types Of Views and View Creation
- 4-How To Create a simple view
- 5-Replace existing View
- 6-Can we do DML operation on views
- 7-With Check option constraint in views
- 8-With Read Only constraint in views
- 9-What is the use of Force Keyword in views
- 10-Complex Views Example
- 11 - Drop Simple or Complex views
- 12-Complex Query Examle 1 with Views
- 13-Complex Query Example 2 with views
- 1-Types of functions
- 2-Single row functions Character Case Conversion
- 3-Single row Character manipulation functions
- 4-Single Row Number Functions and dual table
- 5-Single Row Date Functions
- 6-Single Row Conversion Functions
- 7-Single Row General Functions
- 1 - What is PL/SQL
- 2 - How can I write and execute PL/SQL
- 3 - print Hello World using PL/SQL through SQL*PLUS
- 4 - Print Hello World using Oracle SQL Developer
- 5 - How to declare variables
- 6- adding two numbers in PL/SQL
- 7 - Using Concatinating operator
- 8 - Nested Blocks then local and global variables
- 9 - using Into with variables in PL/SQL
- 10 - How to create user defined function
- 11 - How to execute functions
- 12 - User defined functions examples
- 13 - What is anchored data type and How we use it
- 14 - How to a function that return a row
- 15 - Can we do SQL DML Operations in functions
- 16 - Types of Parameter
- 17 - how to grant or revoke functions
- 18 - How to drop a function
- 19-What is and create and Execute a simple procedure
- 20-How to make a user create procedure or function
- 21- SQL DML Procedure Example
- 22-Types of procedures parameters with example
- 23-Differences between procedures and functions
- 24-How to use IF/ElSE conditions in PL/SQL
- 25-How to apply IF/ELSE condition on procedure or function
- 26-What is exception
- 27-Predefined Oracle Server Exceptions
- 28-Non Predefined exception
- 29-User defined exceptions