Search code examples
Convert comma separated string to array in PL/SQL...

oracle-databaseplsqltokenize

Read More
Oracle Procedure gets ORA-00054: resource busy and acquire with NOWAIT...

oracle-databaseplsqloracle19c

Read More
How to Select a Variable As Query Result in Oracle PLSQL...

oracle-databaseplsql

Read More
SQL - how to count unique combination of columns...

oracle-databaseplsql

Read More
How to find number of Sundays in a given year (ex: input_year = 1996) and also the dates of those Su...

sqloracle-databaseplsqloracle11g

Read More
Declare record type from object or table type...

plsqlrecordoracle19c

Read More
Oracle PL SQL: using labels to get out of for loops...

sqloracle-databasefor-loopplsqllabel

Read More
Oracle procedure error: Expected UDT got CHAR...

oracle-databaseplsqloracle19c

Read More
How to return columns from dynamic SQL in Python console...

pythonoracle-databaseplsqldynamic-sqlcx-oracle

Read More
How to raise Oracle PL/SQL exceptions from Python...

pythonoracle-databaseplsqlcx-oracle

Read More
Oracle Database: Find Missing Indexes for Performance tuning...

sqloracle-databaseindexingplsqloracle11g

Read More
ORA-00001: uniqueness constraint violated...

oracle-databaseplsqlsql-insertdbeaverora-00001

Read More
How to Split a String by Delimiters and Handle Empty Values as NULL in Oracle PL/SQL?...

sqloracle-databaseplsql

Read More
What's the best way to get grouped data from a table into a JSON object as tree structure...

sqloracle-databaseplsqloracle19c

Read More
unbale to get the data from ORDS plsql block if input is an json array of objects...

sqljsonoracle-databaseplsqloracle-rest-data-services

Read More
SQL pull data for the past two years...

sqlplsql

Read More
Can't Read Files using External Tables or Write Files using UTL_FILE using PL/SQL...

linuxdatabaseoracle-databaseunixplsql

Read More
How to call an external API in Oracle Apex?...

javascriptoracle-databaseplsqloracle-apex

Read More
How I can verify my PL/SQL syntax...

plsql

Read More
Oracle PL SQL Insert Statement - ORA-01007: variable not in select list...

oracle-databaseplsql

Read More
plsql procedure to save html in table...

oracle-databaseplsqlprocedure

Read More
How to process tabular data from Oracle PL/SQL function in JAVA?...

javaoracle-databasefunctionplsql

Read More
SQL query inside PL/SQL Block is not working properly, Fetches all Data and ignoring WHERE clause...

plsqloracle10goracle-apex

Read More
How do you execute SQL from within a bash script?...

sqloracle-databasebashplsqlsqlplus

Read More
Convert JSON to table when all JSON field keys are unknown/arbitrary/random...

sqloracle-databaseplsql

Read More
Within PL/SQL script create table based on Oracle Edition...

oracle-databaseplsqlpartitioning

Read More
plsql script is raising 'ERROR at line 1 DECLARE', I don't see the reason...

oracle-databaseplsqlsqlplus

Read More
Performance tuning of Update statement in ORACLE...

sqloracle-databaseplsql

Read More
Search All Fields In All Tables For A Specific Value (Oracle)...

sqloracle-databasesearchplsqldatabase-table

Read More
Returning clause in json_table or skip error on error?...

oracle-databaseplsqlclobjson-table

Read More
BackNext