Hi Andrej Hopko. Can u tell me how it is & Some Material on regular expressions if possible
On Jan 8, 8:47 pm, Andrej Hopko <ado.ho...@gmail.com> wrote: > 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
