Friday, April 4, 2014

oracle snippet for sorting by ip address 


select n from t1 order by regexp_replace(regexp_replace(n, '(\d+)', '00\1'), '0*(\d{3})', '\1');
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)
  • Golang Calling Stack
      package main import ( "fmt" "runtime" ) func main() { aa() } func aa() { bb() } func bb() { cc("hello...
  • TimescaleDB
    https://docs.timescale.com/timescaledb/latest/#welcome-to-the-timescaledb-documentation TimescaleDB is a time-series database, built on top ...
  • Python Multiprocessing Snippet
     You can use a pool of worker processes and a Manager instance to manage access to tf_dict and df_dict dictionaries which are shared betwe...