Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in plsql

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

Is using "select *" for a cursor in PL/SQL considered bad programming?

Issue with execution of PLSQL block in Shell script

oracle-database shell plsql

When are aliases needed in a multi-table conditional insert?

DBMS_LOB.LoadFromFile Sanity Check

oracle-database plsql blob

how to find empty tables from list of tables in PL/SQL?

Oracle query for default null and on update current_timestamp

Trying to access a select function from Oracle with PHP

Is it possible to create dynamic varchar2 variable?

sql oracle-database plsql

PLSQL decode NVARCHAR2 from BASE64 to UTF-8

utf-8 plsql oracle12c