plsql

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

No short-circuit OR with an Oracle function?

To allow an Super User/Admin to log in to my system, I am running (a larger version of) this query: Select *[详细]

2023-04-01 03:36 分类：问答
Get the name of the calling procedure or function in Oracle PL/SQL

Does anyone know whether it\'s possible for a PL/SQL procedure (an error-logging one in this case) to get the name of the function/procedure which called it?[详细]

2023-04-01 03:12 分类：问答
Why am I getting ORA-06592: CASE not found while executing CASE statement in PL/SQL?

I have the following CASE in PL/SQL CASE WHEN v_line_item.custom_segment = \'CND1\' THEN v_current_col := v_col_lcy_tps;[详细]

2023-03-31 22:58 分类：问答
Pass varargs from Java code to SQL or PL/SQL

I need to bind at maximum 8 variables. Each one of them could be null. Is there any recommended way to achieve this? I know that开发者_如何转开发 I could simply check for null, but this seems tedious.[详细]

2023-03-31 20:58 分类：问答
PL/SQL: how to loop through sql extract() results

This is an arbitrary example. It is a real problem, but I can\'t share real code. I have an xml string that does not have standardized node names. example:[详细]

2023-03-31 16:14 分类：问答
Check a record IS NOT NULL in plsql

I have a function which would return a record with type my_table%ROWTYPE, and in t开发者_运维知识库he caller, I could check if the returned record is null, but PL/SQL complains the if-statement that[详细]

2023-03-31 14:53 分类：问答
ORDER BY in GROUP BY clause

I have a query Select (SELECT id FROM xyz MWHEREM开发者_高级运维.ID=G.ID AND ROWNUM=1 ) TOTAL_X,[详细]

2023-03-31 13:43 分类：问答
Suppress ORA-01403: no data found excpetion

I have the following code SELECT SUM(nvl(book_value, 0)) INTO v_balance FROM account_details WHERE currency = \'UGX\';[详细]

2023-03-31 12:00 分类：问答
PL/SQL data type support for size greater than NVarchar2

PL/SQL has data type NVARCHAR2(size) where the size is 32767 bytes; equivalent to 4095 records. Now, what data type should i give as an alternative to NVARCHAR2 that could s开发者_如何学JAVAupport mo[详细]

2023-03-31 11:04 分类：问答
Is there a way to create multiple triggers in one script?

I am trying to create multiple triggers with only uploading one script into an Oracle DB / APEX workspace, and running it once.[详细]

2023-03-31 07:44 分类：问答