Paper on JDeveloper as tool for PL/SQL Development

Lucas Jellema 2
0 0
Read Time:1 Minute, 19 Second

Tonight I completed a paper on using JDeveloper as a tool for Database Design and Generation as well as PL/SQL Development. This paper is in Dutch and will be published in the January issue of Optimize, the Dutch Oracle Professional Magazine. The article also briefly introduces two open source tools for Database Browsing: SQuirreL and TOra (see posts on these tools on our weblog). It also mentions several more.

On JDeveloper the paper discusses the SQL Worksheet (with Explain Plan option) and the Database Browser en Edit Object Wizards. It goes into the Database Design features for Diagrams, Off Line Database Objects, Design Capture, Synchronize and Generate DDL options. It discusses at some length the PL/SQL editor and debugger – introducing the concept of remote debugging. Finally it briefly mentions Publishing PL/SQL packages as WebServices, Loading Java Classes into the database – and wrapping them with PL/SQL package interfaces and finally the Oracle BPEL plugin for JDeveloper.

You can find the paper itself at: Download Paper Earlier parts in this series discussed Generation of Technical Documentation for PL/SQL and Oracle Forms (using PLDoc and FoReDoclet), Unit Testing and Automating Batch Tasks – utPLSQL and Ant and finally Design by Contract and Implement Generic Logging using Log4J

Resources

A number of – English – resources listed in the article:
• Designing, Modelling And Generating Database Tables
• Developing SQL and PL/SQL with JDeveloper
• Publish PL/SQL as WebService
• Calling a Web Service From The Database
• JPublisher User’s Guide
• Oracle JDeveloper for Database Developers and DBAs – An Oracle Whitepaper, January 2005

About Post Author

Lucas Jellema

Lucas Jellema, active in IT (and with Oracle) since 1994. Oracle ACE Director and Oracle Developer Champion. Solution architect and developer on diverse areas including SQL, JavaScript, Kubernetes & Docker, Machine Learning, Java, SOA and microservices, events in various shapes and forms and many other things. Author of the Oracle Press book Oracle SOA Suite 12c Handbook. Frequent presenter on user groups and community events and conferences such as JavaOne, Oracle Code, CodeOne, NLJUG JFall and Oracle OpenWorld.
Happy
Happy
0 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleepy
Sleepy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

2 thoughts on “Paper on JDeveloper as tool for PL/SQL Development

Comments are closed.

Next Post

How to lookup information based on IP address - e.g. for Website-visitors

During the last few years I have had several occasions to wonder who used the website and web-applications I had helped develop and deploy. Most recently I had this very same question for our weblog: we have had over 36000 different IP-addresses visiting our website and I have not got […]
%d bloggers like this: