kusturica

Greenhorn
+ Follow
since Oct 01, 2002
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by kusturica

Hi everybody!
We have a problem which stops our server(orion):
"inconsistent thread". Have you ever seen something like this? what can we do in order to solve this error?
I would be very thankful if someone could make me a suggestion.
21 years ago
Hi all!
I have the following:
SELECT pre.id_preaviso, pre.num_preaviso, TO_CHAR(pre.f_inip,'dd/mm/yyyy') f_inip,
TO_CHAR(pre.f_presentacion,'dd/mm/yyyy') f_presentacion, c.nss, pre.nom_centro,
pre.id_via, pre.via_nombre, pre.via_num, pre.via_num_bis, pre.via_escalera,
pre.via_planta, pre.via_puerta, pre.localidad, pre.rama,pre.autonomia,
pre.provincia,pre.municipio,pre.comarca,pre.delegacion,pre.sector,pre.subsector,
ap.id_acta FROM preavisos pre,centros c, actas_preavisos ap
WHERE (ap.id_preaviso(+) = pre.id_preaviso) AND (pre.id_centro = c.id_centro)
AND pre.num_preaviso IS NULL
AND ROWNUM <= 1001
How could I make (ap.id_preaviso(+) = pre.id_preaviso) in a different way, faster?

Thanks .