D NUMBER (30) NOT NULL ,
Filename VARCHAR2 (512 CHAR) NOT NULL ,
Fil... 'Primary Key' ;
COMMENT ON COLUMN Documents.Filename IS 'Name of the file on disk' ;
COMMENT ON COLUMN Documents.FileTyp IS 'Typ of the file' ;
COMMENT ON... create table thesaurus(
id number(11) not null
,name varchar2(255) not null
,description varchar2(20
D NUMBER (30) NOT NULL ,
Filename VARCHAR2 (512 CHAR) NOT NULL ,
Fil... 'Primary Key' ;
COMMENT ON COLUMN Documents.Filename IS 'Name of the file on disk' ;
COMMENT ON COLUMN Documents.FileTyp IS 'Typ of the file' ;
COMMENT ON... esult = str.replace(result, "\\n", "")
escFileName = str.replace(str(file), "\\", "\\\\") + "; "
B_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_co
nux 8 Basis System einrichten und Konfigurieren - Name und IP Adresse sollten sich auf keine Fall je wie...
ALTER PLUGGABLE DATABASE ans SAVE STATE;
SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM V$PDBS;
ALTER SESSION SET CONTAINER = FREE;
SHOW CON_NAME
</code>
=== Autostart einrichten ===
=> [[dba... ss to the status pages only
<code xml>
<role rolename="manager-gui"/>
<user username="tomcat" password=
acle Multimedia 12c (seit 8i / 11g noch unter dem Namen Oracle interMedia vertrieben) steht dem Apex Ent... BLE CONBOOK.CON_IMAGES
(
ID NUMBER(13),
name VARCHAR2(256) NOT NULL... OR REPLACE procedure loadConImg (p_id number , p_name varchar2 , p_remark varchar2)
as
v_img_orig O... on the img object
insert into CON_IMAGES (ID, NAME, REMARKS,img,preview)
values (p_id,p_name,
DDE_SK number(15) NOT NULL
, NAME VARCHAR2(400) NOT NULL
, FILENAME VARCHAR2(400)
, MIME_TYPE ... 00):='Prozessing File Insert'||'<br/>';
v_filename varchar2(512);
v_id number;
begin
if :... --- Put your own logic in here
v_filename:=:P3400_IMPORT_FILE;
v_message:= v_mess
der Apex Applikation getestet werden.
Der Domain Name des User wird in den HTTP Header geschrieben (sie... ws Anmeldung bzw. in Prinzip nur der Windows User Name wird an die Single Sign On Konfiguration von Apex... | Authentication Schemes anlegen}}
* Nun einen Namen vergeben und die Methode **HTTP HEADER Variable*... }}
* Hinterlegen in welchen Header Feld der Username steht {{ :prog:apex:apex_single_sign_on_04.png?di
Beispiel:
<code sql>
select *
from ( select d.dname
, COUNT (*) as percount
... where d.deptno = e.deptno
group by d.dname
)
pivot (
MAX (percount)
for dname
in ('ACCOUNTING' as ACCOUNTING
... <code sql>
SQL>SELECT *
2 FROM ( SELECT d.dname
3 , count (*) AS percount
4
e
TYPE varchar2_t IS TABLE OF VARCHAR2(2000);
v_name_a varchar2_t;
v_name_b varchar2_t;
v_name_diff varchar2_t;
v_all varchar2_t;
v_sort varchar2_t;
v_idx pls_integer;
begin
v_name_a:=varchar2_t('C','B','A');
v_name_b:=varchar
ages(p_app_id number)
is
select replace(filename,'newsletter_images/','') as filename
, blob_content
, mime_type
, replace(filename,'newsletter_images/','') as content_id
from ape... cation_files
where flow_id = p_app_id
and filename like 'newsletter_images/%';
..
begin
for r
Section dependencies)
* compile '<main Class>:<Name of Jar File>:<Version> wie zum Beispiel "compile ... /local Files System
flatDir {
//use a name you can reference this later
name "JDBCDriver"
dirs "D:/entwicklung/libraries/OracleJDB... //Productive dependencies
// Main Class - Name (Name of the Jar) - Version
compile 'oracle.u
s to the status pages only
<code xml>
<role rolename="manager-gui"/>
<user username="tomcat" password="geheim" roles="manager-gui"/>
</code>
===Tomcat start... -INF\web.xml:
<code xml>
<context-param>
<param-name>config.dir</param-name>
<!-- Enter the location where configuration settings should be stored -->
<