oracle常用函数

字符串转日期：select to_date('2008-8-25','yyyy-mm-dd') from dual;
日期转字符串：select to_char(sysdate,'yyyy-MM-dd HH24:mi:ss') from dual;
生成UUID：select sys_guid() from dual;
滤空函数：select nvl(null,0) from dual;
select decode('1','0','yes','no') from dual;

日期转字符串：select to_char(sysdate,'yyyy-mm-dd HH24:MI:SS') from dual;


oracle导入、导出：
1、用sys用户连接后

--建立表空间
CREATE TABLESPACE szxy
DATAFILE 'szxy.DBF' size 10m autoextend on next 10m maxsize 32767m
DEFAULT
STORAGE (
INITIAL 8K
NEXT 16K
PCTINCREASE 0
) ;

--建立用户
create user szxy identified by szxy default tablespace szxy;
grant connect to szxy;
grant dba to szxy;
grant resource to szxy;
grant select any table to szxy;
grant create any table to szxy;


用szxy用户连接成功后再进行下面操作

2、运行cmd 进入命令行后
imp szxy/szxy@orcl file=D:\szxy.dmp full=y