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
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