pl/sql Resources

ZDNet Dictionary Definition

PL/SQL: (Procedural Language/SQL) A programming language from Oracle that is used to write triggers and stored procedures that are executed by the Oracle DBMS. It is also used to...; Full PL/SQL Definition >>

ZDNet Resources

Oracle Reports Barcode PLL with PL/SQL Source (zip): Add barcodes to Oracle Reports with this library. The barcode library is a PLL file of subprograms that format data from fields in the report to barcode fonts. It works cross-platform on Windows, Linux and Unix. Code 128, GS1-128, Postnet, Planet, Interleaved 2 of 5, ITF, UPC-A, EAN-13, and EAN-8...; Tags: Oracle Corp., PL/SQL, Library, Font, IDAutomation, Barcode Library, Linux, Operating Systems, Software; Software downloads 2008-02-27
OraDeveloper Tools for VS.NET (exe): Powerful Visual Studio add-in designed to automate and simplify the process of developing applications with Oracle. OraDeveloper Tools integrates into Visual Studio .NET and lets you quickly browse, query, and update Oracle databases from your development environment. Optimized for PL/SQL development with an SQL and PL/SQL debugger, code completion, code...; Tags: Microsoft Visual Studio, Oracle Corp., Microsoft Visual Studio.Net, PL/SQL, OraDeveloper Tools, Microsoft Development Tools, Programming Languages, .Net, Databases, Development Tools, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Software downloads 2007-11-27
GoldFish.Net (exe): GoldFish.Net is to develop, manage, and maintain your Oracle databases. This Careware application offers an ever expanding set of features such as a Schema Browser with QuickEdit functionality allowing you to update your application code within a single interface. GoldFish.Net also offers an integrated Report Builder allowing you to build...; Tags: Environment, PL/SQL, SQL, GoldFish.Net, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Software downloads 2007-11-20
Working With PL/SQL: Among its other features, Oracle SQL Developer provides database developers and DBAs with a comprehensive environment for creating, editing, compiling, running, and debugging PL/SQL program units. Its editing capabilities include customizable syntax highlighting, bookmarks, code completion, code folding, and search/replace. The debugging features are especially useful for working with more-complex...; Tags: Oracle Corp., PL/SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; White papers 2007-11-01
PL/SQL Enhancements in Oracle Database 11g: Oracle Database 11g brings PL/SQL enhancements in these categories: transparent and "Knob-controlled" performance improvements; new language features that one uses in the programs to get better performance; new language features that bring functionality which one earlier couldn't achieve, or could achieve only with cumbersome workarounds and new language features that...; Tags: Oracle Corp., PL/SQL, Oracle Database, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; White papers 2007-11-01

More on Oracle Database 11g: PL/SQL is Oracle's procedural extension to SQL, and it is a true 3GL programming language. It was first introduced way back in version 6 of the database, giving the ability to code "Anonymous blocks" in the client applications and submit them for processing on the database. In Oracle6, there were...; Tags: Oracle Corp., PL/SQL, Oracle Database, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; White papers 2007-11-01
Oraspeed SQL Editor (exe): Using this Oracle IDE you can write and test Queries. Create, Compile, Execute and Debug your PL/SQL Programs. Execute Anonymous PL/SQL Blocks. Create/Edit Database object using advanced wizards. TKProf, PL/SQL Profiler, Parent Child Tables Data Explorer, Built-in reports, BLOB Editor, Oraspeed Security Module, Multithreading and much more. This database tool...; Tags: Oracle Corp., PL/SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Software downloads 2007-08-31
OraDeveloper Tools for VS 2005 (exe): Powerful Visual Studio add-in designed to automate and simplify the process of developing applications with Oracle. OraDeveloper Tools integrates into Visual Studio 2005 and lets you quickly browse, query, and update Oracle databases from your development environment. Optimized for PL/SQL development with an SQL and PL/SQL debugger, code completion, code...; Tags: Microsoft Visual Studio, Oracle Corp., Microsoft Visual Studio 2005, PL/SQL, OraDeveloper Tools, Microsoft Development Tools, Programming Languages, Databases, Development Tools, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Software downloads 2007-07-13
Researcher issues Oracle DB 'cursor injection' warning: David Litchfield's ongoing assault on Oracle databases has unearthed a new method of exploiting PL/SQL injection vulnerabilities.Litchfield, co-founder and managing director at NGSS Next Generation Security Software, plans to discuss the new technique at the Black Hat DC 2007 conference later this week.In a paper PDF released ahead of the...; Tags: Black Hat, Data theft, Exploit code, Hackers, Oracle, Pen testing, Responsible disclosure, Vulnerability research, Zero-day attacks; Blog posts 2007-02-26
Using PL/SQL Associative Arrays: Suppose one has just received an e-mail detailing several IT initiatives, two of which will affect the future application development techniques. First, all applications should be designed to minimize network utilization. And second, applications that use Oracle databases must use PL/SQL for access to the database structures. Knowing that one...; Tags: Network, PL/SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; White papers 2007-01-01
Toad for Oracle (zip): TOAD empowers developers and DBAs to be more productive by providing an intuitive graphical user interface to Oracle. TOAD is a low-overhead tool that makes PL/SQL development faster and easier and simplifies database administration tasks. Advanced editors allow users to work on multiple files simultaneously even different file types such...; Tags: Oracle Corp., PL/SQL, Quest Software Inc., TOAD, Databases, Storage, Programming Languages, Enterprise Software, Software, Data Management, Hardware, Software Development, Software/Web Development; Software downloads 2006-10-24
Pl/Sql Tidy (exe): This freeware software allows you to tidy/beautify/format your PlSql code in a batch file or Dos prompt. In other words, it is a command line tool that gives you the freedom to build it in your programming environment. You can use it in your favorite editor easily.; Tags: Freeware, PL/SQL; Software downloads 2006-09-14
Debugging PL/SQL From .NET: Debugging PL/SQL code in Microsoft Visual Studio is as easy as debugging native .NET code, thanks to the PL/SQL debugger in Oracle Developer Tools for Visual Studio .NET ODT. This paper demonstrates how to set up PL/SQL debugging in ODT and how to create and step through PL/SQL code from...; Tags: Microsoft .NET, Oracle Corp., PL/SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; White papers 2006-09-01
Guggi-Oracle (zip): Database Development, Administration, PL/SQL programming and data analysis tool for Oracle 8.0, 8i, 9i and 10g. Are browse the database for 32 different types of objects such as table, view, synonym, constraints, function, index, trigger, sequence, schema, tablespace, procedure, package, materialized view, database link, type, rollback segment, directory, operator, library,...; Tags: PL/SQL, Databases, Storage, Programming Languages, Enterprise Software, Software, Data Management, Hardware, Software Development, Software/Web Development; Software downloads 2006-04-19
Wrapping Your Brain Around Oracle + Python: PL/SQL is ideal for programming tasks within Oracle Database. Most Oracle professionals, however, aren't confined to working strictly within the database itself. The users have probably encountered many tasks for which PL/SQL has proven clumsy or even unusable - such as manipulating files on disk, invoking external programs or shell...; Tags: Oracle Corp., Python, PL/SQL, Programming Languages, Databases, Development Tools, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; White papers 2006-03-01
Isidian SQL Insight Professional (exe): Isidian SQL Insight Professional is an Oracle development and tuning tool providing the ability to develop, debug, test, and optimize their SQL and PL/SQL code. The development capabilities supplied include a robust development environment complete with powerful coding editors and development aids, result grids that allow for easy data analysis...; Tags: PL/SQL, SQL, Isidian SQL Insight Professional, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Software downloads 2005-10-21
PL/SQL Conditional Compilation: Oracle Database 10g Release 2 delivers a new PL/SQL language feature: conditional compilation. The feature is elegant, easy to understand, and has many interesting uses; some of these may not have occurred to you. This paper illustrates conditional compilation with code samples and demonstrates every conditional compilation construct. It recommends...; Tags: Oracle Corp., PL/SQL, Compilation, Oracle Database 10g Release 2, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; White papers 2005-10-01
Introduction to Oracle: SQL and PL/SQL (exe): Oracle's Introduction to Oracle SQL and PL/SQL (1Z0-001) certification exam a 300 Questions with detailed explanation, Study notes, Articles and How tos. Interactive Exam simulation, for PL/SQL Exam. The program is based on Latest Oracle Exam pattern. It also offers Adaptive and customized testing, Diagnostic test and detailed performance reviews....; Tags: Oracle Corp., uCertify, PL/SQL, SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Software downloads 2005-09-30
Oracle PL/SQL: Managing PL/SQL Code: Writing the code for an application is just one step toward putting that application into production and then maintaining the code base. It is not possible within the scope of this paper to fully address the entire life cycle of application design, development, and deployment. When one compiles PL/SQL programs,...; Tags: Oracle Corp., Code Base, PL/SQL, O'Reilly Media Inc., Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Book chapters 2005-08-12
uCertify O1Z0-147 Oracle9i: Program with PL/SQL (exe): 280 questions with detailed explanation, study notes, articles, and how tos. Intractive Exam simulation, for Oracle9i: Program with PL/SQL Exam. Based on latest Oracle Exam pattern. It also offers adaptive and customized testing, diagnostic test, and detailed performance reviews. The simulation comes with 24/7 online support, free unlimited upgrades for...; Tags: uCertify, PL/SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Software downloads 2005-07-12