Understanding PL/SQL Variable Scope with Examples and Output
Explore the scope of the PL/SQL variable with practical examples. Learn how local and global variables interact and how PL/Scope enhances code analysis.
- You Here!
- Home Author archive for Ahmad Gohar ( Page 5 )
Mastering PL/SQL MERGE Statement: Insert and Update in a Single Operation
Learn how to use the PL/SQL MERGE statement to perform insert and update operations in a single query. Simplify your database operations with this powerful statement.
Quick Guide: Associative Arrays, Nested Tables, and Varrays in PL/SQL
Learn the key differences and usage of PL/SQL collections: associative arrays, nested tables, and varrays. Includes examples for quick reference.
Step-by-Step Guide: Deploying ADF Applications on GlassFish Server
Learn how to deploy Oracle ADF applications on GlassFish Server with this step-by-step guide. Includes setup of ADF Essentials and configuration tips.
Fixing “Access Restriction” Errors for BASE64Encoder in Eclipse
Learn how to resolve the "Access Restriction" error for sun.misc.BASE64Encoder in Eclipse. Step-by-step instructions and alternatives provided.
JPQL Custom Data Retrieval: Mapping Specific Columns to Custom Classes
Learn how to retrieve specific columns using JPQL and map them to a custom class. Reduce memory usage and enhance efficiency with this approach.
JPA @SecondaryTables: Mapping an Entity to Multiple Tables
Learn how to use JPA's @SecondaryTables annotation to map a single entity across multiple tables. Step-by-step examples with JUnit test cases included.
Java Persistence API (JPA) Embeddables: Addressing Shared Object Mappings
Learn how to use JPA Embeddable objects for shared mappings. Implement Address in Customer and Orders using Embeddable classes with examples and test cases.
UML Use Case Diagrams: Purpose, Elements, and Relationships
Learn the purpose, elements, and relationships in UML use case diagrams. Explore their role in requirement analysis and system design with examples.
UML Class Diagram Relationships: Dependency, Aggregation, Composition, and More
Learn about the five key relationships in UML class diagrams: dependency, aggregation, composition, inheritance, and realization. Explore examples in Java for better understanding.
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.