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 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
-
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 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
-
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
-
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
-
The problem with row-by-row processing in Oracle Database
One reader asks what's wrong with his script, and Oracle expert Karen Morton explains the problem with row-by-row processing. Answer
-
Most valuable skill: DBA, PL/SQL or Oracle Forms
Want to know what skill -- DBA, PL/SQL or Oracle Forms -- is most valued in the IT industry today? Hear from SearchOracle expert Dan Clamage on the topic. Answer
-
Creating lookup tables that support a drop-down menu for categories
Want to create tables to support drop-down menus for categories in PL/SQL? Learn how in this tip from PL/SQL expert Dan Clamage. Answer
-
How to use a hierarchical query to generate ROWNUMs using PL/SQL
Want to generate numbers from SQL? Learn why using a PL/SQL hierarchical query may be a better solution than using a data dictionary view in this tip from PL/SQL expert Dan Clamage. Answer
-
Understanding foreign key column naming conventions
Want to know how to name the foreign key column in your table? This tip from Oracle PL/SQL expert Dan Clamage will help you understand the best way to name a foreign key column. 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
-
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
-
The problem with row-by-row processing in Oracle Database
One reader asks what's wrong with his script, and Oracle expert Karen Morton explains the problem with row-by-row processing. Answer
-
Most valuable skill: DBA, PL/SQL or Oracle Forms
Want to know what skill -- DBA, PL/SQL or Oracle Forms -- is most valued in the IT industry today? Hear from SearchOracle expert Dan Clamage on the topic. Answer
-
Creating lookup tables that support a drop-down menu for categories
Want to create tables to support drop-down menus for categories in PL/SQL? Learn how in this tip from PL/SQL expert Dan Clamage. Answer
-
How to use a hierarchical query to generate ROWNUMs using PL/SQL
Want to generate numbers from SQL? Learn why using a PL/SQL hierarchical query may be a better solution than using a data dictionary view in this tip from PL/SQL expert Dan Clamage. Answer
-
Understanding foreign key column naming conventions
Want to know how to name the foreign key column in your table? This tip from Oracle PL/SQL expert Dan Clamage will help you understand the best way to name a foreign key column. 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.