Email Alerts
-
SELECT statement syntax and examples
In this chapter, learn how to use the SELECT statement with SELECT statement examples, including the basics of the SELECT statement syntax. Chapter Download
-
PL/SQL datatypes in Oracle
Learn about PL/SQL datatypes in Oracle, and learn the definitions of BLOB, CLOB, DATE, VACHAR2 and more in this PL/SQL tutorial for beginners and experts. Learning Guide
-
Stored procedures in PL/SQL
Learn about Oracle PL/SQL stored procedures, such as the stored procedure definition and stored procedure examples in this PL/SQL tutorial for beginners and experts. Learning Guide
-
PL/SQL functions and triggers in Oracle
Learn about using Oracle PL/SQL functions and triggers, such as how to import a trigger and how and when to use a PL/SQL function in this PL/SQL tutorial. Learning Guide
-
SQL guide for Oracle users
Whether you are a newbie or a seasoned expert looking to tweak query performance, this learning guide to the structured query language (SQL) has something for you. These seven chapters can help you figure out how to get the data you need by looking a... Learning Guide
-
Oracle PL/SQL tutorial
This PL/SQL tutorial can help both newbies and veterans become better acquainted with the Oracle development language and hone their developer skills. Learning Guide
-
PL/SQL: What, when, and where
What the Procedural Language/Structured Query Language (PL/SQL) really is, what it is good for, and how it fits into the world. Book Chapter
-
Oracle's free SQL Developer adds database migration tool
Oracle SQL Developer is offering a new tool that lets users migrate data from Microsoft and MySQL databases to Oracle. Article | 21 Sep 2007
-
Oracle updates Microsoft developer tools
Oracle is offering free tools for Microsoft .NET and ASP.NET applications developers running the Oracle Database 10g. Article | 14 Jun 2007
-
Oracle updates free Web development tool
Oracle Application Express now offers Microsoft Access migration and .pdf printing support. Article | 26 Mar 2007
-
Oracle SQL Developer vs. Toad: Users speak out, part two
Oracle developers are still talking about their favorite PL/SQL editing and debugging tools, and their opinions aren't confined to just Toad and SQL Develper. Article | 31 Jan 2007
-
Oracle SQL Developer gets an update
Oracle says its newly updated SQL Developer tool includes enhancements that make it easier to create and debug SQL and PL/SQL code. Article | 08 Jan 2007
-
Oracle Database 11g to feature XML enhancements
The latest version of Oracle's flagship DBMS offers a host of XML-related upgrades. Article | 12 Dec 2006
-
Oracle tutorial library: SearchOracle.com's learning guides
One of the best resources SearchOracle.com offers is our collection of learning guides. They're a perfect education tool for the beginner who's just getting started with Oracle or the seasoned professional looking to attain expert status. We've gathe... Article | 29 Nov 2006
-
Podcast: Expert says PL/SQL change needed in Oracle 11g
SearchOracle.com chats with one of the world's leading PL/SQL gurus, Steve Feuerstein, about the PL/SQL changes he'd like to see when Oracle debuts Database 11g. Article | 09 Nov 2006
-
Spotlight on Oracle performance tuning
Performance tuning -- keeping your database and SQL queries running quickly and smoothly -- is one of the most important and demanding tasks for an Oracle DBA. This special report compiles analysis, tips and expert advice to help you meet your tuning... Article | 31 Aug 2006
-
Oracle expert warns of weakness in PL/SQL
A well-known Oracle bug hunter says the wrapping mechanism used for PL/SQL -- the flagship language used in Oracle databases -- can be unraveled, exposing sensitive data. Article | 18 Aug 2006
- See more News on Using Oracle PL-SQL
-
PL/SQL do's and don't's: Five questions with Steven Feuerstein
Oracle PL/SQL expert Steven Feuerstein advises on what you should never do in PL/SQL -- and what you should always do. Tip
-
Mike Ault's Oracle "good practices": Oracle coding
Mike Ault offers "good practices" for Oracle coding, including using array processing, placing code within stored procedures and using proper variable types for variable declaration. Tip
-
Mike Ault's Oracle "good practices"
In this six-part tip, Mike Ault offers Oracle "good practices" in categories including the Oracle environment; backup, failover and disaster recovery; system security; design; coding; and performance management and tuning. Tip
-
Easy Oracle PL/SQL programming: Assignments, initializations and NULLs
This excerpt from "Easy Oracle PL/SQL Programming: Get Started Fast with Working PL/SQL Code Examples" covers how to work with assignments, initializations and NULLs. Tip
-
Oracle 10g expert SQL tuning techniques
This book excerpt focuses on real-world techniques for improving the speed of SQL queries with a focus on new Oracle 10g features. The topics include the new Oracle parameters that affect SQL performance, the use of hints to change SQL execution plan... Tip
-
Fax documents from database
This tip offers several options for sending a fax from an Oracle database. Tip
-
Replication using LogMiner
This tip describes how to leverage Oracle LogMiner as a data replication utility. Tip
-
SQL*Plus does not support command history on Linux
This tip demonstrates how to change SQL*Plus so that it supports command history on Linux. Tip
-
SQL generation vs. Oracle stored procedures
An ITKnowledge Exchange member had a question about which option to choose: SQL generation or stored procedures. Fellow Oracle techies helped Steve. Tip
-
Guide to Oracle freeware and shareware
This list of free and low-cost tools and utilities will help Oracle DBAs and developers do your job better. Tip
- See more Tips on Using Oracle PL-SQL
-
Using SQL SELECT and SQL UNION ALL statements to sort numbers
Expert Dan Clamage explains how to use SQL SELECT and SQL UNION ALL statements to sort and visualize a set of sales figures. Answer
-
Confusion around PL/SQL to_date and to_char functions
One reader asks expert Daniel Clamage about the PL/SQL to_date and to_char functions and how to properly convert date and string values. Answer
-
Calling stored procedures inside user-defined functions in Oracle Database
In this expert answer, Brian Peasland explains how to call a stored procedure inside user-defined functions in Oracle Database. Answer
-
Solve a PL-SQL error that creates dynamic tables
Oracle PL-SQL expert Daniel Clamage answers a question about a problem with doing an “insert” in PL-SQL to create a table dynamically. Answer
-
Inconsistent data type error in Oracle Database 9i
A reader asks SQL expert Daniel Clamage about an inconsistent data type error he's getting on a query running in Oracle Database 9i. Answer
-
Making Monday the start of the week in Oracle SQL
One reader asks how to set up a report in Oracle SQL so that Monday is the first day of the week. Answer
-
Using inline view to better query joined tables
One reader asks how to best query data from two joined Oracle tables. Answer
-
SQL query for sorting through ID columns
A reader asks Oracle expert Karen Morton how to query a group of rows based on their text columns. Answer
-
Replacing text strings in an employee name column
One reader asks how he can change occurrences of "LL" to "LX" in an employee name column. Answer
-
Avoiding and fixing mutating table errors
PL/SQL expert Daniel Clamage tells one reader why her merge statement is creating a mutating table error. Answer
- See more Expert Advice on Using Oracle PL-SQL
-
PL/SQL (procedural language extension to Structured Query Language)
In Oracle database management, PL/SQL is a procedural language extension to structured query language (SQL). Definition
-
stored procedure
In a database management system (DBMS), a stored procedure is a precompiled set of Structured Query Language (SQL) statements that can be shared by a number of programs. (Continued...) Definition
-
Using SQL SELECT and SQL UNION ALL statements to sort numbers
Expert Dan Clamage explains how to use SQL SELECT and SQL UNION ALL statements to sort and visualize a set of sales figures. Answer
-
Confusion around PL/SQL to_date and to_char functions
One reader asks expert Daniel Clamage about the PL/SQL to_date and to_char functions and how to properly convert date and string values. Answer
-
Calling stored procedures inside user-defined functions in Oracle Database
In this expert answer, Brian Peasland explains how to call a stored procedure inside user-defined functions in Oracle Database. Answer
-
Solve a PL-SQL error that creates dynamic tables
Oracle PL-SQL expert Daniel Clamage answers a question about a problem with doing an “insert” in PL-SQL to create a table dynamically. Answer
-
Inconsistent data type error in Oracle Database 9i
A reader asks SQL expert Daniel Clamage about an inconsistent data type error he's getting on a query running in Oracle Database 9i. Answer
-
Making Monday the start of the week in Oracle SQL
One reader asks how to set up a report in Oracle SQL so that Monday is the first day of the week. Answer
-
Using inline view to better query joined tables
One reader asks how to best query data from two joined Oracle tables. Answer
-
SQL query for sorting through ID columns
A reader asks Oracle expert Karen Morton how to query a group of rows based on their text columns. Answer
-
Replacing text strings in an employee name column
One reader asks how he can change occurrences of "LL" to "LX" in an employee name column. Answer
-
Avoiding and fixing mutating table errors
PL/SQL expert Daniel Clamage tells one reader why her merge statement is creating a mutating table error. Answer
- See more All on Using Oracle PL-SQL
About Using Oracle PL-SQL
Browse our compendium of tips, expert advice and analysis on PL/SQL, Oracle's proprietary procedural extension of the structured query language (SQL) for Database 7, 8i, 9i, 10g and 11g.