Skip to content

Oratable

  • Home
    • SQL
    • PL/SQL
    • Data Dictionary
    • Datatypes
    • DBA
    • Exceptions
    • FAQ
    • Keywords
  • About
  • Contact

Performance

Performance tuning concepts and guidelines for the Oracle database.

6 Reasons Why You Should Use PL/SQL Packages

PL/SQL Package Benefits

A package is a database object that groups together logically related procedures/functions, and other constructs such as variables, constants, cursors, PL/SQL types and exceptions.

One may well ask: when it’s possible to write standalone procedures/functions and define related variables within them, why have packages at all?

Read more

Categories FAQ, Performance, PL/SQL Leave a comment
Newer posts
← Previous Page1 Page2

Popular Posts

  • How To Lock A Row In OracleHow to Lock a Row: SELECT FOR UPDATE
  • UTL_HTTP to Call a Web Service from PL/SQLUTL_HTTP to Call a Web Service from PL/SQL
  • UTL_FILE: Simple write to file exampleUTL_FILE: Write To File Example and Debugging Common Errors
  • LISTAGG for Converting Rows to Comma-Separated String in OracleLISTAGG for Converting Rows to Comma-Separated String
  • Oracle Database NameHow to Find Out Your Oracle Database Name

 

  • Analytics
  • Collections
  • Data Dictionary
  • Database Design
  • Datatypes
  • DBA
  • DDL
  • Dependencies
  • Exceptions
  • FAQ
  • Interview
  • Joins
  • JSON
  • Keywords
  • Miscellaneous
  • Object Types
  • ORA Errors
  • Parameters
  • Performance
  • PL/SQL
  • Pseudocolumns
  • Scripts
  • Sequences
  • SQL
  • Subqueries
  • Triggers
  • UTL packages
  • Views
  • XML DB

 

APEX case expression constraints correlated subqueries CTAS distinct dynamic SQL exists hierarchical queries inline views java materialized views multiset null handling Oracle XE popular regex rownum scalar subqueries soft delete with clause XML

Oracle Forums

  • Ask Tom
  • Oracle Forums
  • OraFAQ

Blogroll

  • Alberto Dell'Era
  • Amis Technology Blog
  • Data Warehousing with Oracle
  • JAVA, SQL AND JOOQ.
  • Jonathan Lewis
  • oracle-developer.net
  • SQL Maria
  • Sydney Oracle Lab
  • ThatJeffSmith
  • The Arup Nanda Blog

Recommended Reading

  • Effective Oracle By Design
    Effective Oracle By Design
    by Thomas Kyte
  • Cost Based Oracle Fundamentals
    CBO Fundamentals
    by Jonathan Lewis
About Oratable

Oratable is for learners and practitioners of Oracle, especially developers at a beginner level. You'll find here tips, tricks and tutorials about cool things you can do with the Oracle database.

Popular Posts Which objects depend on this table? 6 Reasons To Use PLSQL Packages
© 2013 - 2026 Oratable. All rights reserved.
Privacy Policy | Contact