Hi You may also think about using REGEXP_LIKE function, where you just specify that column contains only non-zero repetitions of *
regards hoppo (from phone) Dňa 8.1.2012 16:10, "SANDEEP REDDY" <tosandeepyan...@gmail.com> napísal(-a): > HI srky59 & seçil demircan > > > Thanks for showing interest in my query. It helps me a > lot. > > Thanks once again > > > > > On Jan 7, 9:08 pm, seçil demircan <secildemirc...@gmail.com> wrote: > > For all columns or a particular column > > for particular column,may be this query can be > > > > select * from tablename where nvl(replace (columnname,'*',''),'.') ='.' > > > > 2012/1/7 SANDEEP REDDY <tosandeepyan...@gmail.com> > > > > > > > > > > > > > > > > > I have a table like this > > > > > S.no Name Address > > > ------- ---------- --------------- > > > > > 1 a 7a, chennai > > > 2 b madras,chennai** > > > 3 c *****chengal > > > 4 d ***** > > > 5 e *** > > > 6 f * > > > > > HI, i need to get output that contains only *'s ( only * but no > > > alphanumeric & special characters) > > > > > I didn't get any idea. > > > > > -- > > > 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 > -- 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
