Oracle整理

--表授权
GRANT
SELECT ON "FLXUSER"."CST_ARMY_INSPECT" TO "APP_READER_FLXUSER";
GRANT DELETE, INSERT,
SELECT , UPDATE ON "FLXUSER"."CST_ARMY_INSPECT" TO "APP_WRITER_FLXUSER";

--查询特定字符第一次出现的位置
select instr('123@5@7','@') from dual;--4(Number)

--查询字符串前多少个
select substr('123',0,1) from dual;--从0开始，长度为1

--with as 使用
with T1 as(
select 1 as id from dual
),T2 as(
select 2 as id from dual
)
select * from T1
union all select * from T2

--时间
select to_char(sysdate+8/24,'yyyy-mm-dd hh24:mi:ss') as nowTime from dual;