Search code examples
Oracle create function fails in "SQLPro for Oracle"...

sqloracle-databasefunctionplsql

Read More
ORDS PL/SQL block is unable to parse the input JSON and merge or delete the records...

sqlplsqloracle-rest-data-services

Read More
ORA-06550:identifier must be declared...

oracle-databasestored-proceduresplsql

Read More
How can you tell if a value is not numeric in Oracle?...

sqloracle-databaseplsqlisnumeric

Read More
Oracle Partition in For Loop Select...

oracle-databasefor-loopplsqldatabase-partitioningexecute-immediate

Read More
How to use Rank Function With Condition in Postgres...

postgresqlplsqlpgadminrankranking-functions

Read More
Reading large data from table & sending output in json...

arraysjsonoracle-databaseplsqlclob

Read More
Opening a cursor from a 2D array in PLsql (Oracle 19g)...

oracle-databaseplsqlsys-refcursor

Read More
ORA-00947 Not enough values while declaring type globally...

oracle-databaseplsqloracle11gora-00947

Read More
Block boundries in oracle pl/sql...

oracle-databaseplsql

Read More
JSON with °(degree) sign / special character is not sent to API as expected...

oracle-databasestored-proceduresplsqlcharacter-encodingspecial-characters

Read More
Using the sample function in a complex query in PLSQL...

oracle-databaseplsql

Read More
Why is not the PL/SQL package state not reset?...

plsqloracle12c

Read More
ORA-29279: SMTP permanent error: 504 The requested authentication mechanism is not supported...

plsqlamazon-rdsamazon-ses

Read More
How I can avoid duplicate records while inserting in Oracle table?...

plsqloracle-apex

Read More
pl/sql - Is there a NVL() for empty rows...

oracle-databaseplsql

Read More
How to select into a variable in PL/SQL when the result might be null?...

selectplsql

Read More
Shapiro-Wilk test...

sqloracle-databaseplsql

Read More
Regular Expression (RegEx) for IPv6 Separate from IPv4...

regexoracle-databasecoldfusionplsqlipv6

Read More
Unable to use FETCH OFFSET syntax with inner CURSOR query in Oracle SQL...

databaseoracle-databaseplsqloracle19cdatabase-cursor

Read More
Improve Performance of Multi Thread Inserts...

sqloracle-databaseplsql

Read More
How to put the select result (column) in an array in PL/SQL...

sqloracle-databaseplsql

Read More
Sum a record with its previous not-null ordered by timestamp...

sqloracle-databaseplsqloracle11g

Read More
ORACLE XMLTABLE don't extraxt the value...

xmlxpathplsqlxmltable

Read More
Best way to check if SYS_REFCURSOR is empty...

sqloracle-databaseplsqlsys-refcursor

Read More
ORA-22285: non-existent directory or file for FILEOPEN operation...

plsqloracle11gxmltype

Read More
Resetting the Last_NUMBER in sequence by looking up a value from a table...

oracle-databaseplsqlsequence

Read More
Oracle Merge Statement Raises "ORA-02012: missing USING keyword" Error...

oracle-databaseplsqlmerge

Read More
How to use Function inside of MERGE USING clause in Oracle?...

sqloracle-databaseplsql

Read More
Return multiple ref cursors in single OUT parameter of stored procedure...

sqloracle-databasestored-proceduresplsqlplsqldeveloper

Read More
BackNext