Monday, December 26, 2011
Oracle Database Programming
Page 75 Chapter 7 Oracle Database Programming Srecko Howard Glen Van Der Vyver 7.1 Oracle Database Programming Overview This chapter defines the naming standards for Oracle database programming and provides a guide to the correct usage of Data Definition Language, Data Manipulation Language and PL/SQL statements. It also discusses a number of other database programming concepts. Information Systems Developers Handbook Page 76 The idea, thought of as revolutionary not many years ago, that data could be independent of applications, heralded
the rapid evolution of the database. Today, an overwhelming majority of applications are database-driven. The database is a key corporate asset, often constituting the margin between success and failure. As the use of databases became more pervasive, the need arose to develop a language that could extract and manipulate data in the database. Hence Structured Query Language (SQL) was born. This language works in a fundamentally different way to languages such as C++ or COBOL, which are often referred to as ‘procedural’ programming languages. Code written in these languages implies an end result by explicitly defining the means or procedures to get there. In contrast, SQL explicitly defines the end result, leaving it up to the data base management system (DBMS) to determine the method of obtaining the data. SQL is, therefore, a relatively simple language with a limited syntax. Although many standards exist for the structure and mathematical underpinnings of SQL, commercial programming standards have been uncommon. The only widely applied standard for many years was that a SQL statement must be spread over multiple lines. Databases have changed dramatically in recent years. The database is no longer just the repository of raw information. Today, the knowledge of the…
Website: www.usq.edu.au | Filesize: 92kb
No of Page(s): 18
Download Oracle Database Programming.pdf
