➤ 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
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
Subscribe to our newsletter and follow us on Facebook, Instagram, and Twitter to receive the latest tutorial and programs to improve your programming skills.