Is there a simple elegant method to return the difference between two unordered, delimited strings in Oracle using PL/SQL?
I have this cursor in a procedure in a package: PROCEDURE CANCEL_INACTIVE(IN_DAYS_OLD NUMBER) IS CURSOR inactive IS
I\'m looking for the best way to change a data type of a column in a populated table. Oracle only allows changing of data type in colums with null values.
I dont want to use the \"loop\" related keyword, how can I implement loop with basic sql command in oracle ?
I am relatively new to pl/sql and coding in general and appreciate your help. Have 2 tables as follows. Writing a function to calculate the sum(amt1)+ sum(amt2) for a date range.
I am trying to return a list of 3 VARRAYS/COLLECTIONS to my application. I am having trouble though, think I am either implementing the solution incorrectly
As the title says, how to bulk collect into a nested table with LIMIT clause? In the following examples, cur_data is a nested table which gets overwritten on the subsequent BULK COLLECT. I have seen E
I would like to use Oracle SQL Developer to execute a stored procedure asynchronously a large numb开发者_运维百科er of times.
I know that in sql varchar2 can only be around 4000. I know that in oracle PL varchcar2 can be around 32000.
I need to select into a local variable only if there exists data. SELECT column1 INTO local_variable FROM table1 where column2 = <condition>;
加载中,请稍侯......