Oracle PL/SQL Data Structures: Key Features and Differences
Explore Oracle PL/SQL data structures including Varrays, Nested Tables, and Associative Arrays. Learn their key features, differences, and use cases.
- You Here!
- Home Author archive for Ahmad Gohar ( Page 4 )
SQL Query Results Cache: Usage, Restrictions, and Best Practices
Learn how to use SQL Query Result Cache effectively, including valid use cases, limitations, and caching rules for PL/SQL functions.
Preventing SQL Injection with DBMS_ASSERT in Oracle
Learn how to prevent SQL injection in Oracle using the DBMS_ASSERT package. Explore best practices like escaping literals, verifying schema names, and raising exceptions.
12 Strategies to Prevent SQL Injection in PL/SQL APIs
Learn how to prevent SQL injection in PL/SQL APIs with strategies like parameterized queries, input validation, static SQL, and secure error handling.
Two Efficient Queries to Get Row Counts for All Oracle Tables
Learn how to get row counts for all tables in Oracle using SQL queries. These approaches handle both user and all accessible tables efficiently.
Mastering Dynamic SQL in PL/SQL: Native Dynamic SQL & DBMS_SQL Explained
Learn how to use Dynamic SQL in PL/SQL with Native Dynamic SQL and the DBMS_SQL package. Detailed examples for executing SQL statements dynamically.
Oracle Package: Comprehensive Example with Code
Explore a complete Oracle PL/SQL package example with public variables, procedures, functions, and initialization. Understand package structure and functionality with code.
Understanding Forward Declarations in Oracle PL/SQL Packages
Learn about forward declarations in Oracle PL/SQL, their importance in package bodies, and when to use them for logical subprogram organization.
Overloading Subprograms in PL/SQL: Benefits and Limitations
Learn about subprogram overloading in Oracle PL/SQL, when to use it, and its limitations. Explore how to create overloaded procedures and avoid errors.
Mastering PL/SQL %ROWTYPE: Examples for Insert, Update, and Bulk Operations
Learn how to use the %ROWTYPE attribute in PL/SQL for managing database rows. Explore examples for insert, bulk insert, and update operations.
With over 18 years of experience in software architecture, Java technologies, and leadership, I specialize in crafting scalable, future-proof solutions for global organizations. Whether it’s transforming legacy systems, building cutting-edge cloud-native applications, or mentoring teams to excel, I’m committed to delivering value-driven results.