Sub extraire()
Dim cel As Range
For Each cel In Range("a2:a50")
cel.Offset(0, 1).Value = Split(Trim(cel.Value), " ")(0)
cel.Offset(0, 2).Value = Split(Trim(cel.Value), " ")(1)
cel.Offset(0, 3).Value = Split(Trim(cel.Value), " ")(2)
Next
End Sub_tab%22%7D">blablabla</a></div><a class=".....
_tab%22%7D">blobloblo</a></div><a class="....
...etc...blablabla
blobloblo create or replace trigger trig_cli
after update of nom on client for each row
declare
v_filehandle utl_file.file_type;
cursor cli Is
select * from client;
begin
v_filehandle :=utl_file.fopen('MY_DOCS','j2ee.txt','w');--Opening a file
for v_cli_rec IN cli LOOP
utl_file.putf(v_filehandle,'clients %s : %s\n',v_cli_rec.nom,v_cli_rec.prenom);
end loop;
UTL_FILE.fclose(v_filehandle);
end trig_cli;
CREATE TABLE Main (
k1 int,
k2 bigint,
datage timestamp,
champ1 text,
ts_champ1 tsvector, -- ts_champ1=to_tsvector('english',champ1)
champ2 text,
PRIMARY KEY(k1, k2)
);
CREATE INDEX main_datage_idx ON Main USING btree(datage);
CREATE INDEX main_champ1_idx ON Main USING gin(ts_champ1) WITH ( fastupdate=on );
EXPLAIN ANALYZE
SELECT k2 FROM Main WHERE
k1=1 AND champ1 ~* 'm1.*m2.*m3' AND champ2 ~* 'm4';
----------------------------------------------------------------------------------
Index Scan using main_pkey on main (cost=0.00..8681.10 rows=1 width=8) (actual time=25.779..111.146 rows=32 loops=1)
Index Cond: (k1 = 1)
Filter: (((champ1)::text ~* 'm1.*m2.*m3'::text) AND (champ2 ~* 'm4'::text))
Rows Removed by Filter: 4921
Total runtime: 111.255 ms
EXPLAIN ANALYZE
SELECT k2 FROM Main WHERE
k1=1 AND ts_champ1 @@ to_tsquery('english','m1 & m2 & m3') AND champ2 ~* 'm4';
----------------------------------------------------------------------------------
Bitmap Heap Scan on main (cost=894.12..950.09 rows=1 width=8) (actual time=424.047..426.501 rows=32 loops=1)
Recheck Cond: ((k1 = 1) AND (ts_champ1 @@ '''m1'' & ''m2'' & ''m3'''::tsquery))
Rows Removed by Index Recheck: 1169
Filter: (contenu ~* 'm4'::text)
Rows Removed by Filter: 120
-> BitmapAnd (cost=894.12..894.12 rows=14 width=0) (actual time=423.993..423.993 rows=0 loops=1)
-> Bitmap Index Scan on main_pkey (cost=0.00..201.02 rows=8352 width=0) (actual time=0.589..0.589 rows=4953 loops=1)
Index Cond: (k1 = 1)
-> Bitmap Index Scan on main_champ1_idx (cost=0.00..692.85 rows=6514 width=0) (actual time=423.281..423.281 rows=122056 loops=1)
Index Cond: (ts_champ1 @@ '''m1'' & ''m2'' & ''m3'''::tsquery)
Total runtime: 426.600 msSELECT k2 FROM Main WHERE
k1=? AND champ1 ~* 'm1.*m2.*m3' AND champ2 ~* 'm4'
AND datage>=?aff=(Label(Fenetre, text="Entrez la valeur du point de fuite : ", fg='blue', font='14').grid(row=13))
aff=(Label(Fenetre, text=" ", fg='blue', font='14').grid(row=13))public void insertComponent(Component c)textPane.setText("<HTML><head></head><body>Du texte...</body></HTML>");
JMathComponent m = new JMathComponent();
m.setContent("<math><mfrac><mi>2</mi><mi>4</mi></mfrac></math>");
textPane.insertComponent(m);
textPane.revalidate();
public void revalidate()