Oracle and SQL

Email Alerts

Register now to receive SearchOracle.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

  • Oracle querying for developers

    What pain points do you experience in Oracle querying? Read this excerpt from Michael McLaughlin’s Oracle Database 11g & MySQL 5.6 Developer Handbook to learn the answers to your questions.  Feature

  • 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

  • How to use the Oracle Database SQL Reference Manual

    In this chapter, learn how to use the Oracle Database SQL Reference Manual, a collection of technical information on the SQL statements that work with the Oracle Database.  Chapter Download

  • How to use SQL Developer to run SQL statements

    In this chapter, learn how to use SQL Developer to enter and execute SQL statements and scripts, work with a Snippets window, solve common syntax errors and more.  Chapter Download

  • How to view and edit table column definitions

    In this chapter, learn how to edit and view column names and column definitions for a table, and when to use SQL Developer to do so.  Chapter Download

  • How to work with the Oracle database home page

    In this chapter, learn how to work with an Oracle database, including how to start and stop the Oracle database and use the database homepage, before learning how to use Oracle SQL Developer.  Chapter Download

  • How to use SQL*Plus in Oracle

    In this section, learn how to use SQL*Plus in Oracle, which may be used to run SQL statement and scripts if an Oracle database does not have SQL Developer installed.  Chapter Download

  • See more Essential Knowledge on Oracle and SQL

  • Oracle Database 11g SQL Tuning

    One of the main strengths of SQL is that you don't have to tell the database exactly how to obtain the data requested. You simply run a query specifying the information you want, and the database software figures out the best way to get it. Sometimes...  Tip

  • Inside the Oracle 11g SQL Performance Advisor, part 1

    This preview from the forthcoming book "Oracle 11g New Features" describes the goals of holistic SQL tuning and the steps to perform automated SQL tuning with Oracle 11g's new SQL Performance Advisor feature.  Tip

  • Inside the Oracle 11g SQL Performance Advisor, part 2

    Part 2 of this excerpt from "Oracle 11g New Features" explains how to create a SQL Tuning Set (STS) to be used as input for the SQL Performance Advisor, Oracle 11g's new automatic SQL tuning feature.  Tip

  • SQL analytics: A self-service model

    SQL analytics is one of the best-kept secrets of the Oracle database. It represents the latest advancement in the evolution of delivering powerful analytic capabilities to end users. This article reviews a brief history at attempts to deliver analyt...  Tip

  • Mike Ault's Oracle "good practices": Performance management and tuning

    Mike Ault offers "good practices" for Oracle performance management and tuning, including implementing proactive database monitoring, building in alert mechanisms and more.  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

  • 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

  • SQL puzzles and answers: Finding equal sets

    A SQL puzzle in the December 1993 issue of Database Programming & Design magazine was to use a supplier and parts table to find pairs of suppliers who provide exactly the same parts. This is the same thing as finding two equal sets. How many w...  Tip

  • Accounts unused for X days

    Here's a script that shows accounts and number of days since last use. It assumes session auditing is enabled.  Tip

  • See more Tips on Oracle and SQL

  • autonomous transaction

    In Oracle's database products, an autonomous transaction is an independent transaction that is initiated by another transaction.  Definition

  • dynamic SQL (Dynamic Structured Query Language)

    Dynamic SQL is an enhanced form of Structured Query Language (SQL) that, unlike standard (or static) SQL, facilitates the automatic generation and execution of program statements.  Definition

  • CFML (ColdFusion Markup Language)

    CFML (ColdFusion Markup Language) is a Web page markup language that allows a Web site developer to create pages with variable information (text or graphics) that is filled in dynamically (on the fly) in response to variables such as user input.  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

  • Query by Example (QBE)

    Query by Example (QBE) is a method of query creation that allows the user to search for documents based on an example in the form of a selected text string or in the form of a document name or a list of documents.  Definition

  • Java Database Connectivity (JDBC)

    Java Database Connectivity (JDBC) is an application program interface (API) specification for connecting programs written in Java to the data in popular databases.  Definition

  • foreign key (foreign keyword)

    A foreign key, also called a foreign keyword, in a database table is a key from another table that refers to (or targets) a specific key, usually the primary key , in the table being used.  Definition

  • Open Database Connectivity (ODBC)

    Open Database Connectivity (ODBC) is an open standard application programming interface (API) for accessing a database.  Definition

  • The Open Group

    The Open Group is a software standards organization that is sponsored by a number of major software vendors.  Definition

About Oracle and SQL

Browse hundreds of tips, tutorials and expert responses on SQL (structured query language), the most popular development language for database management systems like Oracle.

Back to top