In this module, students will explore single-row functions in Oracle SQL, focusing on character, number, conversion, and null-handling functions, as well as conditional logic and introductory regular ...

A REF CURSOR is a PL/SQL data type that represents a pointer to a server-side result set generated by executing a query. A REF CURSOR type enables input and output streaming of data and is ideal for ...

One of the presentations I enjoyed at Rocky Mountain Oracle Users Group (RMOUG) Training Days 2010 was Stephen Jackson’s presentation “Using SQL to Generate SQL.” I have used some of the techniques he ...

Abstract: Aggregation functions such as COUNT, SUM, AVG, MAX, and MIN are basic tools for summarizing data in SQL. However, their behavior can be affected by several factors such as the occurrence of ...

DATEDIFF is a common function in the SQL Server to find the number of days between two dates. Oracle offers its own solution, although does not have the DATEDIFF function. You have the right to access ...