毕业设计外文文献—什么是PLSQ.docx

附录A 外文翻译—原文部分 引用自《Oracle PLSQL Programming》——Steven Feuerstein What is PLSQL Oracles PL/SQL language has several defining features: It is a highly structured, readable and easy to use language, and if you are not familiar with programming, PL/SQL is a good starting point. You will find Its an easy-to-learn language with clear keywords and structure to express the intent of your code. If you have experience with other programming languages, you will easily adapt to the new syntax. It is a standard and portable language developed by Oracle. If you write a PL/SQL procedure or function to execute a database sitting in your laptop on Oracle, you can move the same process to the database to execute it on your corporate network. Without making any changes. Once written, running everywhere is the slogan of PL/SQL long before Java appeared. But for PL / SQL, ubiquitous means there are Oracle databases everywhere. It is an embedded language PL / SQL that is not designed to be used as a stand-alone language, but is used in a host environment. So, for example, you can run a PL/SQL program from a database (for example, via the SQL*Plus interface). Alternatively, you can define and execute a PL/SQL program in an Oracle De-veloper form or report (this method is called client PL/SQL). However, you cannot create a PL/SQL executable that can run on its own. It is a high performance, highly integrated database language. Now, when youre writing software to run an Oracle database, you have a lot of options. You can use Java and JDBC; you can use Visual Basic and ODBC; you can use Delphi, C++, etc. However, you will find it easier to write efficient code in any other language to access an Oracle database in PL/SQL. In particular, Oracle provides some PL/SQL-specific enhancements, such as the FORALL statement, which can increase database performance by an order of magnitude or more. PLSQL origin Oracle has been leading the software industry, providing a declarative, non-procedural approac