Select into a variable with case statement in a for loop...

Case expression based on for loop...

Conditional statement for insert, update or delete...

Case expression based on the time...

Display a string of text for the 1st Jan 2008-2018...

Using a CASE expression...

SQL Error [900] [42000]: ORA-00900: invalid SQL statement...

Calculate customized ASCII values without using Loop/Cursor...

Use result from case expression in another case expression...

SQL trigger to show salary change...

How can I generate JSON content in Oracle for a CLOB that is > 32k (e.g., 60,000 characters)?...

PL/SQL UTL_HTTP request returns "ORA-01031: insufficient privileges" on OCI AutonomousDB...

Minus vs Except Difference in ORACLE/SQL Server...

DBMS_OUTPUT.PUT_LINE not printing...

create a collection with 2 columns and insert all the rows at once PL/SQL...

find between places...

FETCH INTO doesn't raise an exception if the set is empty, does it?...

Call to an overloaded procedure inside another procedure in an Oracle/PLSQL package...

oracle ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind...

Render page item which has HTML in Oracle Apex...

OracleDataAdapter.Fill throws "SQL command not properly ended"...

New oracle apex plugin firing on page load/initialization...

How to SELECT inside a DECLARE block?...

How to get a list with description of all dba packages...

How to return rows from a declare/begin/end block in Oracle?...

How to remove leading zeroes from day and month values in Oracle, when parsing to string using to_ch...

Where to define nested procedures in case when I need - variables + cursors + nested procedures?...

Execute Immediate on DDL Statements...

Is it possible to extract ddl of a package without package body...

Oracle ORA-02089 with Java...