ST Data Services - Interactive Install
Enter a number to select the type of installation
[1] Instal... te a database pool only
Choose [2]: 2
Enter a number to select the database connection type to use
... ADATA and ORDS_PUBLIC_USER [TEMP]: TEMP
Enter a number to select additional feature(s) to enable:
[1... tabase API
[5] None
Choose [1]: 5
Enter a number to configure and start ORDS in standalone mode
44
Server built: Mar 4 2021 21:49:34 UTC
Server number: 9.0.44.0
..
</code>
**ORDS Version vor 22:**
<... ST Data Services - Interactive Install
Enter a number to select the type of installation
[1] Instal... te a database pool only
Choose [2]: 2
Enter a number to select the database connection type to use
... thin:@//10.10.10.90:1521/SRV_GPIDB_MAIN
Enter a number to select additional feature(s) to enable:
[1
..
IS
..
cursor c_news_letter_images(p_app_id number)
is
select replace(filename,'newsletter_ima... plsql>
..
IS
cursor c_get_attachment(p_file_id number)
is
select f.FILENAME
, f.... Resource
cursor c_news_letter_images(p_app_id number)
is
select replace(filename,'newsletter_gpi... ument store
cursor c_get_attachment(p_file_id number)
is
SELECT f.FILENAME
, f.
TE OR REPLACE
PROCEDURE sleep_plsql(p_seconds IN NUMBER)
IS
v_parts pls_integer;
v_LastRound pls_inte... r replace PROCEDURE sleep_java(p_milli_seconds in number)
AS
LANGUAGE JAVA NAME 'java.lang.Thread.sl... dt:
<code sql>
PROCEDURE sleep_plsql(p_seconds in number)
is
v_parts pls_integer:=0;
v_LastRound pls_
es.htm#AELIG7204 )
* jdbc.InitialLimit => the number of DB connections that will be created when the s... is started
* jdbc.MaxLimit => the maximum number of connections
Bei diesen Parameter ist zu bea
pecify the database connection type to use.
Enter number for [1] Basic [2] TNS [3] Custom URL [1]:1
Ent... password for immohaus:
Confirm password:
Enter a number to select a feature to enable:
[1] SQL Develop
_pk on vertex(name);
create table edge ( edge_id number, Name_from varchar2(1), Name_to varchar2(1) ,val... ration.
,num_hash_ptns => 16 -- Number of hash partitions used to partition the vertices... ^
| VID | NUMBER |Vertex IT ... |
| T | NUMBER(38) |Property value type see h
<code sql>
with
function add_weeks(p_d date,p_w number)
return date
is
begin
return ( p_d + (7*p_w... ente Datentypen: INTERVAL DAY TO SECOND erwartet, NUMBER erhalten"** ...
Wie kann ich nun mit dem Timest... nuend TIMESTAMP , p_Subtrahend TIMESTAMP ) RETURN NUMBER IS
v_Difference INTERVAL DAY TO SECOND ;
v_Seconds NUMBER ;
BEGIN
v_Difference := p_Minuend - p_Subtrahe