--
select last_day(add_months(sysdate,-1))
from dual
--
Visualizzazione post con etichetta tips. Mostra tutti i post
Visualizzazione post con etichetta tips. Mostra tutti i post
martedì 9 giugno 2009
How to determine if a column has non-numeric values
Imagine you have a table with many records.
How to determine if a column of this table has non-numeric values?
This is a quick method:
How to determine if a column of this table has non-numeric values?
This is a quick method:
select *
from MY_TABLE
where (LENGTH (TRIM (TRANSLATE (MY_FIELD, '0123456789', ' ') ) ) is not null)
Iscriviti a:
Post (Atom)