Oracle BASICS (1), Oracle BASICS (

Oracle BASICS (1), Oracle BASICS (

Oracle Database System is a group of software products with distributed databases as the core provided by Oracle in the United States. It is currently the most popular Client/Server) or one of the databases in the B/S architecture. For example, Oracle database is the most widely used database management system in the world. As a common database, it has complete data management capabilities. As a relational database, it is a product with complete relationships. As a distributed database, it implements distributed processing.

All of the above are the introduction of Oracle on the top of the encyclopedia. I wrote a little bit about myself. I used to think that Oracle was very complicated. I borrowed an Oracle book from the library and I was dizzy after reading a few chapters, the second time I learned how to watch videos and perform operations, I had a preliminary understanding of basic Oracle command operations, pl/SQL, user and database management. In general, it is similar to learning any database based on the skillful use of SQL server. The following blogs are a summary of Oracle videos.

When Will Oracle use it? First look at what kind of database is used what kind of occasions. Project scale, load, user, cost, security, and other aspects will be considered.

Small databases: including Access and Foxbase, suitable for applications with a load of less than 100 people, such as the message board and Information System. The cost is less than yuan, and the security requirements are not high.

Medium-sized databases: including Mysql and SQL server. For example, the load: The daily traffic is between 5000 and 15000, and the cost is within RMB, such as for business websites.

Large Databases: including Sybase, Oracle, DB2, etc. The load volume can process massive data. The specific comparison is Sybase <Oracle <DB2. high security and high cost.

About Alibaba El certification, basic OCA, intermediate OCP, and advanced OCM.

Oracle tools

First

Is a tool provided by oracle, mainly used to execute SQL statements, p1 \ slq1 Blocks

How to use:

1. Go to Start → program → oracle route home90 → application development → SQL * plus

2. Enter sqlpisw in the running column.

3. Choose Start> program> raoralorahome90> application development> SQL * plus worksheet.

Second

Enter slqplus in the running Column

Third

Enterprise Manager, start → program → oracle oraclehome90 → Enterprise Manager Console

Fourth

Pl/SQL developer third-party software, mainly used for development, testing, and optimization of oraclepl/SQL stored procedures such as triggers

This blog introduces the overview of oracle, And the next section describes Oracle operation commands.