Oracle PL/SQL For DBAs by Arup Nanda, Steven Feuerstein

By Arup Nanda, Steven Feuerstein

PL/SQL, Oracle's strong procedural language, has been the cornerstone of Oracle software improvement for almost 15 years. even though essentially a device for builders, PL/SQL has additionally turn into a vital device for database management, as DBAs take expanding accountability for web site functionality and because the traces among builders and DBAs blur.

Show description

Read Online or Download Oracle PL/SQL For DBAs PDF

Similar oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle types, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication allow real-time details entry and information sharing throughout your disbursed framework utilizing the specialist details during this Oracle Press consultant. Oracle Streams 11g information Replication explains how one can arrange and administer a unified company info sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle program convey four Recipes presents an example-based method of studying software convey - the ground-breaking, quick program improvement platform incorporated with each Oracle Database license. The recipes layout is perfect for the quick-study who simply desires a great instance or to kick commence their pondering and get pointed within the correct course.

Additional info for Oracle PL/SQL For DBAs

Sample text

Dollar_amount; The formal parameters of tot_sales are: company_id_in Primary key of the company status_in Status of the orders to be included in the sales calculation These formal parameters do not exist outside of the function. You can think of them as placeholders for real or actual parameter values that are passed into the function when it is used in a program. How does PL/SQL know which actual parameter goes with which formal parameter when a program is executed? PL/SQL offers two ways to make the association: Positional notation Associates the actual parameter implicitly (by position) with the formal parameter.

Rules for calling packaged elements It doesn't really make any sense to talk about running or executing a package (after all, it is just a container for code elements). However, you will certainly want to run or reference those elements defined in a package. A package owns its objects, just as a table owns its columns. To reference an element defined in the package specification outside of the package itself, you must use the same dot notation to fully specify the name of that element. Let's look at some examples.

LIMIT function Returns the maximum number of elements allowed in a VARRAY. PRIOR, NEXT functions Return the subscript immediately before (PRIOR) or after (NEXT) a specified subscript. You should always use PRIOR and NEXT to traverse a collection, especially if you are working with sparse (or potentially sparse) collections. TRIM procedure Removes collection elements from the end of the collection (highest defined subscript). Reduces COUNT if elements are not DELETEd. These programs are referred to as methods because the syntax for using the collection built-ins is different from the normal syntax used to call procedures and functions.

Download PDF sample

Rated 4.39 of 5 – based on 49 votes