Sunday, February 9, 2020

Order By REGEX exp

select * from RES_MSTPLOTMASTER order by
regexp_substr(NVL (plotnumber, PLOTNUMBER), '^\D*') nulls first,
  to_number(regexp_substr(NVL (plotnumber, PLOTNUMBER), '\d+'))
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Ad hoc queries

 select max(cast(convert(varchar, convert(datetime, [CR_DATE], 103), 101) as date))  from OPENDATASOURCE (        'SQLNCLI'         ...

  • EMAIL WITH C#
    private void sendMail()     {         MailMessage msg = new MailMessage();         string ToMail = "*******@gmail.com";      ...
  • Order By REGEX exp
    select * from RES_MSTPLOTMASTER order by regexp_substr(NVL (plotnumber, PLOTNUMBER), '^\D*') nulls first,   to_number(regexp_subs...
  • Difference Between SOAP And REST
       SOAP And REST😋 SOAP REST Slower due to defined specification Faster as there is no defined specifications Request and response format is...