Database
文章平均质量分 68
假装80后
一个不念过去,不畏将来的程序员
展开
-
转载: SQL面试题
<br />转载自: http://blog.csdn.net/Leon110/archive/2009/07/20/4362436.aspx<br /> <br /> <br /> <br /> <br />题目1 <br />问题描述:<br />为管理 岗位业务培训 信息,建立3个表:<br />S (S#,SN,SD,SA) S#,SN,SD,SA 分别代表学号、学员姓名、所属单位、学员年龄<br />C (C#,CN ) C#,CN 分别代表课程编号、课程名称<br />SC ( S#,C转载 2010-06-07 15:59:00 · 764 阅读 · 0 评论 -
DB2 Passing transition tables from trigger to stored procedure
欢迎使用Markdown编辑器写博客本Markdown编辑器使用StackEdit修改而来,用它写博客,将会带来全新的体验哦: Markdown和扩展Markdown简洁的语法 代码块高亮 图片链接和图片上传 LaTex数学公式 UML序列图和流程图 离线写博客 导入导出Markdown文件 丰富的快捷键 快捷键 加粗 Ctrl + B 斜体 Ctrl + I 引用 Ctrl原创 2016-11-04 22:38:33 · 500 阅读 · 0 评论 -
Oracle/DB2 null key index
(Index key is null means all fields in an index are null.) In DB2 only one NULL key may exist in a unique index. When table and index are created as CREATE TABLE TAB ( A DECIMAL(6原创 2016-10-16 12:59:06 · 1179 阅读 · 0 评论 -
SQL Function for DB2 and ORA
SQL Function in DB2 9 (UDF=user defined function) DB2 9 and earlier, your could only has RETURN statement in your UDF logic. (This is a too limited design) • RETURN can’t contain a SELECT sta原创 2016-11-12 09:15:07 · 399 阅读 · 0 评论 -
JDBC query table definition
JDBC retrieve table columns information public void describeTable(String tableName) { try { PreparedStatement pstmt = conn .prepareStatement("select * from原创 2016-11-19 14:31:22 · 454 阅读 · 0 评论 -
DB2 C language external scalar user-defined function
Sample step of define a C language external scalar user-defined function. 1. Define function implementation using C language $ cat mymd5.c #include #include #include #include #include #i原创 2016-11-26 08:32:00 · 490 阅读 · 0 评论 -
DB2 how to drop overloaded functions
When you try to drop an overloaded function/procedure, DB2 will report a SQL0476N error code. For example: if function MY_TOCHAR is overloaded with CREATE FUNCTION MY_TOCHAR(P DATE) RETURNS VARCHA原创 2016-11-26 08:36:48 · 1032 阅读 · 0 评论