What is the difference between plsql and oracle?

The difference between plsql and oracle: 1. Oracle is a database with a client and a server, while plsql Developer is a third-party tool that serves Oracle; 2. plsql is a SQL script language encapsulated by Oracle, which is the standard The SQL language has its own functions added to it.

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

What is the difference between plsql and oracle

1. plsql is a SQL script language encapsulated by Oracle. It is the same as Microsoft SQLSERVER's T-SQL, which is added to the standard SQL language. My own functions

and some special writing methods, such as string connection using " " in sqlserver and "||" in oracle.

sqlplus is Oracle's query analyzer, a tool for executing plsql statements, the same as Microsoft sqlserver's query analyzer.

2. ORACLE is a database, with client and server; PLSQL Developer is just a third-party tool that serves ORACLE. Similar tools include Toad, sqlplus, sql developer, etc. etc.; Installing PLSQL Developer has nothing to do with installing Oracle, but if there is no Oracle client, there is no point in installing PLSQL Developer

SQL*Plus is Oracle's own database management client, which can be found here Editing SQL statements is executed in command line mode.

There are two types of PL/SQL. One is the tool PL/SQL Developer, which is a database management client like SQL*Plus. It is a visual interface and you can also use the command line to edit SQL.

The other is PL/SQL language, which is a block structure language in Oracle. It is similar to a stored procedure and is a procedural language. The integration of SQL language and high-level programming language is similar to Java. You can develop PL/SQL language on SQL*Plus or PL/SQL Developer.

9l and before integrated the client and server, 10G and later are separated. The server is where the database is located. The client is just a tool that provides connection to the server and development related tools. SQL passes through the client. Send it to the server for parsing and execution. It is very troublesome to parse every time, so I simply throw some frequently used SQL on the server, and programmable functions come out: stored procedures, stored functions, triggers, etc., plsql is independent Language is just to better realize the concept of programmability.

Expand knowledge

PL/SQL

PL/SQL It is also a programming language called procedural SQL language (Procedural Language/SQL). PL/SQL is an extension of Oracle database to SQL statements. The features of programming languages ​​are added to the use of ordinary SQL statements, so PL/SQL organizes data operations and query statements into procedural units of PL/SQL code, and implements complex functions or calculations through logical judgments, loops and other operations.

PL/SQL (Procedural Language/SQL) is a procedural language and belongs to the third generation language. It focuses on processing details like C, C, Java and other languages, and can be used to implement more complex tasks. Business logic. It allows SQL's data manipulation language and query statements to be included in block structures (block_structured) and code procedural languages, making PL/SQL a powerful transaction processing language. In terms of Oracle database management, PL/SQL is a procedural language extension to Structured Query Language (SQL). The purpose of PL/SQL is to combine database languages ​​and procedural languages. The basic unit of PL/SQL is called a block, which consists of three parts: a declaration part, an execution part and an exception handling part.

Because PL/SQL allows mixing SQL statements and procedural structures, PL/SQL sections and subroutines can be used to combine SQL statements before sending the statement to the Oracle system for execution. Without PL/SQL, Oracle SQL statements need to be processed each time, which in a network environment affects traffic flow and increases response time. PL/SQL sections are compiled only once and stored in runnable form to reduce response time.

Oracle

Oracle's relational database management system

Oracle Database, also known as Oracle RDBMS, or Oracle for short. It is a relational database management system from Oracle Corporation. It is a product that has always been in the leading position in the database field. It can be said that the Oracle database system is a popular relational database management system in the world. The system has good portability, easy use, and strong functions. It is suitable for various large, medium, and small computer environments. It is a database solution that is efficient, reliable and adaptable to high throughput.

ORACLE database system is a set of software products with distributed database as the core provided by the American ORACLE company (Oracle). It is the most popular client/server (CLIENT/SERVER) or B/S architecture database. one. For example, SilverStream is a kind of middleware based on database. ORACLE database is the most widely used database management system in the world. As a general database system, it has complete data management functions; as a relational database, it is a complete relational product; as a distributed database, it implements distributed processing functions. But all its knowledge, as long as you learn ORACLE knowledge on one model, you can use it on various types of machines.

The latest version of Oracle database is Oracle Database 20c. Oracle Database 12c introduces a new multi-tenant architecture that makes it easy to deploy and manage database clouds. In addition, some innovative features can maximize resource utilization and flexibility, such as Oracle Multitenant to quickly integrate multiple databases, while Automatic Data Optimization and Heat Map can compress and tier data with higher density. These unique technology advancements, coupled with major enhancements in availability, security and big data support, make Oracle Database 12c an ideal platform for private and public cloud deployments.

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of What is the difference between plsql and oracle?. For more information, please follow other related articles on the PHP Chinese website!