Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in plsql

How can I create a directory on the file system?

exception in stored procedure

Oracle plsql catching exceptions

oracle-database plsql

Wrong count(*) in pl/sql procedure

oracle-database plsql

Can not return table type from a function PLSQL

Calculating age from birthday with oracle plsql trigger and insert the age in table

How to use a variable from a cursor in the select statement of another cursor in pl/sql

oracle-database plsql

Oracle: DML operation inside a query [duplicate]

oracle procedure giving ORA-00905: missing keyword

PL SQL - Return SQLCODE as OUT parameter is accepted?

Is recompiling Oracle Packages safe

data loss with parallel enabled pipelined function

oracle-database plsql

Oracle PL/SQL Variable in HAVING clause

oracle-database plsql

Formula for Buy 3 get 1 Free

sql math plsql oracle10g

Serializing/marshalling package level user define record types to JSON

APEX: Submit without refreshing the page

I want to optimize a stored procedure that uses IN clause and a regex_str function. I am not sure that how I should optimize it more?

Select directly into hierarchical user type