1 Resources for

pl/sql case

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

Three ways to avoid Case Not Found errors in PL/SQL: Unlike some languages, PL/SQL's CASE statement generates an error if none of the cases are matched. Bob Watkins presents three ways to code around this error. PL/SQL has a rich CASE functionality. The selector CASE statement lets you test the value of an expression (much as the DECODE...; Tags: Oracle Corp., PL/SQL, Databases, Bob Watkins, Programming languages, PL/SQL CASE, CASE statement, clause, Oracle Tips Newsletter, Solution, Statement, Listing B, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Technical articles 2007-05-01

Additional Resources

Learn PL/SQL: Structure and Comments: I'm going to be expanding myentries on learning Oracle to include PL/SQL. I've already written afew entries about basic SQL. Today I start writing about basic PL/SQL.I'm going to keep these entries bite-sized and never more than 2 or 3topics per entry. Today is a discussion of the structure of...; Tags: Programming languages, Databases, PL/SQL; Blog posts 2006-07-12
PL/SQL Performance - Debunking the Myths: This whitepaper is intended for readers who work at the PL/SQL code-face. Oracle Database 10g introduced a brand-new optimizing PL/SQL compiler and a newly tuned PL/SQL execution environment so that PL/SQL programs run dramatically faster. These developments change the way programmers should think about traditional hand optimizations. The paper examines...; Tags: Performance, PL/SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; White papers 2005-04-01
Picking Your Packages: The Oracle PL/SQL language is a joy to use; it is a straightforward and eminently readable programming tool. It is also focused like a laser beam on its particular niche: performing operations against the underlying Oracle database. One of the most important and useful elements of PL/SQL is the package....; Tags: Oracle Corp., PL/SQL, Oracle PL/SQL Language, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; White papers 2005-05-01
What is the difference between Oracle, SQL and PL/SQL?: Recently, Sudhat read my Introductionto Basic SQL and had this to say:The article is very interesting. Too Good!And also please describe what is the difference between SQL and Oracle and PL/SQL.Sudhat, thanks for the comments. Ilove to hear feedback.And your question is a common one so Ithought I would...; Tags: Oracle Corp., PL/SQL, SQL; Blog posts 2006-05-30

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
Learn PL/SQL: Declaring Variables, Named vs Anonymous Blocks: This is part 2 of a series on learning PL/SQL. If you are new to PL/SQL, you should read part 1 first. Also, check out the Article Index. Declaring VariablesWe'vespoken about the declaration section of a PL/SQL block. The declarationsection is the first section of a block....; Tags: Programming languages, Databases, PL/SQL, declaration section; Blog posts 2006-07-30
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
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
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
Learn Oracle: SQL and PL/SQL Datatypes, Strings: There are several types of character data types for your use in SQL and PL/SQL. Unlike the NUMBER data type, there are some differences between SQL and PL/SQL character types.Iwon't cover LOB Large Objects in this article. It could be arguedthat a CLOB is nothing but a large string,...; Tags: CLOB, Oracle Corp., PL/SQL, SQL; Blog posts 2006-07-30
SwisSQL--SQL Server to Oracle Edition (exe): SwisSQL--SQL Server to Oracle Migration tool is an automated migration tool to convert stored procedures implemented in Microsoft SQL Server Transact SQL (T-SQL) into equivalent Oracle PL/SQL code. It automates more than 90% of T-SQL code conversion into PL/SQL. It provides productivity benefits by eliminating error prone manual effort. SwisSQL...; Tags: Microsoft SQL Server Transact-SQL, Oracle Corp., Microsoft SQL Server, Server, Tool, Databases, Enterprise Software, Software, Data Management; Software downloads 2005-03-25
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
Exchange Data Using Arrays in SQL PL: New Capabilities for Exchanging Data Between Applications and Stored Procedures: IBM DB2 9.5 for Linux, UNIX and Windows introduces support for array data types in SQL Procedural Language SQL PL. In addition to being useful as a data structure to develop algorithms, arrays are particularly useful in SQL PL as a vehicle for exchanging collections of data between applications and...; Tags: Array, SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; White papers 2007-10-25
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
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
Translating Procedural Statements Between Oracle and SQL Server: This white paper is intended to give a QUICK but thorough overview of the issues database users may encounter when translating procedural code, such as stored procedures or user-defined functions, between Oracle's PL/SQL and Microsoft SQL Server's Transact-SQL procedural extensions to the ANSI SQL standard. The document should be equally...; Tags: Microsoft SQL Server Transact-SQL, Database Administrator, Oracle Corp., Microsoft SQL Server, PL/SQL, Server, Quest Software Inc., Databases, Programming Languages, Enterprise Software, Software, Data Management, Software Development, Software/Web Development; White papers 2003-02-12
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
Simulate variable arguments in PL/SQL: This week's Oracle newsletter explains how to simulate variable arguments in PL/SQL.Will you use the code in this tip to simulate variable arguments in PL/SQL? What topics would you like us to cover in future editions of this newsletter? If you aren't subscribed to the free Oracle newsletter, click the...; Tags: newsletter, PL/SQL, variable argument, Newsletter Editor, software; Discussion threads 2004-11-23

<< Previous
page 1 of 1
Next >>

Help Desk Trouble Ticket Form: The Help Desk Trouble Ticket is an important document for the technical support professional. This form contains all the essential fields for maintain ...; Buy Now

Microsoft Word Intermediate Skills: Microsoft Word Intermediate Skills is a preformatted presentation that you can use for helping end users better leverage Microsoft Word features. The ...; Buy Now