Top "Plsql" questions

How can I select records ONLY from yesterday?

I've spent hours searching the web for an answer to this question... Here's what I currently have: select * from order_…

sql database oracle plsql

Split function in oracle to comma separated values with automatic sequence

Need Split function which will take two parameters, string to split and delimiter to split the string and return a …

oracle function plsql split delimiter

Is it possible to output a SELECT statement from a PL/SQL block?

How can I get a PL/SQL block to output the results of a SELECT statement the same way as …

sql oracle plsql oracle10g oracle-apex

Sleep function in ORACLE

I need execute an SQL query in ORACLE it takes a certain amount of time. So I wrote this function: …

sql oracle plsql oracle11g

How do I declare and use variables in PL/SQL like I do in T-SQL?

In Sql Server, often times when I'm testing the body of a stored procedure, I copy the body into SSMS, …

sql-server oracle tsql plsql oracle-sqldeveloper

How to declare and display a variable in Oracle

I would like to declare and display a variable in Oracle. In T-SQL I would do something like this DECLARE @…

oracle plsql oracle11g

Different CURRENT_TIMESTAMP and SYSDATE in oracle

After executing this SQL in oracle 10g: SELECT SYSDATE, CURRENT_TIMESTAMP FROM DUAL I receive this strange output: What is …

oracle plsql oracle10g

Truncating a table in a stored procedure

When I run the following in an Oracle shell it works fine truncate table table_name But when I try …

oracle stored-procedures plsql ddl

if (select count(column) from table) > 0 then

I need to check a condition. i.e: if (condition)> 0 then update table else do not update end if …

oracle plsql

How can I use Oracle SQL developer to run stored procedures?

* EDIT6: * This is what ended up working for me (from accepted answer): var ret1 number var tran_cnt number var …

oracle stored-procedures plsql oracle-sqldeveloper sys-refcursor