SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
with tab(pn) as (select '7(900) 123 34 56' from dual union select '7-900-123-34-57' from dual union select '9001233458' from dual --Как привести телефоны к виду: +7(900)-123-34-56 ) ,m_tab(pn) as (select lpad(replace(trim(translate(pn, '() -.+', '*')), '*'),11,'7') from tab ) select pn--'+'||substr() from m_tab
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear