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
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
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,p_remark,ORDImage(),ORDSYS.ORDImage.init())
RETU
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
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... }}
* Hinterlegen in welchen Header Feld der Username steht {{ :prog:apex:apex_single_sign_on_04.png?di... pex:apex_authentication_scheme_set_post_procedure_name_v01.png | 'Post-Authentication Procedure Name' hi
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=
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
HOME%\cmd\git.exe" commit -m "Commit done by %USERNAME% at %DATE% %TIME%"
"%GIT_HOME%\cmd\git.exe" push
... E\cmd\git.exe" commit -m "Commit done by $env:UserName at $datum"
& "$ENV:GIT_HOME\cmd\git.exe" push
</... ndt als User Home den Windows Pfad (C:\Users\<username>) und legt dort die .gitconfig an.
Globale Konf... figuration:
<code bash>
git config --global user.name "Gunther Pippèrr"
git config --global user.email
interlegen im Parameter F4550_P1_COMPANY:WORKSPACENAME ==
WORKSPACENAME durch den eigenen Names des Workspaces ersetzen
<code>
https://myapexserver/ords/f?p=4550:1:::::F4550_P1_COMPANY:WORKSPACENAME
</code>
==LOGIN Seite aufrufen über LOGIN_DES... t owner,object_type from dba_objects where object_name='F';
Owner | Object Type
PUBLIC SYNONYM