To allow an Super User/Admin to log in to my system, I am running (a larger version of) this query: Select *
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?
I have the following CASE in PL/SQL CASE WHEN v_line_item.custom_segment = \'CND1\' THEN v_current_col := v_col_lcy_tps;
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.
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:
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
I have a query Select (SELECT id FROM xyz MWHEREM开发者_高级运维.ID=G.ID AND ROWNUM=1 ) TOTAL_X,
I have the following code SELECT SUM(nvl(book_value, 0)) INTO v_balance FROM account_details WHERE currency = \'UGX\';
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
I am trying to create multiple triggers with only uploading one script into an Oracle DB / APEX workspace, and running it once.
加载中,请稍侯......