PL/SQL
PL/SQL — articles and guides on Thiyagaraaj.com.
1
PL/SQL
2Delete Queries in Oracle / SQL: A Comprehensive Guide
Delete queries in Oracle/SQL are essential for removing unwanted data from database tables. In this comprehensive guide, we will delve into the different ways t
PL/SQL
3Difference Between View and Materialised View
Compare Oracle views and materialized views — how they store data, refresh behavior, performance trade-offs, and when to use each in PL/SQL.
PL/SQL
4Exploring PL/SQL Subprograms: Creating and Calling Procedures in Oracle
Learn PL/SQL subprograms in Oracle — how to create and call procedures, their structure, parameters, and syntax, with practical examples.
PL/SQL
A Comprehensive Note to Using Oracle SYSDATE
In 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