On 3/23/11, oracle-plsql+nore...@googlegroups.com <oracle-plsql+nore...@googlegroups.com> wrote: > ============================================================================= > Today's Topic Summary > ============================================================================= > > Group: oracle-plsql@googlegroups.com > Url: http://groups.google.com/group/oracle-plsql/topics > > - Query [3 Updates] > http://groups.google.com/group/oracle-plsql/t/e95bd7a32d230510 > > > ============================================================================= > Topic: Query > Url: http://groups.google.com/group/oracle-plsql/t/e95bd7a32d230510 > ============================================================================= > > ---------- 1 of 3 ---------- > From: gayathri Dev <gd0...@gmail.com> > Date: Mar 22 11:34AM -0700 > Url: http://groups.google.com/group/oracle-plsql/msg/6aa5bfc4901235e9 > > 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 = > > ---------- 2 of 3 ---------- > From: Rodrigo Mesquita <rodrigomotamesqu...@gmail.com> > Date: Mar 22 03:38PM -0300 > Url: http://groups.google.com/group/oracle-plsql/msg/6e1f69fcc2e88a42 > > put a variable insted of a fixed text > > > > ---------- 3 of 3 ---------- > From: Michael Moore <michaeljmo...@gmail.com> > Date: Mar 22 02:54PM -0700 > Url: http://groups.google.com/group/oracle-plsql/msg/fb9c84533f86a207 > > how about > > SELECT > case > when t2.col21 = ts and t2.col22 = 1 then 'No Action' > else t1.col14 > end as Task > FROM > tab1 t1, > tab2 t2, > > > > -- > 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
-- Sent from my mobile device -- 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
