inieren:
<code plsql>
TYPE myPlsqltab is TABLE OF varchar2(2000) index by binary_integer;
</code>
Variable ... auch mal zu klein sein kann, alternativ dann auf varchar2 setzen:
Beispiel um einen Lookup bei einem ETL J... ookup_tab is table of emp_lookup.id%type INDEX BY varchar2(16);
v_emp_lookuptab t_emp_lookup_tab;
cu... finieren:
<code plsql>
TYPE varchar_t is TABLE OF varchar2(2000);
</code>
Vergleich Nested Tables Collecti
nteger;
function showCreditCardType (p_number varchar2)
return varchar2;
/*
check if the number string can be check with the LuhnMod10 alogrithmus
... ditcards
*/
function analyseCCText (p_text varchar2)
return varchar2;
end;
/
</code>
Body:
<code sql search_CC.pkb>
create or replace package body sear
har zur Verfügung einen Long Value direkt in char/varchar2 in SQL zu konvertieren.
Im [[ http://docs.oracle... in PL/SQL zwei Funktionen zur Verfügung, CAST_TO_VARCHAR2 und CAST_TO_RAW.
==== Einfachste Version einer ... vertieren
--
create or replace function readRawtoVarchar2(p_id number)
return varchar2
as
v_raw long raw;
v_return varchar2(32000);
begin
select wert into v_raw
.
ACL:
<code sql>
DECLARE
v_apex_server VARCHAR2(256):= '10.10.10.180';
BEGIN
DBMS_NET... ob;
v_blob blob;
v_rest_url VARCHAR2(2000);
v_server_url VARCHAR2(300):='http://10.10.10.180/jasperserver/';
-- use this to get resource infos for this report
v_resoure_path VARCHAR2(300):='rest_v2/resources/';
-- get the report
esult table
create table TAB_COL_COUNT
( schema varchar2(32) -- Schema Name of the table
, table_name varchar2(32) -- Table Name
, total_count number(11) -- Total Number of Rows
, column_name varchar2(32) -- Name of the column
, column_count numbe... t number(11) -- Values with null
, column_null varchar2(1) -- If all is null set to Y for anlayse
);
</
sql>
create or replace function customerId
return varchar2
SQL_MACRO(SCALAR)
as
begin
return 42;
end cust... ATED BY DEFAULT ON NULL AS IDENTITY
, institut varchar2(4)
, kundennummerInstitut number(8)
, ZentralInstitut varchar2(4)
, ZentraleKundennummer number(9)
, Kundenname varchar2(256)
, Eigenschaften varchar2(4000)
)
;
insert i
NARY_INTEGER;
-- not working
v_list varchar2(255):=replace('0100:26941:0:0',':',',');
-- working
-- v_list varchar2(255):=replace('a:b:c:d',':',',');
BEGIN
dbms_... ===============
type splitResultTab IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
-- ==========... ==========
function splitString( p_string varchar2
, p_seperator varchar2)