Oracle and SQL

Email Alerts

Register now to receive 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. 

  • 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. 

  • 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. 

  • 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. 

  • 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. 

  • 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. 

  • 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. 

  • 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. 

  • 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. 

  • 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. 

  • See more Essential Knowledge on Oracle and SQL
  • How to perform Oracle Flashback Transaction Queries

    Read how Oracle Flashback Transaction Query can eliminate the need to use Log Miner to reconstruct database transactions. 

  • How to use Oracle SQL CUBE for cross-tabulation

    Using the SQL CUBE function in Oracle SQL at the right time can cut down on how much querying you'll need to do. 

  • 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... 

  • 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. 

  • 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. 

  • 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... 

  • 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. 

  • 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. 

  • 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. 

  • 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... 

  • See more Tips on Oracle and SQL
  • correlated subquery

    A correlated subquery is a SQL query that depends on values executed by the outer query in order to complete. 

  • autonomous transaction

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

  • 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. 

  • 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. 

  • 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...) 

  • 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. 

  • 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. 

  • 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. 

  • Open Database Connectivity (ODBC)

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

  • The Open Group

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

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.