<< Seleccionar la fecha mas grande de dos tablas select Max(date1) | Home | Enviar un email con script task dtsx >>
if Exists pl/sql
Posted on Friday, September 25, 2009 6:56 AM

Verificamos la cantidad en la tabla mensaje, si existe, (devuelve 1 si existe)
select count(*) from mensaje m where exists(select 1 from ordenes o )
andm.mensaje=:var1

One Comment Filed Under [ code inside ]

Comments

# re: if Exists pl/sql
Gravatar This is exactly what I needed!
Left by Remote Monitoring System on 2/3/2011 9:18 PM

Leave Your Comment

Title*
Name*
Email (never displayed)
 (will show your gravatar)
Url
Comment*

 

Preview Your Comment.