Oracle Database Initial Contact

Oracle database is the world's largest database service company developed by Oracle, is currently one of the most mainstream commercial database server products, is widely used in enterprise-level application development, but also in the development of enterprise application systems, the most common relational database management system

Oracle is a cross-platform database, but the architecture is the same on the Unix/linux/windows platform.

A reference to Oracle's architecture, the so-called Oracle architecture, refers to the components of an Oracle database management system and the interrelationships between these components, including memory structures, background processes, physical and logical structures, and so on.

In general, Oracle has a range of physical structures such as data files, control files, online log files (Redo log buffer), parameter files (spfile or pfile), and their corresponding logical structures. , such as a tablespace (table space), a segment (Segment), a zone (Extent), a block, and so on, is called a database.

We also learned about MySQL data before learning the Oracle database so now we need to do some understanding and interpretation of the two different databases.

PL/SQL Overview

PL/SQL Like other programming languages, has its own character set, and a lexical unit consisting of strings (including reserved keywords, identifiers, literals, separators, annotations, data types, etc.)

Use statements to get and modify data in a database primarily

Oracle Database Initial Contact