cruepprich

Quick & Dirty: Populate number array from string.

March 13, 2018June 20, 2018 cruepprich 3 Comments

Here is a quick way to convert a list of colon separated numbers into a number array:

declare 
  l_list_of_numbers varchar2(32767) := '1:2:3'; 
  l_string_array apex_application_global.vc_arr2; 
  l_number_array apex_application_global.n_arr; 
begin 
  l_string_array := apex_util.string_to_table(l_list_of_numbers); 
  select * bulk collect 
  into   l_number_array 
  from   table(l_string_array); 
   
  for idx in 1..l_number_array.count 
  loop 
    dbms_output.put_line(l_number_array(idx)); 
  end loop; 
end;

declare

l_list_of_numbers varchar2(32767) := '1:2:3';

l_string_array apex_application_global.vc_arr2;

l_number_array apex_application_global.n_arr;

begin

l_string_array := apex_util.string_to_table(l_list_of_numbers);

select * bulk collect

into l_number_array

from table(l_string_array);

for idx in 1..l_number_array.count

loop

dbms_output.put_line(l_number_array(idx));

end loop;

end;

Oracle Developement

Downloading Oracle Files With the Command Line

March 8, 2018July 5, 2018 cruepprich 0 Comments

Here is a quick trick that allows you to download files from OTN through the command line. In order to

Oracle Developement

12 Things Developers Will Love in 12.2

March 7, 2018 cruepprich 0 Comments

This is a reblog from Chris Saxon: https://blogs.oracle.com/sql/12-things-developers-will-love-about-oracle-database-12c-release-2

Oracle Developement

Getting started with Liquibase

February 27, 2018June 20, 2018 cruepprich 0 Comments

Liquibase is a source code control management tool for database schemas. It basically consists of a command line tool that

Oracle Developement

Reset Password By Values in 12c

January 9, 2018 cruepprich 0 Comments

In prior Oracle version you used to be able to hack a users password by using the identified by values

Oracle Developement

Getting to Grips with the APEX Interactive Grid API

December 12, 2017 cruepprich 0 Comments

Matt Mulvaney has an excellent post regading the APEX interactive grid: http://www.explorer.uk.com/getting-grips-apex-interactive-grid-api/

Oracle Developement

Identity Columns and Data Pump

November 7, 2017 cruepprich 0 Comments

via Identity Columns and Data Pump

Oracle Developement

ORDS REST Modules with PL/SQL

October 25, 2017 cruepprich 0 Comments

Here is one of the best references I’ve found for creating ORDS REST services with PL/SQL. https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-create-basic-rest-web-services-using-plsql#create-post-web-services There are examples

Oracle Developement