morten-egan

alter session set nls_date_format='DD-MM-YYYY HH24:MI:SS';
set numwidth 20
set serverout on
set echo on
clear screen

-- Phone numbers
select phone_random.r_phonenumber(r_country => 'AU') from dual;
select phone_random.r_phonenumber(r_country => 'AT') from dual;
begin

morten-egan

alter session set nls_date_format='DD-MM-YYYY HH24:MI:SS';
set numwidth 20
set serverout on
set echo on
clear screen

-- TLD
select web_random.r_tld from dual;
begin
  dbms_output.put_line(

morten-egan

alter session set nls_date_format='DD-MM-YYYY HH24:MI:SS';
set numwidth 20
set serverout on
set echo on
clear screen


-- OS Flavor and paths
select computer_random.r_os_flavor from dual;
select computer_random.r_os_flavor from dual;

morten-egan

alter session set nls_date_format='DD-MM-YYYY HH24:MI:SS';
set numwidth 20
set serverout on
set echo on
clear screen

-- Currency
select finance_random.r_currency from dual;
begin
  dbms_output.put_line(

morten-egan

alter session set nls_date_format='DD-MM-YYYY HH24:MI:SS';
set numwidth 10
set serverout on
set echo on
clear screen

-- random age
select person_random.r_age from dual;
pause;
clear screen;

morten-egan

alter session set nls_date_format='DD-MM-YYYY HH24:MI:SS';
set numwidth 10
set serverout on
set echo on
clear screen
-- CORE RANDOM GENERATORS
-- Produce true or false
begin
  if core_random.r_bool then
    dbms_output.put_line('This is true');

morten-egan

-- RANDOM_NINJA files

@core_random_v.package.sql
@core_random.package.sql
@util_random.package.sql
@text_data_US.package.sql
@text_data.package.sql
@text_random.package.sql
@time_random.package.sql
@names_data.package.sql

morten-egan

create table promise_runs (
  run_finished          date
  , run_result          varchar2(4000)
);

create or replace function p_multiplier(x number)
return number
as
begin
dbms_lock.sleep(4);

morten-egan

[oracle@localhost cli]$ npg install time_ninja t/t
NPG Install

Starting installation of: time_ninja
Session user is: T
Package: time_ninja ready to be installed.
Downloading NPG file.
Unpacking npg zip file.
Validating NPG requirements.
All NPG requirements validated.