➤ Java Bean with Examples
➤ How to Code a Game
➤ Array Programs in Java
➤ Java Inline Thread Creation
➤ Java Custom Exception
➤ Hibernate vs JDBC
➤ Object Relational Mapping
➤ Check Oracle DB Size
➤ Check Oracle DB Version
➤ Generation of Computers
➤ XML Pros & Cons
➤ Git Analytics & Its Uses
➤ Top Skills for Cloud Professional
➤ How to Hire Best Candidates
➤ Scrum Master Roles & Work
➤ CyberSecurity in Python
➤ Protect from Cyber-Attack
➤ Solve App Development Challenges
➤ Top Chrome Extensions for Twitch Users
➤ Mistakes That Can Ruin Your Test Metric Program
➤ How to Code a Game
➤ Array Programs in Java
➤ Java Inline Thread Creation
➤ Java Custom Exception
➤ Hibernate vs JDBC
➤ Object Relational Mapping
➤ Check Oracle DB Size
➤ Check Oracle DB Version
➤ Generation of Computers
➤ XML Pros & Cons
➤ Git Analytics & Its Uses
➤ Top Skills for Cloud Professional
➤ How to Hire Best Candidates
➤ Scrum Master Roles & Work
➤ CyberSecurity in Python
➤ Protect from Cyber-Attack
➤ Solve App Development Challenges
➤ Top Chrome Extensions for Twitch Users
➤ Mistakes That Can Ruin Your Test Metric Program
Oracle Database (commonly referred to as Oracle DBMS or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation.
An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is a key to solving the problems of information management.
SQL
Operators in Oracle database
DDL Commands (Data Definition Language)
- DDL commands
- CREATE command
- RENAME command
- DROP command
- TRUNCATE command
- ALTER command
- ALTER … ADD
- ALTER … RENAME
- ALTER … MODIFY
- ALTER … DROP
Oracle Pre-defined Functions
- Number or Math functions in Oracle
- Date functions in Oracle
- Character or String functions in Oracle
- Conversion Functions
- Count Analytical Function In Oracle
- Oracle Max Function with Examples
Clauses used in the SELECT statement,
Oracle Constraints
- Constraints in Oracle
- Rename Constraint
- Disable Constraint
- Drop Constraint
- NOT NULL Constraint
- UNIQUE Constraint
- PRIMARY KEY Constraint
- FOREIGN KEY Constraint
- CHECK Constraint
Joins in Oracle database
- Joins in Oracle database
- INNER Join
- LEFT OUTER Join
- RIGHT OUTER Join
- FULL OUTER Join
- SELF Join
- CROSS Join
PL/SQL
Others
- How to unlock Scott user in SQL Plus
- How to Find SID in Oracle database
- Check Oracle Database Version
- Check Database Size in Oracle
- Error ORA 01031 insufficient privileges
- Oracle List Users
- Oracle Show Current User
- List Schemas in Oracle
- Oracle Change User Password
Latest
- 2nd Last Record SQL in Oracle
- Oracle Purge Recyclebin
- Oracle Convert Varchar2 to Date
- Oracle Change Column Length Varchar2
- Oracle Drop Table If Exists And Create
- Drop All Tables Oracle
- Truncate AUD$ table in Oracle 12c
- Oracle Make Table Read Only
- Oracle Semi Join
- Ora-12899 Value Too Large For Column Oracle
- Copy Data From One Column To Another in Oracle
- Oracle Hide Column From User
- How To Copy Table Data To Another In Oracle
- NVL Function in Oracle
- Coalesce in Oracle
- GraphQL vs SQL
Subscribe to our newsletter and follow us on Facebook, Instagram, and Twitter to receive the latest tutorial and programs to improve your programming skills.