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
</code>
siehe auch => https://www.linuxtechi.com/create-extend-xfs-filesystem-on-lvm/
----
==== Datenba...
<code sql>
ALTER SESSION SET CONTAINER = ans;
CREATE TABLESPACE APEX DATAFILE '/opt/oracle/oradata/FRE... 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
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