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...

Mô tả đầy đủ

Đã lưu trong:
Chi tiết về thư mục
Những tác giả chính: Juneau, Josh, Arena, Matt
Đị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