Browse topics
Java & Backend
PL/SQL
PL/SQL — articles and guides on Thiyagaraaj.com.
PL/SQLDelete Queries in Oracle / SQL: A Comprehensive GuideDelete queries in Oracle/SQL are essential for removing unwanted data from database tables. In this comprehensive guide, we will delve into the different ways tPL/SQLDifference Between View and Materialised ViewCompare Oracle views and materialized views — how they store data, refresh behavior, performance trade-offs, and when to use each in PL/SQL.PL/SQLExploring PL/SQL Subprograms: Creating and Calling Procedures in OracleLearn PL/SQL subprograms in Oracle — how to create and call procedures, their structure, parameters, and syntax, with practical examples.PL/SQLA Comprehensive Note to Using Oracle SYSDATEIn Oracle, the SYSDATE function plays a crucial role in retrieving the current date and time from the system. This powerful feature enables developers and datab