Oracle中的有用查询

1、利用Oracle获取毫秒级（4位）序号： select To_char(SysTimestamp,'YYYYMMDDHH24MMSSFF4') from dual;

 

2、产生10000～99999之间的随机数： select Trunc(dbms_random.value(10000,99999)) from dual;

 

3、从查询语句中创建临时表：Create global temporary table TmpTbl on commit delete rows as select * From FP2_PATH ;

 

4、从其他表中复制记录到当前表：Insert Into TableName (Select * from OldTable)