Skip to content

Latest commit

 

History

History
33 lines (17 loc) · 652 Bytes

File metadata and controls

33 lines (17 loc) · 652 Bytes

insert into t_number values(6,23.4564,123556);

select abs(n1) from t_number;

select round(n1,2) from t_number;

select ceil(-12.3) from dual;

select floor(-12.3) from dual;

select mod(5,3) from dual;

select sign(-100) from dual;

select sqrt(9) from dual;

select power(2,3) from dual;

select trunc(123.456,2) from dual;

123.45

select to_char(123.45,'9999.999') from dual;

select to_char(123123,'99,999,999.99') from dual;

select to_char(123123.3,'FM99,999,999.99') from dual;

select to_char(123123.3,'FM$99,999,999.99') from dual;

select to_char(123123.3,'L99,999,999.99') from dual;

select to_char(123123.3,'FM99,999,999.99C') from dual;