Search code examples
Missing expression in Oracle Function...

oracle-databaseplsql

Read More
PL/SQL to Superset/Trino - convert hexadecimal funcion...

sqlplsqlprestoapache-supersettrino

Read More
Looping through PL/SQL collection using oracledb npm library...

node.jsoracle-databaseplsqlnode-oracledb

Read More
How to create XML from a string with list of values...

sqloracle-databaseplsql

Read More
CSV Generation from PLSQL Procedure...

oracle-databasecsvplsql

Read More
PLS-00103: Encountered the symbol "EXCEPTION" error while checking for a value in the bind...

oracle-databaseplsqlora-06550

Read More
compare if the cursor value exists in another cursor - oracle plsql...

plsql

Read More
execution fails but I could not understand why...

oracle-databaseplsql

Read More
Why does Oracle think that a strong reference cursor is not correctly declared?...

oracle-databaseplsql

Read More
how to save a query result in a temporary table within a procedure...

oracle-databasestored-proceduresplsql

Read More
What does it mean `SELECT 1 FROM table`?...

mysqlsqlplsql

Read More
Refactoring a slow plsql cursor with a WITH update statement...

oracle-databaseplsqlwith-statement

Read More
Sleep function in ORACLE...

sqloracle-databaseplsqloracle11g

Read More
What is wrong with this PL/SQL? Bind Variable * is NOT DECLARED...

oracle-databasevariablesplsql

Read More
Oracle Apex Submit and Open modal in the same time...

oracle-databaseplsqloracle-apex

Read More
Trying to execute a simple stored procedure - Help! Can't find an answer that works here...

sqloracle-databasestored-proceduresplsqlexecute

Read More
How to remove error code and print only message | PLSQL...

plsqloracle-apex

Read More
Generate Nested JSON oracle19c using JSON functions...

sqloracle-databaseplsqloracle12coracle19c

Read More
How to define elements and attributes for XML created by apex_data_export...

oracle-databaseplsqloracle-apex

Read More
I can't use IN clause in a package with variables...

sqloracle-databaseplsqlplsql-package

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

stored-proceduresplsqloracle11g

Read More
How to get the comma seperated value of a column to display as next values in oracle apex grid...

plsqloracle11goracle-apexplsqldeveloperplsql-package

Read More
Prevent Oracle Dbms_XmlDom from escaping attributes...

xmloracle-databaseplsql

Read More
I have to write SQL query to iterate the dates to until date becomes greater than sysdate...

sqldateselectplsqldateadd

Read More
Creating tags (or nodes) with a Namespace PL/SQL...

xmloracle-databaseplsql

Read More
Oracle query plan efficiency problem...

sqloracle-databaseplsql

Read More
Refactoring the query...

sqloracle-databaseplsql

Read More
ORA-12838 How to pre-test a query before a delete and insert?...

oracle-databaseplsqlrollback

Read More
Based on a min and max id obtained from a table, how to calculate how many groups of records I can d...

oracle-databasestored-proceduresplsql

Read More
compare comma seperated strings if there is the same number in them...

sqloracle-databaseplsqloracle11g

Read More
BackNext