Oracle 常用记忆

1、备份整表数据

  
 create table [备份名] as select * from [表名]; 

2、数字格式化

 select to_char(123666666.21,'FM999,999,999,999,999.00') from dual ;