DB:11.2.0.30 将普通表转换为区分表 一.利用原表重建分区表SQL>create table yoon ( id number primary key ,time date ); Table created. SQL>insert into yoon select rownum,created from dba_objects; 74930 rows created. SQL>select count(*) from yoon;COUNT(*)----------74930 S
linux 时间戳 转date: 创建自定义函数: create or replace function unix_to_oracle(in_number number) return date is begin ,))); end unix_to_oracle; 使用: ) from dual; date 转linux时间戳: create or replace function oracle_to_unix(in_date in date) return number is
CREATE OR REPLACE VIEW PDAORDER AS SELECT po.id id, po.order_no AS order_no, po.money AS money, (SELECT TO_CHAR(t.starttime / (1000 * 60 * 60 * 24) + TO_DATE('1970-01-01', 'YYYY-MM-DD'), 'YYYY-MM-DD') as starttime FROM Pda_Order t WHERE t.id = po.id)
使用函数的方式 1. 创建的函数以及类型如下: CREATE OR REPLACE TYPE str_split IS TABLE OF VARCHAR2 (4000);CREATE OR REPLACE FUNCTION splitstr(p_string IN VARCHAR2, p_delimiter IN VARCHAR2) RETURN str_split PIPELINEDAS v_length NUMBER := LENGTH(p_string); v