Programming Productively

Oracle SQL developer is designed to help the user work efficiently and effectively with PL/SQL constructs. This developer can help in improving your productivity as it makes use of efficient methods to debug code that won't compile, locate constructs the user wants to reuse, test your code, and learn how much time your program spends in each subprogram. This paper discusses how to create, edit, and run PL/SQL code efficiently, how to work with stored procedures and packages productively, and provides access to Oracle Database 11g features that enable PL/SQL hierarchical profiling and highly detailed search. Oracle SQL Developer can be used to create anonymous PL/SQL blocks. In SQL Developer anonymous blocks are not stored in the database, which means one can use them to test a piece of functionality quickly. It can be used in the SQL worksheet, where it can be used to insert a new row in the declaration section. It also helps in navigating to the point of error. Not only does it find the error, it also finds the code and reruns it. It offers code refactoring, which means it does not change the meaning or function of any code one modifies. Oracle SQL Developer provides convenient features for creating and maintaining both the specifications and bodies of PL/SQL packages. This paper also supports a section for Oracle Database 11g as it lets one determine how much time is spent on each subprogram within a program, how frequently a subprogram is accessed, and which other subprograms access a program.