Oracle and PL/SQL Recipes: A Problem-Solution Approach
Oracle Database is one of the most advanced relational databases available. It includes technologies that empower you to work with your data in ways that no other database offers. In the early days of Oracle Database, Structured Query Language (SQL) was used to work directly with the data, but as...
Đã lưu trong:
Những tác giả chính: | , |
---|---|
Định dạng: | Sách |
Ngôn ngữ: | English |
Được phát hành: |
Apress
2012
|
Những chủ đề: | |
Truy cập trực tuyến: | https://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/31566 |
Các nhãn: |
Thêm thẻ
Không có thẻ, Là người đầu tiên thẻ bản ghi này!
|
Thư viện lưu trữ: | Thư viện Trường Đại học Đà Lạt |
---|
id |
oai:scholar.dlu.edu.vn:DLU123456789-31566 |
---|---|
record_format |
dspace |
spelling |
oai:scholar.dlu.edu.vn:DLU123456789-315662014-01-20T06:04:12Z Oracle and PL/SQL Recipes: A Problem-Solution Approach Juneau, Josh Arena, Matt Technologies Oracle Database is one of the most advanced relational databases available. It includes technologies that empower you to work with your data in ways that no other database offers. In the early days of Oracle Database, Structured Query Language (SQL) was used to work directly with the data, but as time went on, people turned to other languages outside the database for performing more sophisticated tasks with data. Although these procedural languages offered a powerful way to harness data, developers and database administrators wanted a language that was easier to use and bound more closely to the data. Oracle Corporation addressed that need by introducing Procedural Language/Structured Query Language (PL/SQL) into Oracle Database in release 7. This language offered the best of both worlds, allowing developers and database administrators to work directly with data via SQL and perform routine programming tasks within the database. The PL/SQL programming language was influenced by the Ada programming language. In fact, the syntax is much the same as Ada. When PL/SQL was originated, it contained many constructs that are available in other languages, including variables and arrays. In Oracle Database 8, the language began to take on more of an object-oriented dialect, allowing developers to create types and develop applications in a way that was more in tune with other modern-day languages. The language continues to grow, adding new features with each release of Oracle Database and making PL/SQL an essential tool for anyone programming against an Oracle Database. PL/SQL can be quite powerful for performing routine database tasks such as creating, returning, updating, and deleting records. However, its capabilities go far beyond performing the routine tasks. Database administrators can use PL/SQL to create powerful database procedures and queries among other things, and developers can use it for developing sophisticated web-based applications, working with stored Java classes, and much more. 2012-08-24T08:06:51Z 2012-08-24T08:06:51Z 2010 Book 978-1-4302-3207-0 978-1-4302-3208-7 https://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/31566 en application/pdf Apress |
institution |
Thư viện Trường Đại học Đà Lạt |
collection |
Thư viện số |
language |
English |
topic |
Technologies |
spellingShingle |
Technologies Juneau, Josh Arena, Matt Oracle and PL/SQL Recipes: A Problem-Solution Approach |
description |
Oracle Database is one of the most advanced relational databases available. It includes technologies that
empower you to work with your data in ways that no other database offers. In the early days of Oracle
Database, Structured Query Language (SQL) was used to work directly with the data, but as time went
on, people turned to other languages outside the database for performing more sophisticated tasks with
data. Although these procedural languages offered a powerful way to harness data, developers and
database administrators wanted a language that was easier to use and bound more closely to the data.
Oracle Corporation addressed that need by introducing Procedural Language/Structured Query
Language (PL/SQL) into Oracle Database in release 7. This language offered the best of both worlds,
allowing developers and database administrators to work directly with data via SQL and perform routine
programming tasks within the database.
The PL/SQL programming language was influenced by the Ada programming language. In fact, the
syntax is much the same as Ada. When PL/SQL was originated, it contained many constructs that are
available in other languages, including variables and arrays. In Oracle Database 8, the language began to
take on more of an object-oriented dialect, allowing developers to create types and develop applications
in a way that was more in tune with other modern-day languages. The language continues to grow,
adding new features with each release of Oracle Database and making PL/SQL an essential tool for
anyone programming against an Oracle Database.
PL/SQL can be quite powerful for performing routine database tasks such as creating, returning,
updating, and deleting records. However, its capabilities go far beyond performing the routine tasks.
Database administrators can use PL/SQL to create powerful database procedures and queries among
other things, and developers can use it for developing sophisticated web-based applications, working
with stored Java classes, and much more. |
format |
Book |
author |
Juneau, Josh Arena, Matt |
author_facet |
Juneau, Josh Arena, Matt |
author_sort |
Juneau, Josh |
title |
Oracle and PL/SQL Recipes: A Problem-Solution Approach |
title_short |
Oracle and PL/SQL Recipes: A Problem-Solution Approach |
title_full |
Oracle and PL/SQL Recipes: A Problem-Solution Approach |
title_fullStr |
Oracle and PL/SQL Recipes: A Problem-Solution Approach |
title_full_unstemmed |
Oracle and PL/SQL Recipes: A Problem-Solution Approach |
title_sort |
oracle and pl/sql recipes: a problem-solution approach |
publisher |
Apress |
publishDate |
2012 |
url |
https://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/31566 |
_version_ |
1819792360143323136 |