It will return skeleton calls that can recreate a
... tall or upgrade ORDS in the database only
[2] Create or update a database pool and install/upgrade ORDS in the database
[3] Create or update a database pool only
Choose [2]: 2
e Automation ===
{{ :prog:apex:apex_automations_create_automations_uebersicht_v01.jpg?600 | Oracle APEX ...
Das Schema in der die APP läuft muss das Rechte "create Job" besitzen!
<code sql>
# als SYS
grant create job to GPI;
</code>
=== Anlegen über die APEX Ober... ic - Automations“
{{ :prog:apex:apex_automations_create_automations.jpg?300 | Oracle APEX Automations anl
Beispiel ====
Ein sehr simples Macro:
<code sql>
create or replace function customerId
return varchar2
SQ... ...
=== Ein komplexeres Bespiel ===
<code sql>
create table Kunden(
SK number(11) GENERATED BY DEFAU... werden.
== Lösung PLSQL nativ ==
<code plsql>
create or replace function getInteralKDNr( p_institut... in SQL Macro umwandeln
Das SQL Macro:
<code sql>
create or replace function getInteralKDNrSQM
return varc
izieren:
<code sql>
-- as sys
-- grant rights to create the index
connect sys as sysdba
grant CTXAPP to gpi
connect gpi/gpi
create table texte ( id number(11) primary key, text var... ddl.drop_preference( 'gpi_lexer');
begin
ctx_ddl.create_preference( 'gpi_lexer', 'BASIC_LEXER' );
ctx_ddl... DROP_SECTION_GROUP('gpi_section');
begin
ctx_ddl.create_section_group ('gpi_section', 'NULL_SECTION_GROUP