-----------------
CREATE TABLE Documents
(
ID NUMBER (30) NOT NULL ,
Filen... AULT 'N'
) ;
CREATE UNIQUE INDEX IDX_Documents_ID_PK ON Documents ( ID ASC );
ALTER TABLE Documents ADD CONSTRAINT Document_PK PRIMARY KEY ( ID ) ;
COMMENT ON TABLE Documents IS 'Store the f
email_address_of_user,
p_template_static_id => 'MYTEMPLATE',
p_placeholders => ... lassen sich Bilder in die E-Mail integrieren, die ID des Bildes wird zuvor mit eine eigenen Directive ... ompany Logo" >
</code>
Nun muss das Bild mit der ID my_company.jpg in der Mail eingebettet werden und... ql>
..
IS
..
cursor c_news_letter_images(p_app_id number)
is
select replace(filename,'newslet
lect version, status from dba_registry where comp_id='ORDIM';
VERSION ... ok
<code sql>
CREATE TABLE CONBOOK.CON_IMAGES
(
ID NUMBER(13),
name VARCHAR2(256) ... ADD (
CONSTRAINT CON_IMAGES_PK
PRIMARY KEY
(ID)
ENABLE VALIDATE);
</code>
=== Daten in die Ta... sql>
CREATE OR REPLACE procedure loadConImg (p_id number , p_name varchar2 , p_remark varchar2)
as
<code sql>
select *
from tab1, tab2
where tab1.id = tab2.id;
</code>
Die Verknüpfungsbedingung wird im Where Bereich des Statmenets wie eine Filter Be... ULL OUTER | NATURAL | CROSS ] JOIN Tab2
ON T1.id = T2.id
where
tab1.filter = filter_bedingung
</code>
Vorteil:
* Es ist deutlich klarer, welc
der ADMIN Gruppe. In dieser Tabelle ist auch die ID der Maske hinterlegt mit der die Pflege erfolgen ...
<code sql>
apex_debug.message('app_component_id = ' || :APP_COMPONENT_ID);
apex_debug.message('app_component_name = ' || :APP_COMPONENT_NAME);
... ct replace(regexp_substr(entry_target, '[f?p=&APP_ID.:][[:digit:]]+[:]'),':','')
into v_page_l
iel einer Test Tabelle:
--
create table rawtest (id number, wert long raw);
--
-- 1 Test mit hex An... -
create or replace function readRawtoVarchar2(p_id number)
return varchar2
as
v_raw long raw;
v_re... in
select wert into v_raw
from rawtest where id=p_id;
v_return:=utl_raw.cast_to_varchar2(v_raw);
-- je nach dem wie der Zeichensatz der U
TE(
select emp.PHONE_NUMBER
, DEPARTMENT_ID
from EMPLOYEES emp inner join departments dept using (DEPARTMENT_ID)
where dept.DEPARTMENT_NAME='IT'
)
SET PHONE_NUMBER = '0890000'||to_char(DEPARTMENT_ID)
/
</code>
Alternativ traditionell:
<code SQL>
U... R = '0890000'|| ( select to_char(dept.DEPARTMENT_ID)
from dep
eine Applikationen:
<code sql>
select application_id
,application_name
,count(page_id)
from APEX_050000.APEX_APPLICATION_PAGES
group by application_id,application_name order by 1
/
</code>
----
====... 34
http://localhost/ords/wwv_flow.show?
p_flow_id=100
&p_flow_step=2
&p_instance=23232323
&p_arg
n kriterium
--
create table t as select rownum as id
, '1' as mandant from all_...
insert into t select rownum as id
, '1' as mandant from all_o... en in der Tabelle erzeugen
--
delete from t where id between 10 and 40;
delete from t where id between 999 and 1000;
delete from t where id between 7899
tex_pk on vertex(name);
create table edge ( edge_id number, Name_from varchar2(1), Name_to varchar2(... 6));
create unique index idx_edge_pk on edge(edge_id);
create sequence seq_edge;
insert into vertex v... ion / Verification of Spatial 10g / 11g /12c (Doc ID 270588.1)
bzw. Information Center: Oracle Spatial Installation and Upgrade (Doc ID 1551262.2)
=== EXTENDED VARCHAR2 in der DB akti
rtment Table vorkommt:
<code sql>
select EMPLOYEE_ID,FIRST_NAME
from EMPLOYEES e
LEFT JOIN DEPARTMENTS d ON ( nvl(e.DEPARTMENT_ID,'-1') = d.DEPARTMENT_ID)
where d.DEPARTMENT_ID is null;
</code>
(nvl wird nur benötigt falls die Join Bedingung Null Values
für jeden Datensatz die Abfrage zu vermeiden, die ID's können 16 stellen enthalten:
<code sql>
declare
type t_emp_lookup_tab is table of emp_lookup.id%type INDEX BY varchar2(16);
v_emp_lookuptab ... ookup_tab;
cursor c_emp_lookup
is
select id
, max (deptno) as deptno
from emp_deptno_lookup
group by id
order by id;
begin
for rec in c_emp_lookup
se Reference 11g R2]] )
* **PLSQL_ENTRY_OBJECT_ID** - Object ID of the top-most PL/SQL subprogram on the stack (or NULL if there is no PL/SQL subprogram on the stack)
* **PLSQL_ENTRY_SUBPROGRAM_ID** - Subprogram ID of the top-most PL/SQL subprogram on the stack (or NULL if there is no PL/SQL subpr