package search_CC
as
type num_arry is table of number
index by binary_integer;
function showCreditCardType (p_number varchar2)
return varchar2;
/*
check if the number string can be check with the LuhnMod10 alogrithmus
1 Sucess - is a Luh10 Number
-1 Invalid
*/
function checkLuhnMod1
-------");
System.out.println("-- Info :: Number of connection requestt, this is the number of times Hibernate asked for a connection");
System.ou... tCount());
System.out.println("-- Info :: Number of flushes done on the session (either by client ... nt());
System.out.println("-- Info :: The number of completed transactions (failed and successful)
=====Besonderheiten bei der Definition des Number Datentypes in Oracle=====
Mit dem Oracle Datentyp Number(p,s) wird ein Festkommazahl definiert, bei der De... Komma angeben.
Eine Integer Zahl kann dann mit Number(p) definiert werden.
<code sql>
column_name NUMBER (precision, scale)
</code>
* precision = Gesammt
REATE TABLE Documents
(
ID NUMBER (30) NOT NULL ,
Filename VARCHAR2 ... cascade constraint
/
create table thesaurus(
id number(11) not null
,name varchar2(255) not null
,descr... onstraint
/
create table thesaurus_phrases(
id number(11) not null
,ths_id number(11) not null
,phrase varchar2(255) not null
)
/
--pk
create unique index id
_pk on vertex(name);
create table edge ( edge_id number, Name_from varchar2(1), Name_to varchar2(1) ,val... ration.
,num_hash_ptns => 16 -- Number of hash partitions used to partition the vertices... ^
| VID | NUMBER |Vertex IT ... |
| T | NUMBER(38) |Property value type see h
en.
Die ora_rowscn gibt die SCN (System Change Number) der Datenbank wieder, an der zum letzten Mal der... ode sql>
select ora_rowscn,DBMS_ROWID.ROWID_BLOCK_NUMBER(rowid),empno from emp order by 2;
ORA_ROWSCN DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID) EMPNO
---------- --------------------... om emp;
select ora_rowscn,DBMS_ROWID.ROWID_BLOCK_NUMBER(rowid),empno from emp order by 2;
ORA_ROWSCN DBM
le_name varchar2(32) -- Table Name
, total_count number(11) -- Total Number of Rows
, column_name varchar2(32) -- Name of the column
, column_count number(11) -- Distinct values with out null
, null_count number(11) -- Values with null
, column_null varchar2
Initialize(sctx IN OUT t_string_agg)
RETURN NUMBER,
MEMBER FUNCTION ODCIAggregateIterate(self I... value IN VARCHAR2 )
RETURN NUMBER,
MEMBER FUNCTION ODCIAggregateTerminate(self ... flags IN NUMBER)
RETURN NUMBER,
MEMBER FUNCTION ODCIAggregateMerge(self IN OUT t_string_agg,
ng_eq (p_wert1 varchar2, p_wert2 varchar2)
return number
is
v_return pls_integer;
begin
if upper(p_wert1)... end;
/
create or replace function num_eq (p_wert1 number, p_wert2 number)
return number
is
v_return pls_integer;
begin
if p_wert1 = p_wert2 then
v_return:=1;
else
v_return:
einer Test Tabelle:
--
create table rawtest (id number, wert long raw);
--
-- 1 Test mit hex Angabe de... create or replace function readRawtoVarchar2(p_id number)
return varchar2
as
v_raw long raw;
v_return va... ( .
<code sql>
-- Test Table
create table t (id number, value long raw);
insert into t values (1,utl_ra... long raw;
v_return varchar2(32000);
v_id number;
begin
loop
fetch p_cursor
into v_id;
T_IMPORT_FILES
(
DDE_SK number(15) NOT NULL
, NAME VARCHAR2... '||'<br/>';
v_filename varchar2(512);
v_id number;
begin
if :P3400_IMPORT_FILE is not null ... t
<code sql>
select apex_item.checkbox2(2,line_number) import -- only if you like to implement a filte... (:P3400_IMPORT_FILE,:P3400_LAST_IMPORTS)
and line_number > 1
</code>
Beispiel für eine reine CSV Datei: