Open links in new tab
  1. Github
    https://github.com › blackdogcode › OraclePLSQL › blob › master › PL-SQL-Cheatsheet.pdf

    OraclePLSQL/PL-SQL-Cheatsheet.pdf at master

    What's new in PL/SQL?
    Regular expressions are available in PL/SQL in the form of three new functions (REGEXP_INSTR, REGEXP_REPLACE, and REGEXP_SUBSTR) and the REGEXP_LIKE operator for comparisons . Collections, improved to include such things as collection comparison for equality and support for set operations on nested tables.
    en.wikibooks.org
    PLSQL Cheat Sheet by juliosueiras - Cheatography

    1 IN An IN parameter lets you pass a value to the subprogram. It is a read-only parameter. Inside the subprogram, an IN parameter acts like a constant. It cannot b…

    Cheatography.com
    PL/SQL Cheatsheet | Cheat Sheets Hero

    A concise reference for PL/SQL, covering syntax, data types, control structures, and common operations for Oracle database programming.

    https://cheatsheetshero.com/user/all/361-pl-sql-cheatsheet
    Oracle Database/SQL Cheatsheet - Wikibooks

    This "cheat sheet" covers most of the basic functionality that an Oracle DBA needs to run basic queries and perform basic tasks. It also contains information that a PL/SQ…

    https://en.wikibooks.org/wiki/Oracle_Database/SQL_Cheatsheet
    Oracle PL/SQL Cheat Sheet - PeopleSoft Tutorial
    PeopleSoft Tutorial
  1. 12

    PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. Here are some essential commands and concepts to get you started.

    Blocks

    A PL/SQL block consists of three sections: Declaration, Execution, and Exception handling.

    SET SERVEROUTPUT ON;
    DECLARE
    v_number NUMBER := 5;
    BEGIN
    DBMS_OUTPUT.PUT_LINE('Value: ' || v_number);
    EXCEPTION
    WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE('An error occurred.');
    END;
    Copied!

    Variables

    Variables in PL/SQL can be declared in the declaration section of a block.

    DECLARE
    v_number NUMBER := 10;
    v_name VARCHAR2(20) := 'John';
    BEGIN
    DBMS_OUTPUT.PUT_LINE('Name: ' || v_name || ', Number: ' || v_number);
    END;
    Copied!

    Loops

    PL/SQL supports various types of loops including simple loops, while loops, and for loops.

    Simple Loop

    DECLARE
    v_counter NUMBER := 0;
    BEGIN
    LOOP
    v_counter := v_counter + 1;
    EXIT WHEN v_counter = 5;
    DBMS_OUTPUT.PUT_LINE('Counter: ' || v_counter);
    END LOOP;
    END;
    Copied!

    While Loop

    Feedback
  2. jre-training.com
    https://www.jre-training.com › PLSQL › Materials › sql...
    [PDF]

    Cheat Sheets - jre-training.com

    INNER JOIN: show all matching records in both tables. LEFT JOIN: show all records from left table, and any matching records from right table. RIGHT JOIN: show all records from right table, …

  3. Cheatography.com
    https://cheatography.com › juliosueiras › cheat-sheets › plsql › pdf
    [PDF]

    PLSQL Cheat Sheet by juliosueiras - Cheatography

    1 IN An IN parameter lets you pass a value to the subprogram. It is a read-only parameter. Inside the subprogram, an IN parameter acts like a constant. It cannot be assigned a value. You. …

  4. cheatsheetshero.com
    https://cheatsheetshero.com › user › all

    PL/SQL Cheatsheet | Cheat Sheets Hero

    Mar 3, 2025 · A concise reference for PL/SQL, covering syntax, data types, control structures, and common operations for Oracle database programming.

  5. wikibooks.org
    https://en.wikibooks.org › wiki › Oracle_Database › SQL_Cheatsheet

    Oracle Database/SQL Cheatsheet - Wikibooks

    • INDEXES
      An index is a method that retrieves records with greater efficiency. An index creates an entry for each value that appears in the indexed columns. By default, Oracle creates B-treeindexes.
    See more on en.wikibooks.org
  6. PeopleSoft Tutorial
    https://peoplesofttutorial.com › oracle-plsql-cheat...

    Oracle PL/SQL Cheat Sheet - PeopleSoft Tutorial

    Download a PDF file with PL/SQL syntax, functions, operators, and examples. Learn PL/SQL from a recommended book and a cheat sheet collection.

  7. People also ask
    Feedback
  8. peferso.github.io
    https://peferso.github.io › cheat-sheets › plsql

    PLSQL queries cheatsheet | cheat-sheets

    Several cheat-sheets of different topics in .md format. Checkout the Github pages version.

  9. Docsity
    https://www.docsity.com › en › oracle-pl-sql-quick...

    Oracle PL SQL Quick Reference Sheet | Cheat Sheet …

    Download Cheat Sheet - Oracle PL SQL Quick Reference Sheet | Felician University | SQL cheat sheet covering around 50 terms and commands

  10. Scribd
    https://www.scribd.com › document › PLSQL-CheatSheet

    PLSQL CheatSheet | PDF - Scribd

    The document provides a cheat sheet for PL/SQL control statements, including conditional statements (IF, CASE), iterative statements (LOOP, WHILE, FOR), and sequential statements …

  11. cheatsheetshero.com
    https://cheatsheetshero.com › user › all
    [PDF]

    PL/SQL Cheatsheet

    PL/SQL Cheatsheet A concise reference for PL/SQL, covering syntax, data types, control structures, and common operations for Oracle database programming.