Apress Source Code

This repository accompanies Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON by Alex Nuijten and Patrick Barel (Apress, 2023).

Download the files as a zip using the green button, or clone the repository to your machine using Git.

Releases

Release v1.0 corresponds to the code in the published book, without corrections or updates.

Contributions

See the file Contributing.md for more information on how you can contribute to this repository.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Repository files navigation

Apress Source Code

Releases

Contributions

About

Uh oh!

Releases

Packages

Uh oh!

Contributors 3

Uh oh!

Languages

Name		Name	Last commit message	Last commit date
Latest commit History 11 Commits
9781484291658.jpg		9781484291658.jpg
Contributing.md		Contributing.md
F1Data_Comments.sql		F1Data_Comments.sql
F1Data_Create_Credential.sql		F1Data_Create_Credential.sql
F1Data_Create_User.sql		F1Data_Create_User.sql
F1Data_Grants_And_Synonyms.sql		F1Data_Grants_And_Synonyms.sql
F1Data_Import_Data.sql		F1Data_Import_Data.sql
F1Data_Separated_PTF.sql		F1Data_Separated_PTF.sql
F1Data_Tables.sql		F1Data_Tables.sql
LICENSE.txt		LICENSE.txt
Listing 1-1. Merge the results into the constructorresults table.sql		Listing 1-1. Merge the results into the constructorresults table.sql
Listing 1-10. using forall with save exceptions.sql		Listing 1-10. using forall with save exceptions.sql
Listing 1-2. Display the names of the Dutch drivers.sql		Listing 1-2. Display the names of the Dutch drivers.sql
Listing 1-3. Display the names of the Dutch drivers using the limit clause.sql		Listing 1-3. Display the names of the Dutch drivers using the limit clause.sql
Listing 1-4. using forall with the range option.sql		Listing 1-4. using forall with the range option.sql
Listing 1-5. using forall with the indices of option.sql		Listing 1-5. using forall with the indices of option.sql
Listing 1-6. using forall with the values of option.sql		Listing 1-6. using forall with the values of option.sql
Listing 1-7. Compound Trigger tr_constructors_cti.sql		Listing 1-7. Compound Trigger tr_constructors_cti.sql
Listing 1-8. after row trigger on results to update the constructorresults.sql		Listing 1-8. after row trigger on results to update the constructorresults.sql
Listing 1-9. compound trigger on results to update the constructorresults.sql		Listing 1-9. compound trigger on results to update the constructorresults.sql
Listing 10-1. A function with the pragma udf in place..sql		Listing 10-1. A function with the pragma udf in place..sql
Listing 10-2. a very slow function.sql		Listing 10-2. a very slow function.sql
Listing 10-3. a very slow deterministic function.sql		Listing 10-3. a very slow deterministic function.sql
Listing 10-4. a very slow result_cache function.sql		Listing 10-4. a very slow result_cache function.sql
Listing 10-5. f1info package.sql		Listing 10-5. f1info package.sql
Listing 10-6. f1info package body.sql		Listing 10-6. f1info package body.sql
Listing 10-7. script to generate an HTML document.sql		Listing 10-7. script to generate an HTML document.sql
Listing 10-8. script to generate profile data in the tables.sql		Listing 10-8. script to generate profile data in the tables.sql
Listing 10-9. Show analysed data.sql		Listing 10-9. Show analysed data.sql
Listing 12-1. The sample JSON document.json		Listing 12-1. The sample JSON document.json
Listing 15-1. Get the current season of F1 races from a webservice.sql		Listing 15-1. Get the current season of F1 races from a webservice.sql
Listing 15-10. Preserve the layout of a multiline message.sql		Listing 15-10. Preserve the layout of a multiline message.sql
Listing 15-11. Retrieving my initials.sql		Listing 15-11. Retrieving my initials.sql
Listing 15-12. Constants for the different file headers.sql		Listing 15-12. Constants for the different file headers.sql
Listing 15-13. Extract the column names from the file.sql		Listing 15-13. Extract the column names from the file.sql
Listing 15-14. Move the data from the file into the table.sql		Listing 15-14. Move the data from the file into the table.sql
Listing 15-2. Setting Request Headers.sql		Listing 15-2. Setting Request Headers.sql
Listing 15-3. One variable, different endpoints per environment.sql		Listing 15-3. One variable, different endpoints per environment.sql
Listing 15-4. Formatted JSON response.json		Listing 15-4. Formatted JSON response.json
Listing 15-5. Extracting values from JSON document.sql		Listing 15-5. Extracting values from JSON document.sql
Listing 15-6. How far is my hometown from the Zandvoort Circuit.sql		Listing 15-6. How far is my hometown from the Zandvoort Circuit.sql
Listing 15-7. Example usage of apex_string.split.sql		Listing 15-7. Example usage of apex_string.split.sql
Listing 15-8. Example usage of apex_string.join.sql		Listing 15-8. Example usage of apex_string.join.sql
Listing 15-9. A nicely formatted error message with variables.sql		Listing 15-9. A nicely formatted error message with variables.sql
Listing 17-1. Creating an Application Context.sql		Listing 17-1. Creating an Application Context.sql
Listing 17-2. modp_pkg to communicate to the context.sql		Listing 17-2. modp_pkg to communicate to the context.sql
Listing 17-3. module and action usage.sql		Listing 17-3. module and action usage.sql
Listing 17-4. Package to demonstrate dbms_utility.format_call_stack.sql		Listing 17-4. Package to demonstrate dbms_utility.format_call_stack.sql
Listing 17-5. Package to demonstrate the error stack procedures.sql		Listing 17-5. Package to demonstrate the error stack procedures.sql
Listing 17-6. A view containing all the drivers per constructor.sql		Listing 17-6. A view containing all the drivers per constructor.sql
Listing 17-7. Display drivers per constructor.sql		Listing 17-7. Display drivers per constructor.sql
Listing 17-8. utl_call_stack_demo template.sql		Listing 17-8. utl_call_stack_demo template.sql
Listing 18-1. create drivercontracts table.sql		Listing 18-1. create drivercontracts table.sql
Listing 18-2. Policy Function thisconstructoronly.sql		Listing 18-2. Policy Function thisconstructoronly.sql
Listing 18-3. context_pkg to communicate with the constructor_ctx.sql		Listing 18-3. context_pkg to communicate with the constructor_ctx.sql
Listing 18-4. Constructor can only see information of its own drivers..sql		Listing 18-4. Constructor can only see information of its own drivers..sql
Listing 18-5. driver context.sql		Listing 18-5. driver context.sql
Listing 2-1. Running total for a single driver.sql		Listing 2-1. Running total for a single driver.sql
Listing 2-2. Reusable windowing clause.sql		Listing 2-2. Reusable windowing clause.sql
Listing 20-1 script to create the drivers_ext external table.sql		Listing 20-1 script to create the drivers_ext external table.sql
Listing 20-2 create immutable table dutchdrivers.sql		Listing 20-2 create immutable table dutchdrivers.sql
Listing 20-3 create blockchain table dutchdrivers.sql		Listing 20-3 create blockchain table dutchdrivers.sql
Listing 6-10 Testing exception package body.sql		Listing 6-10 Testing exception package body.sql
Listing 6-11 Code for development environment only.sql		Listing 6-11 Code for development environment only.sql
Listing 6-12 create the environment package.sql		Listing 6-12 create the environment package.sql
Listing 6-13 post processed demo.sql		Listing 6-13 post processed demo.sql
Listing 6-2 What version are we running.sql		Listing 6-2 What version are we running.sql
Listing 6-3 This code will not compile successfully.sql		Listing 6-3 This code will not compile successfully.sql
Listing 6-4 deprecated warnings.sql		Listing 6-4 deprecated warnings.sql
Listing 6-5 Include code depending on database version.sql		Listing 6-5 Include code depending on database version.sql
Listing 6-6 Use the new iterator if available.sql		Listing 6-6 Use the new iterator if available.sql
Listing 6-7 Package specification with conditionally exposed programs.sql		Listing 6-7 Package specification with conditionally exposed programs.sql
Listing 6-8 Package body with all the programs implemented.sql		Listing 6-8 Package body with all the programs implemented.sql
Listing 6-9 Testing exceptions package specification.sql		Listing 6-9 Testing exceptions package specification.sql
Listing 7-1. Multiple iterations pre 21c.sql		Listing 7-1. Multiple iterations pre 21c.sql
Listing 7-10. Cursor-for-loop displaying information.sql		Listing 7-10. Cursor-for-loop displaying information.sql
Listing 7-11. Cursor-For-Loop with predefined record type.sql		Listing 7-11. Cursor-For-Loop with predefined record type.sql
Listing 7-12. display information package.sql		Listing 7-12. display information package.sql
Listing 7-13. Try to assign a value to the iterator.sql		Listing 7-13. Try to assign a value to the iterator.sql
Listing 7-14. Make the iterator mutable.sql		Listing 7-14. Make the iterator mutable.sql
Listing 7-15. Make the iterator immutable.sql		Listing 7-15. Make the iterator immutable.sql
Listing 7-16. Reversestring procedure.sql		Listing 7-16. Reversestring procedure.sql
Listing 7-17. Use loops to assign values pre 21c.sql		Listing 7-17. Use loops to assign values pre 21c.sql
Listing 7-18. Use loop inside array in 21c.sql		Listing 7-18. Use loop inside array in 21c.sql
Listing 7-19. Displaying a sparse collection pre 21c.sql		Listing 7-19. Displaying a sparse collection pre 21c.sql
Listing 7-2. Multiple iterations 21c and up.sql		Listing 7-2. Multiple iterations 21c and up.sql
Listing 7-20. Displaying a sparse collection since 21c.sql		Listing 7-20. Displaying a sparse collection since 21c.sql
Listing 7-21. Displaying the values of a collection since 21c.sql		Listing 7-21. Displaying the values of a collection since 21c.sql
Listing 7-22. Using values of with records.sql		Listing 7-22. Using values of with records.sql
Listing 7-23. Use index iterator to get value..sql		Listing 7-23. Use index iterator to get value..sql
Listing 7-24. Use pairs of to get index and value.sql		Listing 7-24. Use pairs of to get index and value.sql
Listing 7-25. Using pairs of with records.sql		Listing 7-25. Using pairs of with records.sql
Listing 7-26. Initializing variable pre-18c.sql		Listing 7-26. Initializing variable pre-18c.sql
Listing 7-27. Initializing variable in initialisation pre-18c.sql		Listing 7-27. Initializing variable in initialisation pre-18c.sql
Listing 7-28. Initializing variable in initialisation 18c.sql		Listing 7-28. Initializing variable in initialisation 18c.sql
Listing 7-29. Initializing collections pre-18c.sql		Listing 7-29. Initializing collections pre-18c.sql
Listing 7-3. Stepped iteration pre 21c.sql		Listing 7-3. Stepped iteration pre 21c.sql
Listing 7-30. Initializing collections 18c.sql		Listing 7-30. Initializing collections 18c.sql
Listing 7-31. Initializing dense collections 21c.sql		Listing 7-31. Initializing dense collections 21c.sql
Listing 7-32. Initializing collections using cursor 21c.sql		Listing 7-32. Initializing collections using cursor 21c.sql

License

Apress/modern-oracle-database-programming

Folders and files

Latest commit

History

Repository files navigation

Apress Source Code

Releases

Contributions

About

Resources

License

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Uh oh!

Contributors 3

Uh oh!

Languages

Packages