➤ 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 Database Size
➤ Check Oracle Database Version
➤ Generation of Computers
➤ XML Advantages & Disadvantages
➤ Advantages of Open Source Software
➤ How to read and display .class file version
➤ Java Program Without Using User-defined Class
➤ How to Code a Game
➤ Array Programs in Java
➤ Java Inline Thread Creation
➤ Java Custom Exception
➤ Hibernate vs JDBC
➤ Object Relational Mapping
➤ Check Oracle Database Size
➤ Check Oracle Database Version
➤ Generation of Computers
➤ XML Advantages & Disadvantages
➤ Advantages of Open Source Software
➤ How to read and display .class file version
➤ Java Program Without Using User-defined Class
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
Subscribe to our newsletter and follow on Facebook, Instagram, Twitter to receive the latest tutorial and programs to improve your programming skills.
