Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Build a pl/sql Web Service
- This article focuses strictly on PL/SQL database web services. Oracle Database 10g web services, by definition, expose functionality in the database, they allow developer to take advantage of their development investment in PL/SQL and SQL while consuming external web services from within the database. In this article, reader will be...
- Tags: Oracle Corp., Web Service, PL/SQL, Web Services, Programming Languages, Databases, Enterprise Software, Software, Software Development, Software/Web Development, Data Management
- White papers
- Log4plsql: Open-Source Tool for pl/sql Logging
- The implementation of logs is a significant element in development strategy: exhaustive yet concise logs are required to enable code debugging and the tracing of functional events. At the same time, however, in this era of diminishing resources it is necessary to minimize the workload generated by logging. This paper...
- Tags: Open Source, PL/SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- White papers
- Managing Exceptional Behavior, Part 1
- No matter how hard one tries, there will always be one more bug in the application. And the users will always find just the right sequence of keystrokes it takes to make a screen implode. The reality is clear: Either spend the time up front to properly debug and bulletproof...
- Tags: Oracle Corp., PL/SQL, Reality, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- White papers
- Strings Attached
- Many PL/SQL programs manipulate data, often by using SQL to work with that data directly in the database. Yet a person often needs to declare and manage data within PL/SQL programs themselves. This program data might consist of individual values scalars. In many other situations, however, one may deal with...
- Tags: PL/SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- White papers
- Oracle Database 10g: Top Features for DBAs - Part 1: SQL and pl/sql Features
- Transparent Data Encryption and XQuery support are the two major new SQL-related features in Oracle Database 10g Release 2, but the list doesn't end there. The paper presents SQL and PL/SQL features of Oracle Database 10g such as enhanced COMMIT, error-logging clause, WRAP package, conditional compilation, and unlimited DBMS Output.
- Tags: Oracle Corp., PL/SQL, SQL, Oracle Database, Oracle Database 10g, Programming Languages, Databases, Enterprise Software, Software Development, Software/Web Development, Software, Data Management
- White papers
- 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
- Handling HTML multi-selects in pl/sql
- Dealing with HTML multi-selects in Oracle's PL/SQL is a bit trickier than I'd like. Depending on how many items the user picks out of the multi-select, you either get back a simple VARCHAR2 object or a special array object. This means you have to write two separate methods to deal...
- Tags: Method, HTML, PL/SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Rex Baldazo
- Blog posts 2008-01-19
- I can't get a zero-length string in pl/sql
- One of the things I wind up doing a lot in my code is looping thru some data structure -- say an HTML option list or a SQL result set -- and concatenating the results into a single string so that it can be printed to a text file or...
- Tags: Problem, PL/SQL, Comma, String, selectedOptions, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Rex Baldazo
- Blog posts 2008-01-13
- 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
- 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
- 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
- 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
- Microsoft is knocking on your door, Oracle.
- That's an OS issueYou mentioned Linux SQL Server will never be available for.All serious IT application service providers I've worked for are running AIX, Solaris, HP/UX, Tru64 and ... Linux for large scale applications some hundreds of terabytes of data The large scale application OS world is a UNIX world....
- Tags: Databases, Programming languages, Enterprise software, Operating systems, Microsoft SQL Server Transact-SQL, MS-Office, frank.schafer@..., Oracle Corp., PL/SQL, Microsoft SQL Server, Microsoft Corp., server, Linux, SQL
- Discussion threads 2007-10-24
- 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
- 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
- Do comments slow down pl/sql?
- How could anyone think that?You're first thoughts at the very beginning were mine. I am really curious if you asked these people why they would even consider this to be possible, and if so, what reason they gave for it.J.JaOld lore passed downNobody could tell me the origin of this...
- Tags: Programming languages, Databases, Justin James, PL/SQL
- Discussion threads 2007-09-23
- Do comments slow down pl/sql?
- I'm not sure where this started, but at work there's this rumor going around that if you put too many comments in an Oracle PL/SQL package, it impacts performance. That is, the more comments in your code the slower it runs. I could kind of understand if...
- Tags: Method, PL/SQL, Programming Languages, Performance Management, Databases, Software Development, Software/Web Development, Human Resources, Workforce Management, Enterprise Software, Software, Data Management, Rex Baldazo
- Blog posts 2007-09-22
- 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
- pl/sql Standard
- Does anyone has a quality standard for writing PL/SQL Code?asimansari@hotmail.com
- Tags: Programming languages, Databases, asimansari@..., PL/SQL
- Discussion threads 2007-09-13