plsql

相关标签：javascript jquery android 多少钱 iPhone

Difference between two unordered delimited strings in PL/SQL

Is there a simple elegant method to return the difference between two unordered, delimited strings in Oracle using PL/SQL?[详细]

2023-04-03 15:07 分类：问答
Oracle stored procedure cursor always returns zero rows

I have this cursor in a procedure in a package: PROCEDURE CANCEL_INACTIVE(IN_DAYS_OLD NUMBER) IS CURSOR inactive IS[详细]

2023-04-03 08:22 分类：问答
Alter column data type in production database

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.[详细]

2023-04-03 07:08 分类：问答
How to loop in sql?

I dont want to use the \"loop\" related keyword, how can I implement loop with basic sql command in oracle ?[详细]

2023-04-03 07:06 分类：问答
Calculate sum of 2 variables from different cursors - Pl/sql function

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.[详细]

2023-04-03 01:39 分类：问答
Return two lists in PLSQL

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[详细]

2023-04-03 00:10 分类：问答
Bulk collecting with LIMIT clause into nested table in PL/SQL

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[详细]

2023-04-02 19:19 分类：问答
Execute async stored procedure in sql developer

I would like to use Oracle SQL Developer to execute a stored procedure asynchronously a large numb开发者_运维百科er of times.[详细]

2023-04-02 17:09 分类：问答
using long string(over 4000) in oracle query

I know that in sql varchar2 can only be around 4000. I know that in oracle PL varchcar2 can be around 32000.[详细]

2023-04-02 16:53 分类：问答
PL/SQL select into - if data exists

I need to select into a local variable only if there exists data. SELECT column1 INTO local_variable FROM table1 where column2 = <condition>;[详细]

2023-04-02 11:32 分类：问答