/*Append*/ hint

[pat_laeda]

Does DOA supports /*append*/ hint for insert data?
I use TOracleQuery.ExecuteArray() for insert, but size of table segment still growing like /*append*/ hint doesn't use.

--insert
insert /*APPEND*/ into T1 (DATETIME_, p_01, s_01) values d, , :s)

-- get size of segment
select sum(bytes)/1024/1024 from dba_segments where segment_name='T1'

-- create table
create table T1
(
DATETIME_ TIMESTAMP(6),
P_01 NUMBER,
S_01 NUMBER
) compress

 

[Marco Kalter]

You can use any hint you like. The TOracleQuery will send the SQL.Text to the server without any modification.

Note however that you need to precede the append hint with a + as usual:

insert /*+APPEND*/ into T1 (DATETIME_, p_01, s_01) values d, , :s)