put a variable insted of a fixed text On Tue, Mar 22, 2011 at 3:34 PM, gayathri Dev <gd0...@gmail.com> wrote:
> Hi All, > > I would like to know if in the Query below can be modified to keep the > string "text_sample" in one place? > > > SELECT > case > when t2.col21 = 'text_sample' and t2.col22 = 1 then 'No Action' > else t1.col14 > end as Task > FROM > tab1 t1, > tab2 t2 > where > (t1.col11 = 'text_sample' or (t2.col21 = 'text_sample' and t2.col22 = > 1)) > and t2.col23 = t1.col13; > > Thanks, > G > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
