摘要:
序列create sequence sq_1minvalue 1maxvalue 9999999999999999999999999999start with 1increment by 1cache 2000;触发器create or replace trigger 触发器名字 before i... 阅读全文
摘要:
1、ORDER BY 中关于NULL的处理缺省处理,Oracle在Order by 时认为null是最大值,所以如果是ASC升序则排在最后,DESC降序则排在最前。当然,你也可以使用nulls first 或者nulls last 语法来控制NULL的位置。 Nulls first和nulls la... 阅读全文
摘要:
SQL代码 列转行selectREGEXP_SUBSTR(a.rolecode ,'[^,]+',1,l)rolecodefrom (select 'a,aa,aaa' rolecode from dual) a,(SELECT LEVEL l FROM DUAL CONNECT BY LEVEL<... 阅读全文
摘要:
ORACLE代码CREATE OR REPLACE PROCEDURE gd_CURSOR(MYCS1 OUT SYS_REFCURSOR,MYCS2 OUT SYS_REFCURSOR,a out varchar)asBEGIN a:='test'; OPEN MYCS1 FOR SELEC... 阅读全文
摘要:
mssql server 返回多表结果集mssqlserver 代码create PROCEDURE [dbo].[gd]ASBEGIN SELECT 1,12 SELECT 21,22ENDC#代码 using (SqlConnection conn = new SqlConne... 阅读全文