1.类型转换 --Oracle select to_number('123') from dual; --123; select to_char(33) from dual; --33; select to_date('2004-11-27','yyyy/mm/dd') from dual;--2004-11-27 --Mysql select cast('123' as signed integer ); --123 select cast(33 as char (2) ...
CREATE OR REPLACE FUNCTION F_PINYIN(P_NAME IN VARCHAR2) RETURN VARCHAR2 AS V_COMPARE VARCHAR2(100); V_RETURN VARCHAR2(4000); FUNCTION F_NLSSORT(P_WORD IN VARCHAR2) RETURN VARCHAR2 AS BEGIN RETURN NLSSORT(P_WORD, 'NLS_SORT=SCHIN ...
merge into 解决用 B 表跟新 A 表数据，如果 A 表中没有，则把 B 表的数据插入 A 表； 语法： MERGE INTO USING ( ) ON ( AND ...) WHEN MATHED THEN WHEN NOT MATHED THEN Merge Into emp_bak&nbs ...
在服务器上安装oracle11.1.0.7数据库。在用dbca创建数据库时，报告如下错误： ORA-12801: error signaled in parallel query server P073. ORA-00018: maximum number of sessions exceeded ORA-06512: at “SYS.UTL_RECOMP”, line 629 ORA-06512: at “SYS.UTL_RECOMP”, line 671 ORA-06512: at line 1 经过检 ...
文章
相册